[Flask] sqlalchemy create_engine 오류

우선 sqlalchemy 2.x에 버그가 있는 것 같음

AttributeError: 'Engine' object has no attribute 'execute'

pip install --force-reinstall 'sqlalchemy<2.0.0'

 

---

 

database = create_engine(app.config['DB_URL'], encoding = 'utf-8')

raise TypeError(
TypeError: Invalid argument(s) 'encoding' sent to create_engine(), using configuration MySQLDialect_mysqlconnector/QueuePool/Engine.  Please check that the keyword arguments are appropriate for this combination of components.

database = create_engine(app.config['DB_URL'], connect_args= {'encoding' : 'utf-8')

 

 

참고: https://docs.sqlalchemy.org/en/20/core/engines.html#custom-dbapi-args