Do you get many rows? SELECT date_format(data.timestamp, "%Y-%m-%d %H"), max(data.value) AS data_value from data GROUP BY date_format(data.timestamp, "%Y-%m-%d %H")
On Tue, Apr 11, 2023 at 4:24 PM Luis Del Rio IV <l...@colovore.com> wrote: > 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 sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/a73c1830-8c64-437a-8ea7-a171767e2223n%40googlegroups.com > <https://groups.google.com/d/msgid/sqlalchemy/a73c1830-8c64-437a-8ea7-a171767e2223n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAOV%2B3C2PU2ndh9Uf-ZGtDj_ao-3rhQATE9MjYAppSSnwKT6%2Beg%40mail.gmail.com.