Once, because I was not familiar with SQLAlchemy, I stubbornly abandoned it and directly introduced the native CX_Oracle to generate reports, but after a lot...
SqlAlchemy object serialized to JSON is inspired by Django REST Framework instances {code... } single instance {code... } exclude field {code... } includes only fields...
If you plan to use only one application, you can largely skip this article. Simply pass your application to the SQLAlchemy constructor and you're set...
Lazy Load Methods are a set of Load Methods defined by SQLAlchemy for multiple table associations. What value you choose for the lazy parameter determines...
Table relationships in SQL have always been one of the more difficult areas to understand. They are also implemented by SQLAlchemy, which is easier to...
In Python projects, you often need to work with databases, and SQLAlchemy provides SQL toolkits and object-relational mapping (ORM) tools, greatly improving the efficiency of...
Officially, Flask-SQLAlchemy is recommended, but I personally don't recommend it here. Because general back-end programmers prefer to use native SQL language to deal with database...
The biggest benefits of SQLAlchemy are the clarity of structure and the fact that migrating the database does not create too much redundancy. But the...
Flask's flexible file organization structure makes many novice players very painful, and the relevant tutorials on the Internet are also uneven. I am also on...
The following introduces the basic query statements of SQLAlchemy, and the next article will introduce its advanced query (aggregate, self-association, join, subquery, etc.) model class...