38 - Flask - 扩展 - SQLAlchemy - 查转换DataFrame

新办法

data = User.query.filter()
db.session.commit()
data = list(map(userlist, data))  # data就是[{"":"","":""}]的格式
def userlist(self):
    data = {"pk":self.pk, "id":self.id}
    return data

旧办法

class InvAppService(db.Model):
    __tablename__ = 'inv_app_service'
    id = db.Column(db.Integer, primary_key=True)
    ip = db.Column(db.String(16), unique=True, nullable=False)
    host = db.Column(db.String(32))
    def to_json(self):
        return {
            'ip': self.ip,
            'host': self.host,
            'LDR': self.app.app_devopses_name().get('LDR'),
            'DEV': self.app.app_devopses_name().get('DEV'),
            'INF': self.app.app_devopses_name().get('INF'),
            'OPS': self.app.app_devopses_name().get('OPS')
        }

import pandas as pd
rtn = []
for service in services:
    rtn.append(service.to_json_ip())
rtn = pd.DataFrame(rtn)