ProgrammingError: 在一个线程中创建的 SQLite 对象只能在同一个线程中使用

2021-12-14 00:00:00 python flask mysql sqlite

我对编程还很陌生.我之前尝试过 MySQL，但现在是我第一次在 python Flask 网站中使用 SQLite.所以也许我使用的是 MySQL 语法而不是 SQLite，但我似乎找不到问题所在.

i'm fairly new to programming. I've tried MySQL before, but now it's my first time using SQLite in a python flask website. So maybe I'm using MySQL syntax instead of SQLite, but I can't seem to find the problem.

Piece of my code: 

@app.route('/register', methods=['GET', 'POST'])
def register():
    form = RegisterForm(request.form)
    if request.method=='POST' and form.validate():
        name =  form.name.data 
        email = form.email.data
        username = form.username.data
        password = sha256_crypt.encrypt(str(form.password.data))

        c.execute("INSERT INTO users(name,email,username,password) 
        VALUES(?,?,?,?)", (name, email, username, password))

        conn.commit

        conn.close()

The error:
 File "C:Usersapp.py", line 59, in register c.execute("INSERT INTO users(name,email,username,password) VALUES(?,?,?,?)", (name, email, username, password))
 ProgrammingError: SQLite objects created in a thread can only be used in that 
 same thread.The object was created in thread id 23508 and this is thread id 
 22640

这是否意味着我不能使用姓名、电子邮件用户名和HTML 文件中的密码?我该如何解决这个问题?

Does this mean I can't use the name, email username & password in an HTML file? How do I solve this?

谢谢.

推荐答案

你的光标 'c' 不是在同一个线程中创建的；它可能是在运行 Flask 应用程序时初始化的.

Your cursor 'c' is not created in the same thread; it was probably initialized when the Flask app was run.

您可能希望以相同的方法生成 SQLite 对象(连接器和游标)，例如:

You probably want to generate SQLite objects (the conneciton, and the cursor) in the same method, such as:

  @app.route('/')
  def dostuff():
    with sql.connect("database.db") as con:
      name = "bob"
      cur = con.cursor()
      cur.execute("INSERT INTO students (name) VALUES (?)",(name))
      con.commit()
      msg = "Done"

相关文章