if you add a column to a Query that was returning an object, like Data, you will get back tuples of (Data, extra_col). this is probably what the tool you are using is complaining about.
On Fri, Apr 14, 2023, at 10:51 PM, Mike Bayer wrote: > > > On Tue, Apr 11, 2023, at 9:17 PM, Luis Del Rio IV wrote: >> 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'))\".", > > that's not a SQLAlchemy error. I would again suggest you get help from the > maintainers of the library you're using. > > > >> >> Here I am able to get the max for that row group, but am unable to pass it >> into the DataModel object >> >> On Tuesday, April 11, 2023 at 4:59:15 PM UTC-7 S Mahabl 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 <lu...@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+...@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/3eeda16b-9c36-4ca5-91b5-cba325343fban%40googlegroups.com >> >> <https://groups.google.com/d/msgid/sqlalchemy/3eeda16b-9c36-4ca5-91b5-cba325343fban%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/ee62e370-b0c1-4656-95e2-4ecbcf4791e7%40app.fastmail.com > > <https://groups.google.com/d/msgid/sqlalchemy/ee62e370-b0c1-4656-95e2-4ecbcf4791e7%40app.fastmail.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/ad433e36-0ab1-4827-b8cc-0a94d157358f%40app.fastmail.com.