无法将sqlite3查询内的变量放入文件夹中

9cbw7uwe  于 2022-12-29  发布在  SQLite
关注(0)|答案(1)|浏览(114)
def query_db(query, args=(), one=False):
    cur = get_db().execute(query, args)
    rv = cur.fetchall()
    cur.close()
    return (rv[0] if rv else None) if one else rv

就像文件上说的,我试着:

query_db("INSERT INTO users (name, email, pass) VALUES (?, ?, ?)", (name, email, password))

但没有用,我试过了

cur = get_db.cursor()
cur.execute("INSERT INTO users (name, email, pass) VALUES (?, ?, ?)", (name, email, password))

也不起作用。我怎样在请求中传递变量呢?

iyfjxgzm

iyfjxgzm1#

插入看起来是正确的。但是,在执行提交之前,任何DML操作(如insert)都只能从执行该操作的会话中看到,并且在连接终止时将隐式回退。
长话短说-commit

cur = get_db.cursor()
cur.execute("INSERT INTO users (name, email, pass) VALUES (?, ?, ?)", (name, email, password))
get_db.commit() # Here!

相关问题