python - 使用 SQLAlchemy 在 mysql 中像 PostgreSQL array_agg 这样的聚合?
问题描述
这是我的代码,但我正在null
为该领域工作shared_with
,有什么预感吗?
shared_with = (
query(sqlalchemy.func.group_concat(SLM.id, AC.email)).
filter(SLM.AC_id == AC.id).
filter(SLM.shared_list_id == SharedList.id ).
filter(SharedList.type_code == CL.type_code)
)
query = query(
CL.id,
CL.type_code,
shared_with.label('shared_with'),
)
解决方案
推荐阅读
- php - WooCommerce单品页面如何获取产品属性链接
- java - Spring Boot 日志记录覆盖颜色
- arduino - 简易HC-05蓝牙安卓通讯
- python - 如何在没有行网格的python中在reportlab中创建表?
- c++ - VSC Ubuntu 20.04 中的“不允许使用属性控制台”问题
- google-sheets - Google Sheets Countif range is greater than range
- c - How to work around compiler built-in types in C standard header files
- java - How to get date from a string without formatting?
- javascript - how i can write a component without error in syntax certainly inside (return) ,,i have problem with a jsx
- mysql - How to insert multiple row with different ID in Laravel