The sql query itself returns several rows, as it should. But when trying to combine the max using sqlalchemy the rows return as the following.
Received incompatible instance \"(<server.db.models.Data object at 0x7f2c6cfd6670>, '2021-04-10 18', Decimal('7294.00000'))\".", Here I am able to get the max for that row group, but am unable to pass it into the DataModel object Luis Del Rio IV DevOps Engineer [image: Colovore] 1101 Space Park Drive Santa Clara, CA 95054 <https://www.google.com/maps/place/1101+Space+Park+Dr,+Santa+Clara,+CA+95054/@37.3766977,-121.9552767,17z/data=!3m1!4b1!4m5!3m4!1s0x808fca298ada9ab5:0x8b082f7c3541c8bf!8m2!3d37.3766977!4d-121.953088> mobile: 408. <%204085315362>*375.4195* 24/7: 408.330.9290 <%20408%203309290> On Tue, Apr 11, 2023 at 4:59 PM S Mahabl <smah...@gmail.com> wrote: > 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 a topic in the > Google Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/j5fIV6NmAns/unsubscribe. > To unsubscribe from this group and all its topics, 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 > <https://groups.google.com/d/msgid/sqlalchemy/CAOV%2B3C2PU2ndh9Uf-ZGtDj_ao-3rhQATE9MjYAppSSnwKT6%2Beg%40mail.gmail.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/CABKymD8cF3JQoxD_-qH6Y4kg-tp9GOGM2kO3bqrm_qY6Ogz%3DcQ%40mail.gmail.com.