error message
rezwoan faisal[2023-01-14 22:57:22,571] ERROR in app: Exception on / [GET]
Traceback (most recent call last):
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: subject
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask/app.py", line 2525, in wsgi_app
response = self.full_dispatch_request()
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask/app.py", line 1822, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask/app.py", line 1820, in full_dispatch_request
rv = self.dispatch_request()
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask/app.py", line 1796, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
File "/home/rex/Projects/test/index.py", line 48, in index
subjects = Subject.query.all()
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2773, in all
return self._iter().all()
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/orm/query.py", line 2916, in _iter
result = self.session.execute(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/orm/session.py", line 1714, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1705, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 334, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1572, in _execute_clauseelement
ret = self._execute_context(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1943, in _execute_context
self._handle_dbapi_exception(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2124, in _handle_dbapi_exception
util.raise_(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/util/compat.py", line 211, in raise_
raise exception
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: subject
[SQL: SELECT subject.id AS subject_id, subject.name AS subject_name
FROM subject]
(Background on this error at: https://sqlalche.me/e/14/e3q8)
127.0.0.1 - - [14/Jan/2023 22:57:22] "GET / HTTP/1.1" 500 -
^CTraceback (most recent call last):
File "/home/rex/Projects/test/index.py", line 82, in <module>
db.create_all()
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 868, in create_all
self._call_for_binds(bind_key, "create_all")
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 839, in _call_for_binds
engine = self.engines[key]
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/flask_sqlalchemy/extension.py", line 628, in engines
app = current_app._get_current_object() # type: ignore[attr-defined]
File "/home/rex/anaconda3/envs/flask/lib/python3.10/site-packages/werkzeug/local.py", line 513, in _get_current_object
raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.
This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.