бля, ну пастбин же

меня снова смущает что тут нет ни строки твоего кода

article = Article(article_title='TITLE Article', article_text='TEXT Article')
comment = Comment(comment_name='Вася', comment_text='Какой-то отзыв', article=article)
db.session.add(article)
db.session.commit()
db.session.add(comment)
db.session.commit()
Traceback (most recent call last):
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 774, in _commit_impl
   self.engine.dialect.do_commit(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_commit
   dbapi_connection.commit()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
 File "<input>", line 1, in <module>
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\scoping.py", line 163, in do
   return getattr(self.registry(), name)(*args, **kwargs)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1042, in commit
   self.transaction.commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 508, in commit
   t[1].commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in commit
   self._do_commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _do_commit
   self.connection._commit_impl()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 776, in _commit_impl
   self._handle_dbapi_exception(e, None, None, None, None)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1517, in _handle_dbapi_exception
   util.raise_(
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
   raise exception
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 774, in _commit_impl
   self.engine.dialect.do_commit(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_commit
   dbapi_connection.commit()
sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
(Background on this error at: http://sqlalche.me/e/f405)
print(db.engine.pool)
<sqlalchemy.pool.impl.NullPool object at 0x04C3C448>
print(str(db.engine.pool))
<sqlalchemy.pool.impl.NullPool object at 0x04C3C448>base.py", line 774, in _commit_impl
   self.engine.dialect.do_commit(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_commit
   dbapi_connection.commit()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
 File "<input>", line 1, in <module>
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\scoping.py", line 163, in do
   return getattr(self.registry(), name)(*args, **kwargs)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1042, in commit
   self.transaction.commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 508, in commit
   t[1].commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in commit
   self._do_commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _do_commit
   self.connection._commit_impl()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 776, in _commit_impl
   self._handle_dbapi_exception(e, None, None, None, None)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1517, in _handle_dbapi_exception
   util.raise_(
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
   raise exception
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 774, in _commit_impl
   self.engine.dialect.do_commit(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_commit
   dbapi_connection.commit()
sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
(Background on this error at: http://sqlalche.me/e/f405)
print(db.engine.pool)
<sqlalchemy.pool.impl.NullPool object at 0x04C3C448>
print(str(db.engine.pool))
<sqlalchemy.pool.impl.NullPool object at 0x04C3C448>

ты создал два объекта ссылающихся друг на друга. потом закоммитил один, а потом уже другой.

лол, всего лишь

ну у него в коде что он выше скидывал я этого не вижу.

в смысле переиспользования объектов

поэтому откуда ошибка берется в его коде остается открытой.

article = Article(article_title='TITLE Article', article_text='TEXT Article')
comment = Comment(comment_name='Вася', comment_text='Какой-то отзыв', article=article)
db.session.add(article)
db.session.add(comment\)
 File "<input>", line 1
   db.session.add(comment\)
                          ^
SyntaxError: unexpected character after line continuation character
db.session.add(comment)
db.session.commit()
Traceback (most recent call last):
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 774, in _commit_impl
   self.engine.dialect.do_commit(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 543, in do_commit
   dbapi_connection.commit()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 752, in _rollback_impl
   self.engine.dialect.do_rollback(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 540, in do_rollback
   dbapi_connection.rollback()
sqlite3.ProgrammingError: SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
 File "<input>", line 1, in <module>
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\scoping.py", line 163, in do
   return getattr(self.registry(), name)(*args, **kwargs)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 1042, in commit
   self.transaction.commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\orm\session.py", line 508, in commit
   t[1].commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1771, in commit
   self._do_commit()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1802, in _do_commit
   self.connection._commit_impl()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 776, in _commit_impl
   self._handle_dbapi_exception(e, None, None, None, None)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1512, in _handle_dbapi_exception
   self._autorollback()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\util\langhelpers.py", line 81, in __exit__
   compat.raise_(value, with_traceback=traceback)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
   raise exception
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1512, in _handle_dbapi_exception
   self._autorollback()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 897, in _autorollback
   self._root._rollback_impl()
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 754, in _rollback_impl
   self._handle_dbapi_exception(e, None, None, None, None)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 1412, in _handle_dbapi_exception
   util.raise_(
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\util\compat.py", line 178, in raise_
   raise exception
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\base.py", line 752, in _rollback_impl
   self.engine.dialect.do_rollback(self.connection)
 File "C:\IT\P_Y\flaskblog2\venv\lib\site-packages\sqlalchemy\engine\default.py", line 540, in do_rollback
   dbapi_connection.rollback()
sqlalchemy.exc.ProgrammingError: (sqlite3.ProgrammingError) SQLite objects created in a thread can only be used in that same thread. The object was created in thread id 5776 and this is thread id 10132.
(Background o

n this error at: http://sqlalche.me/e/f405)

ну  вот тут как сказал Алекс. Хотя я думал это алхимия сама разруливает

опять же, ты заебал портянки в чат кидать

Алекс не выспался и херню сказал

при помощи чего можно подвешивать процессы с периоичностью срабатывания в месяц, например?

ошибку очевидно бросает DBAPI, которому немного срать на объекты ORM.

cron?

в смысле подвешивать?

cron \ systemd-timers?

ну вот етсь таск с частотой срабатывания раз в месяц.

ну а у него только курсоры и коннекты