Forums

I'm having a problem with connecting to MySQL db using sqlAlchemy. Here's the error log... 2024-09-24 04:40:33,161: Exception on /cleaner [GET] Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/_collections.py", line 1008, in call return self.registry[key] KeyError: <greenlet.greenlet object at 0x7331d50197d0 (otid=0x7331d5e211e0) current active started main> NO MATCH During handling of the above exception, another exception occurred: NO MATCH Traceback (most recent call last): File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1523, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.7/site-packages/flask/app.py", line 1509, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(req.view_args) File "/usr/local/lib/python3.7/site-packages/flask_restful/init.py", line 467, in wrapper resp = resource(*args, kwargs) File "/usr/local/lib/python3.7/site-packages/flask/views.py", line 84, in view return current_app.ensure_sync(self.dispatch_request)(args, kwargs) File "/usr/local/lib/python3.7/site-packages/flask_restful/init.py", line 582, in dispatch_request resp = meth(args, kwargs) File "/home/BernardH/mysite/flask_app.py", line 33, in get cleaners = Cleaner.query.all() File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 552, in get return type.query_class(mapper, session=self.sa.session()) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/scoping.py", line 47, in call sess = self.registry() File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/collections.py", line 1010, in call return self.registry.setdefault(key, self.createfunc()) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/orm/session.py", line 4209, in call return self.class(local_kw) File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 176, in init bind = options.pop('bind', None) or db.engine File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 998, in engine return self.get_engine() File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 1017, in get_engine return connector.get_engine() File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 594, in get_engine self._engine = rv = self._sa.create_engine(sa_url, options) File "/usr/local/lib/python3.7/site-packages/flask_sqlalchemy/init.py", line 1027, in create_engine return sqlalchemy.create_engine(sa_url, engine_opts) File "<string>", line 2, in create_engine File "/usr/local/lib/python3.7/site-packages/sqlalchemy/util/deprecations.py", line 309, in warned return fn(*args, kwargs) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/engine/create.py", line 560, in create_engine dbapi = dialect_cls.dbapi(**dbapi_args) File "/usr/local/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/pymysql.py", line 68, in dbapi return import("pymysql") ModuleNotFoundError: No module named 'pymysql'

Take a look at https://help.pythonanywhere.com/pages/DebuggingImportError/