如何将 SQLAlchemy 行对象转换为 Python 字典? [英] How to convert SQLAlchemy row object to a Python dict?
本文介绍了如何将 SQLAlchemy 行对象转换为 Python 字典?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否有一种简单的方法来迭代列名和值对?
Is there a simple way to iterate over column name and value pairs?
我的 SQLAlchemy 版本是 0.5.6
My version of SQLAlchemy is 0.5.6
这是我尝试使用 dict(row)
的示例代码:
Here is the sample code where I tried using dict(row)
:
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)
在我的系统输出上运行此代码:
Running this code on my system outputs:
Traceback (most recent call last):
File "untitled-1.py", line 37, in <module>
print dict(u)
TypeError: 'User' object is not iterable
推荐答案
您可以访问 SQLAlchemy 对象的内部 __dict__
,如下所示:
You may access the internal __dict__
of a SQLAlchemy object, like the following:
for u in session.query(User).all():
print u.__dict__
这篇关于如何将 SQLAlchemy 行对象转换为 Python 字典?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文