sqlalchemy2.0+ orm基本功能

 

创建数据库表

from sqlalchemy import create_engine, Column,Integer,String,
from sqlalchemy.orm import Session, sessionmaker, declarative_base
from sqlalchemy_utils import database_exists,create_database

b = mariadb+mariadbconnector://user:***@127.0.0.1:3306/database

# 引擎，详见官网
engine = create_engine(
    b,
    pool_recycle=3600,
    echo=True,
    future=True,
    pool_size=5,
    )

# 如果没有数据库则利用sqlalchemy_utils创建数据库  3
if not database_exists(engine.url):
    create_database(engine.url)

# 会话
Session = sessionmaker(bind=engine)
session = Session()

# 基类创建数据库表
Base = declarative_base()

增

user1 = User(name='tom',age=25)
session.add(user1)
session.commit()

删