TSA加速手册（持续更新）

数据库的增删改查

建立连接

通用版

engine = create_engine('postgresql://username: password@host: port/dbname')
DBSession = sessionmaker(engine)
session = DBSession()

加速版

db = DbClass(PG_DB_URI)
session = db.make_session()
pg_db = session()

或者是在flask框架内使用全局变量g

g.pg_db

增

new_student = Student(name="Russell", class="two", grade="three")
session.add(new_student)
session.commit()
session.close()

一次插入多行

student_list = [Student(name="kobe", class="lakers", grade="nba"),
                       Student(name="Curry", class="Warriors", grade="nba"),
                       Student(name="George", class