How to emulate such a request through Tortoise ORM?

[markelovstyle]

Hello, how I can a similar SQL request be sampled via Tortoise ORM? Read the documentation, but it doesn’t give examples of working with date and time

SELECT uid, SUM(posts) AS post, SUM(fine) AS fines, date FROM statistic
WHERE date > DATE(date) <= NOW() AND date >= DATE_SUB(NOW(), INTERVAL 31 DAY)
GROUP BY uid ORDER BY post DESC

[grigi]

Oh, that's a good point. I don't think we have date manipulation filters right now? How did I miss that?

[markelovstyle]

Great! I’ll wait for the release.

Does Tortoise have the ability to query the database directly, as in Pony ORM?

[grigi]

Yes:

conn = Tortoise.get_connection('default')
val = await conn.execute_query_dict("SELECT * FROM event")
print(val)

Should really add that to the documentation...

[grigi]

I added an example in the docs: https://tortoise-orm.readthedocs.io/en/develop/examples/basic.html#manual-sql