当前位置： 移动技术网 > IT编程>脚本编程>Python > [Python]Transform the entity result to JSON

[Python]Transform the entity result to JSON

2019年04月19日  | 移动技术网IT编程  | 我要评论

usb3.0接口,卫国大军阀,叛逃粤语12

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 :-)'


您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网