Question

0 0

这个sql 查询能转换成sqlalchemy语句吗?


 select to_char(date_published, 'yyyymm') yo from blog group by yo;

date_published 是timestamp with time zone 类型数据

我用cast() 试了一下，可group_by 不知道如何使用

貌似只能用extract() 了

编程 python sqlalchemy PostgreSQL sql

10 years, 8 months ago

博丽·霊梦

share

博丽·霊梦 10 years, 8 months ago

Answer 1

0

已解决
可以通过 func 直接调用数据库支持的函数或存储过程


 yonth = db.func.to_char(ArticleModel.date_published, 'yyyymm').label('yonth')
archive_list = (
    db.session.query(yonth, db.func.count(1)).group_by('yonth').all()
)

answered 10 years, 8 months ago

314200

share

314200 answered 10 years, 8 months ago

这个sql 查询能转换成sqlalchemy语句吗?

博丽·霊梦

Answers

314200

Your Answer