查询python的打印结果

发布于 2025-02-11 02:25:22 字数 500 浏览 2 评论 0原文

我的应用程序使用sqlalchemy/sql查询数据库。我想打印出查询的结果，但是我会在响应中获得＆lt; sqlalchemy.engine.result.result.result.result.resultproxy对象。

我尝试了 href =”中的建议。如何访问查询结果？但是我得到了“未被发现的异常”

请参阅下面的代码：

query = f"SELECT COUNT(DISTINCT id)"\
    f"FROM group"

result = db.session.execute(query)
id_count = result.first()[0]
print(id_count)

原文

My application uses SQLAlchemy/SQL to query a database. I want to print out the result of the query, but I am getting a <sqlalchemy.engine.result.ResultProxy object in response.

I tried out the suggestions in How to access the results of queries? but I am getting an "Uncaught exception"

See code below:

query = f"SELECT COUNT(DISTINCT id)"\
    f"FROM group"

result = db.session.execute(query)
id_count = result.first()[0]
print(id_count)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

流殇 2025-02-18 02:25:22

尝试这个：

query = f"SELECT COUNT(DISTINCT id)"\
    f"FROM group"

result = db.session.execute(query)
id_count = result.first()

for i in id_count:
    print(i[0]) # Access by positional index
    print(i['my_column']) # Access by column name as a string
    r_dict = dict(i.items()) # convert to dict keyed by column names

Try this one:

query = f"SELECT COUNT(DISTINCT id)"\
    f"FROM group"

result = db.session.execute(query)
id_count = result.first()

for i in id_count:
    print(i[0]) # Access by positional index
    print(i['my_column']) # Access by column name as a string
    r_dict = dict(i.items()) # convert to dict keyed by column names

回复收藏 0 原文

~没有更多了~