【Python】ProgrammingError: SQLite objects created in a thread can only be used in that same thread

错误:

ProgrammingError: SQLite objects created in a thread can only be used in that same thread.The object was created in thread id and this is thread

解决方式:

sqlite3.connect(fp, check_same_thread = False)

如果用了sqlalchemy,则使用connect_args

engine = create_engine('sqlite:///{url}'.format(url=url), echo=True, connect_args={"check_same_thread": False})