Python SQLAlchemy笔记

关于Python使用 SQLAlchemy 这个orm的文档手册，目前碰到了一些问题，搜到了此手册, 后面在详细研究下

• SQLAlchemy 1.2 Documentation https://docs.sqlalchemy.org/en/12/

• https://www.osgeo.cn/sqlalchemy/orm/session_transaction.html

---

• 报错: (pymysql.err.InternalError) (1205, ‘Lock wait timeout exceeded; try restarting transaction’)

错误代码 后续补上

• 解决方式

---

• 错误提示: sqlalchemy.exc.InterfaceError: (pymysql.err.InterfaceError) (0, ‘’)

https://stackoverflow.com/questions/6650940/interfaceerror-0

---

SQLAlchemy 执行原生 sql

https://stackoverflow.com/questions/17972020/how-to-execute-raw-sql-in-flask-sqlalchemy-app

事物
https://stackoverflow.com/questions/14054787/sqlalchemy-core-insert-multiple-rows-from-a-tuple-instead-of-dict

https://www.cnblogs.com/cwp-bg/p/8876012.html

---

动态创建数据库

https://stackoverflow.com/questions/973481/dynamic-table-creation-and-orm-mapping-in-sqlalchemy

https://stackoverflow.com/questions/14054787/sqlalchemy-core-insert-multiple-rows-from-a-tuple-instead-of-dict

还有个ORM peewee https://github.com/coleifer/peewee