def add():
stu = models.Student()
stu.s_age = 23
stu.s_name = '李四2'
stu.title = '标题title'
# 添加数据,如果有此数据就修改，没有此数据就添加
conn.session.add(stu)
# 提交数据
conn.session.commit()
def addAll():
try:
stus = []
# 创建数据
stu = models.Student()
stu.s_age = 45
stu.s_name = '李四9'
stu.title = '标题title'
stus.append(stu)
stu2 = models.Student()
stu2.s_age = 45
stu2.s_name = '李四8'
stu2.title = '标题title'
stus.append(stu2)
# 添加数据
conn.session.add_all(stus)
# 提交数据
conn.session.commit()
print('成功')
except Exception as e:
print('失败e=' + e)
def get(self):
try:
#创建数据
stu= models.Student()
stu.s_age=45
stu.s_name='李四66'
stu.title='标题title'
#添加数据
# conn.session.delete(st)
#提交数据
conn.session.commit()
self.write('成功')
except Exception as e:
self.write('失败e='+e)