问题:sqlalchemy删除语句如何写,添加语句如何写
方法:
一、add添加语句
user = User(User.name='haha', User.age=12)
self.db.add(user)
self.db.commit()
二、delete删除语句
uid = 23
user = self.db.query(User).get(uid)
self.db.delete(user)
self.db.commit()
或
user = self.db.query(User).filter(User.id == uid).delete()
self.db.commit()