1.sqlalchemy 通过以下代码测试是否连接到数据库
# 创建连接
with app.app_context():
with db.engine.connect() as conn:
result = conn.execute("select 1")
print(result.fetchone()) # (1,)
2.报错信息
File "D:\PythonProject\demo03\app.py", line 17, in <module>
result = conn.execute("select 1")
File "C:\Users\AZ\AppData\Local\Programs\Python\Python310\lib\site-packages\sqlalchemy\engine\base.py", line 1412, in execute
raise exc.ObjectNotExecutableError(statement) from err
sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'select 1'
- 是版本问题吗,怎末解决呀,很困惑