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))
也不起作用。我怎样在请求中传递变量呢?
1条答案
按热度按时间iyfjxgzm1#
插入看起来是正确的。但是,在执行提交之前,任何DML操作(如
insert
)都只能从执行该操作的会话中看到,并且在连接终止时将隐式回退。长话短说-
commit
: