SQLAlchemy教程（二）基本增删改查

增删改查

增：

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine

from s1 import models  #导入创建表的模块

engine = create_engine('sqlite:///test.db') #连接数据库
Session = sessionmaker(bind=engine)  #创建一个会话
session = Session() 

#生成一个数据对象
data = models.Users(name='阿比盖尔',age=9,gender=True)
#把对象添加进去
session.add(data) 

try:
    #提交事务
    session.commit()
except Exception as e:
    print(e)
#关闭会话
session.close()

查看数据库，验证插入数据是否成功 

批量添加数据 

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from s1 import models

engine = create_engine('sqlite:///test.db')
Session = sessionmaker(bind=engine)
session = Session()

session.add_all([
    models.Users(name='隆', age=30),
    models.Users(name='肯', age=28),
    models.Users(name='豪鬼', age=40),
    models.Users(name='嘉米', gender=True, age=20),
    models.Users(name='小樱', gender=True, age=18),
    models.Users(name='卡琳', gender=True, age=25),
    models.Users(name='骨裂', age=35)
])
try:
    session.commi