Hello,
I am currently using the following sqlalchemy code,
_query = super().get_query(model, info, sort, **args)
query = _query.group_by(
func.date_format(DataModel.timestamp, "%Y-%m-%d %H")
)
return query
I am trying to aggregate the the max value of a field from DataModel.value
utilizing the group by clause.
In simple sql, you would do the following.
SELECT max(data.value) AS data_value
from data
GROUP BY date_format(data.timestamp, "%Y-%m-%d %H")
What would the proper way to express this? The various methods I have tried
somehow overwrite the original query and do not map to our attributes.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/a73c1830-8c64-437a-8ea7-a171767e2223n%40googlegroups.com.
