- +在此添加单个AI新笔记
Flask - 扩展 - mysql
data1 = db.session.execute("select * from table;")db.session.commit()list0 = []for i in list(data1):for循环
这里只说原生的可以list(),没有说怎么配置，因为我是在导入flask-SQLAlchemy一起混了，具体大家试一下
获得数据变成dict
sql = "select aa,bb ..."data0 = db.session.execute(sql)data = list(map(dict11, data0))print(data[0])print(data[0]["aa"])print(data[0]["bb"])
def dict11(self):return dict(aa=self.aa, bb=self.bb)
获得数据变成list
sql = "select aa,bb ..."data0 = db.session.execute(sql)data = list(map(allsheetlist, data0))print(data[0])print(data[0]["aa"])print(data[0]["bb"])
def allsheetlist(self):return self.name