[Python]Transform the entity result to JSON

SQLAlchemy引擎、会话与查询API使用及结果转换为JSON

最新推荐文章于 2025-09-20 12:03:31 发布

原创最新推荐文章于 2025-09-20 12:03:31 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python #sqlite #api #session #json

Python_Ruby 专栏收录该内容

37 篇文章

订阅专栏

本文介绍了如何使用SQLAlchemy的引擎、会话和查询API，并展示了如何将查询结果转换为JSON格式。通过示例代码，详细说明了创建引擎、会话以及操作数据库的基本步骤，最后将查询结果以JSON形式呈现。

This post gives the guide of how to use sqlalchemy's engine, session and query API and change the results into JSON format.

from sqlalchemy import create_engine,Column,Integer,String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from json import dumps
 
def to_json(model):
    """ Returns a JSON representation of an SQLAlchemy-backed object.
    """
    json = {}
    json['fields'] = {}
    json['pk'] = getattr(model, 'id')
 
    for col in model._sa_class_manager.mapper.mapped_table.columns:
        json['fields'][col.name] = getattr(model, col.name)
 
    return dumps([json])

engine = create_engine('sqlite:///sqlite.db',echo=True)
Session = sessionmaker(bind=engine)
Base = declarative_base()

class User(Base):
	__tablename__ = 'user'
	id = Column(Integer,primary_key=True)
	name = Column(String)
	
session = Session()

'''
user = User(id=2,name='developer')
session.add(user)
session.commit()
'''
users = session.query(User).order_by(User.id).all()
for user in users:
	print to_json(user)
print '--->Done :-)'