关于Flask的增删改查

Flask的框架搭建我就不在此详说了,优快云上大佬有更详细的攻略

在此简单说下Flask的增删改查

增加我知道的方法有两种

第一种是批量插入,代码如下:

session.add_all([
	User(name = "老张",age = 18,gender = "男",project = "python"),
    User(name = "老李",age = 13,gender = "男",project = "python"),
    User(name = "老王",age = 14,gender = "女",project = "java"),
    User(name = "老赵",age = 15,gender = "男",project = "c++"),
    User(name = "老孙",age = 16,gender = "女",project = "python"),
])
session.commit() #提交修改

第二种是具体插入到某个ID下,代码如下:

user = User(
    id = 7,
    name = "老六",
    age = 17,
    gender = "男",
    project = "python"
)

session.add(user)
session.commit()  #提交修改

然后是查询了,查询的方法我知道的有四种

第一种是查询表内所有数据:

all_data = session.query(User).all()
print(all_data)

第二种是筛选查询,就是查询表内符合某个特定的条件的数据:

all_data = session.query(User).fil