python - 数组值必须以 "{"或维度信息开头

Question

这是我的创建表代码:

cur.execute('CREATE TABLE IF NOT EXISTS Customers (id INTEGER PRIMARY KEY, firstName Varchar(30), lastName Varchar(30), street TEXT, city Varchar(50), state Varchar(2), zip INTEGER);')

这是我的 Upsert 函数:

def upsert_customer(customer):
    cur=conn.cursor()

    if 'id' in customer:
        cur.execute('UPDATE Customers SET firstName= %s, lastName = %s, street=%s, city=%s, state=%s, zip=%s WHERE id =%s;' , (customer['firstName'], customer['lastName'], customer['street'], customer['city'], customer['state'], customer['zip']))
    else:
        cur.execute('INSERT INTO Customers( firstName, lastName, street,city,state,zip) VALUES ( %s, %s, %s, %s, %s, %s);' , (customer['firstName'], customer['lastName'], customer['street'], customer['city'], customer['state'], customer['zip']))

    conn.commit()

当我从网页添加客户时，我收到错误消息，并在网页中显示以下错误:“内部服务器错误服务器遇到内部错误，无法完成您的请求。服务器过载或应用程序中存在错误。”

该程序是在 ElephantSQL 中完成将网页连接到我们的 PostgreSQL 的功能的实现。我不确定如何解决这个问题。

Answer 1

您的表定义与声明的错误不一致 - 您没有数组，但您清楚地看到的错误来自错误的数组定义，例如:

t=# select 'not array'::text[];
ERROR:  malformed array literal: "not array"
LINE 1: select 'not array'::text[];
               ^
DETAIL:  Array value must start with "{" or dimension information.