插入数据

		
from sqlalchemy.orm import sessionmaker
​
# 创建会话session
Session = sessionmaker(bind=engine)
session = Session()
# 新增数据
new_data = Employees(name='Neo', sex='男', age=25, birth='1980-10-24', jobs='CEO')
session.add(new_data)
session.commit()
session.close()		
		
		

删除数据

		
from sqlalchemy.orm import sessionmaker
​
# 创建会话session
Session = sessionmaker(bind=engine)
session = Session()
# 删除数据
data = session.query(Employees).filter_by(id=1).delete()
print('已删除数据的数据量为:', data)
session.commit()
session.close()

session.query(Students).filter(Students.name == 'netkiller').delete()
session.commit()
		
		

修改数据

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

# 更新数据
session.query(Employees).filter_by(id=1).update({Employees.age: 12})
session.commit()
session.close()	

# 查询后更新数据
data = session.query(Employees).filter_by(id=5).first()
data.name = '张三'
session.commit()
session.close()