postgresql 使用 psycopg 准备好的语句

prepared statements using psycopg

提问by Majid Azimi

I'm a beginner at python. We use this code to execute SQL commands.

我是python的初学者。我们使用此代码来执行 SQL 命令。

cur.execute("INSERT INTO test (num, data) VALUES (%s, %s)", (100, "abcdef"))

I wonder is this prepared statement or just a client side quoting?

我想知道这是准备好的声明还是只是客户端引用？

回答by Brian

No, it does not, not for psycopg2 at least. The "Prepare" in the docs refers to a "PREPARE TRANSACTION" which is entirely different than a prepared statement.

不，它不会，至少对于 psycopg2 不会。文档中的“准备”指的是“准备交易”，它与准备好的语句完全不同。

You can emulate a prepared statement, by overriding the methods or executing extra statements, however. See: An example of psycopg2 cursor supporting prepared statements

但是，您可以通过覆盖方法或执行额外的语句来模拟准备好的语句。请参阅：支持准备语句的 psycopg2 游标示例

Please see: relevant blog entry for psycopg.

请参阅：有关 psycopg 的相关博客条目。

More information:

更多信息：

http://www.postgresql.org/docs/9.2/static/sql-prepare.html
http://www.postgresql.org/docs/current/static/sql-prepare-transaction.html

http://www.postgresql.org/docs/9.2/static/sql-prepare.html
http://www.postgresql.org/docs/current/static/sql-prepare-transaction.html

回答by SpliFF

According to the docsthe execute method will "Prepare and execute a database operation (query or command).". So yes, it is a prepared statement.

根据文档，execute 方法将“准备并执行数据库操作（查询或命令）”。所以是的，这是一个准备好的声明。