如何将Python行对象转换为SQLAlchemy字典？开发者社区

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

另类的开水瓶 · js操作二进制数据 - 风花一世月 - 博客园· 1 年前 ·

谦逊的登山鞋 · 用crash工具分析内核死锁问题 - ...· 2 年前 ·

胡子拉碴的牛肉面 · React-配置代理跨域 - 掘金· 2 年前 ·

淡定的跑步鞋 · jsonpath ...· 2 年前 ·

憨厚的麻辣香锅 · 深入理解 Java ...· 2 年前 ·

腾讯云

开发者社区

文档意见反馈控制台

首页 TVP

文章/答案/技术大牛

发布

import sqlalchemy
from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
print "sqlalchemy version:",sqlalchemy.__version__ 
engine = create_engine('sqlite:///:memory:', echo=False)
metadata = MetaData()
users_table = Table('users', metadata,
     Column('id', Integer, primary_key=True),
     Column('name', String),
metadata.create_all(engine) 
class User(declarative_base()):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    def __init__(self, name):
        self.name = name
Session = sessionmaker(bind=engine)
session = Session()
user1 = User("anurag")
session.add(user1)
session.commit()
# uncommenting next line throws exception 'TypeError: 'User' object is not iterable'
#print dict(user1)
# this one also throws 'TypeError: 'User' object is not iterable'
for u in session.query(User).all():
    print dict(u)

Traceback (most recent call last):
  File "untitled-1.py", line 37, in <module>
    print dict(u)
TypeError: 'User' object is not iterable

def row2dict(row):
    d = {}
    for column in row.__table__.columns:
        d[column.name] = str(getattr(row, column.name))
    return d

row2dict = lambda r: {c.name: str(getattr(r, c.name)) for c in r.__table__.columns}

for u in session.query(User).all():
    print u.__dict__

from sqlalchemy import inspect
def object_as_dict(obj):

回答 34

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户