python Sqlite3 参数 subs

Question

我对处理我的数据库的类有一个小问题。它仍然说:

 cursor.execute(sql)
 ValueError: operation parameter must be str

我尝试了很多东西，但都没有达到我想要的效果。我看了https://docs.python.org/3.4/library/sqlite3.html我确信我也会做同样的事情。

import sqlite3

class Database():

    def __init__(self):
        try:
            self.db = sqlite3.connect('../database.sqlite')
            self.cur = self.db.cursor()
            self.cur.execute('pragma foreign_keys="1"')
        except sqlite3.Error as e:
            raise e

    def select(self,sql):

        cursor = self.db.cursor()
        cursor.execute(sql)
        records = cursor.fetchall()
        cursor.close()
        return records

    def insert(self,sql):

        cursor = self.db.cursor()
        cursor.execute(sql)
        newID = cursor.lastrowid
        self.db.commit()
        cursor.close()
        return newID

    def execute(self,sql):
    """ execute any SQL statement but no return value given """

        cursor = self.db.cursor()
        cursor.execute(sql)
        self.db.commit()
        cursor.close()

if __name__ == '__main__':
db = Database()
#sql = "SELECT skuref, titre_prod FROM product"
t = ("888888",)
sql= "UPDATE product SET created = 1 WHERE skuref = ?", t
db.execute(sql)

如果有人可以帮助我，我将不胜感激。后来我想在主程序中的 for 循环中传递类似的东西

lastpost = record[0]
if created = True
sql = "UPDATE product SET created = 1 WHERE skuref = ?",(lastpost,)                
db.execute(sql)

Answer 1

sql是一个包含SQL语句和参数的元组。

更改如下，以便sql和参数单独传递，而不是作为元组传递:

def execute(self, sql):
    """ execute any SQL statement but no return value given """
    cursor = self.db.cursor()
    cursor.execute(*sql)  # <------
    self.db.commit()
    cursor.close()