flask中sqlalchemy包使用

 

 

import flask import Flask

from sqlalchemy import SQLAlchemy

 

app=Flask(__name__)

db.SQLAlchemy(app)

app.config[]

app.config[]

 

 

#新建一个类并添加到数据库中

student=Student(name="yinxiaocheng",age="12",gender="man")

db.session.add(student)

db.session.commit()

 

#添加多个

student1=Student(name="yinxiaocheng1",age="12",gender="man")

student2=Student(name="yinxiaocheng2",age="13",gender="man")

student3=Student(name="yinxiaocheng3",age="14",gender="man")

db.session.add_all([student1,student2,student3])

db.session.commit()

 

#删除

student=Student.query.get(1)

db.session.delete()

db.session.commit()