“UPDATE”处或附近的psycopg2语法错误

错误示例:

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.ProgrammingError: syntax error at or near "UPDATE"
LINE 1: DECLARE "teste" CURSOR WITHOUT HOLD FOR UPDATE applicant SET...
                                                ^

请注意 ^ 就在右边 UPDATE . 我已经在上测试了更新脚本 pgadmin 4

剧本非常简单:

UPDATE applicant
SET cv_recrutai_entities = %s
WHERE id = %s

我的代码基本上是:

def _connect_database():
    return psy.connect(
        dbname=settings.DATABASE['DBNAME'],
        host=settings.DATABASE['HOST'],
        port=settings.DATABASE['PORT'],
        user=settings.DATABASE['USER'],
        password=settings.DATABASE['PASSWORD'],
        application_name=settings.env
    )

# Connects to database
conn = _connect_database()
# Creats a named cursor
cur = conn.cursor('test')

# Execute
cur.execute(update_script, ('{"json": "test"}', '00025ba0-748f-11e8-b0d3-d7108dd3af23'))

我已经在execute方法和参数上显式地编写了脚本,但仍然得到相同的错误:

cur.execute("UPDATE applicant SET cv_recrutai_entities = 'json here' WHERE id = '00025ba0-748f-11e8-b0d3-d7108dd3af23'")

注意,我甚至删除了第一个参数('json here')的双引号

我错过什么了吗?!