pythonanywhere网站数据库查询返回jsonify resu

2024-09-24 22:28:13 发布

您现在位置:Python中文网/ 问答频道 /正文

我不懂pythonanywhere网站,怎么返回json键值,但是localhost只返回值不返回键值

环境

1.烧瓶

2.炼金术

3.mysql数据库

4.2.7版本

我的orm课

Base = declarative_base()
class DataEntity(Base):
      __tablename__ = 'data'
      id = Column("id", INTEGER, primary_key=True, nullable=False,autoincrement=True)
      clientid= Column("client_id", VARCHAR(32),nullable=False)
      name= Column("name", VARCHAR(10),nullable=False)
      description= Column("description", VARCHAR(20),nullable=False)

我的烧瓶\u app.py

engine = create_engine('mysql+mysqldb://xxx:xxx@xxx.mysql.pythonanywhere-services.com/xxx$dbname?charset=utf8', echo=True,pool_recycle=280)
Session = sessionmaker(bind=engine)
dbsession = Session()

@app.route('/api/data')
def getdata():
    data = dbsession.query(DataEntity.id,DataEntity.name).all();
    return jsonify({'data': data})

pythonanywhere网站json结果

{"data": [{"id": 1,"name": "name1"},{"id": 2,"name": "name2"}]}

本地json结果

{"data": [[1,"name1"],[2,"name2"]]}

Tags: nameidjsonfalsetruedata网站mysql