python: SQLAlchemy

 

 

https://www.cnblogs.com/jclian91/p/12121735.html
https://github.com/percent4/ORM_test
https://github.com/yabea/
https://juejin.cn/post/7246978810019971130
https://docs.sqlalchemy.org/en/20/orm/declarative_tables.html
https://auth0.com/blog/sqlalchemy-orm-tutorial-for-python-developers/
https://docs.sqlalchemy.org/en/20/dialects/mssql.html
https://zhuanlan.zhihu.com/p/444930067
https://www.cnblogs.com/Keep-Ambition/p/8083387.html
https://blog.csdn.net/u011364612/article/details/123623961
https://pypi.org/project/sqlacodegen/
https://github.com/dahlia/awesome-sqlalchemy
https://github.com/auth0-blog/sqlalchemy-orm-tutorial/tree/master
https://github.com/madalinpopa/py-patterns ORM
https://lyz-code.github.io/blue-book/coding/python/sqlalchemy/
https://docs.sqlalchemy.org/en/20/orm/examples.html

 

SQLAlchemy includes the following list of dialects:

 

Firebird
Microsoft SQL Server
MySQL
Oracle
PostgreSQL
SQLite
Sybase

 

SQLAlchemy Relationship Patterns
One To Many, Many To One, One To One, and Many To Many.

 

SQL Server Data Types
As with all SQLAlchemy dialects, all UPPERCASE types that are known to be valid with SQL server are importable from the top level dialect, whether they originate from sqlalchemy.types or from the local dialect:
from sqlalchemy.dialects.mssql import (
BIGINT,
BINARY,
BIT,
CHAR,
DATE,
DATETIME,
DATETIME2,
DATETIMEOFFSET,
DECIMAL,
DOUBLE_PRECISION,
FLOAT,
IMAGE,
INTEGER,
JSON,
MONEY,
NCHAR,
NTEXT,
NUMERIC,
NVARCHAR,
REAL,
SMALLDATETIME,
SMALLINT,
SMALLMONEY,
SQL_VARIANT,
TEXT,
TIME,
TIMESTAMP,
TINYINT,
UNIQUEIDENTIFIER,
VARBINARY,
VARCHAR,
)