Re: [sqlalchemy] Modifying Query Object

2023-04-14 Thread Luis Del Rio IV
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:0x8b

Re: [sqlalchemy] Modifying Query Object

2023-04-14 Thread Luis Del Rio IV
t; GROUP BY date_format(data.timestamp, "%Y-%m-%d %H") > On Tue, Apr 11, 2023 at 4:24 PM Luis Del Rio IV > wrote: > >> Hello, >> >> I am currently using the following sqlalchemy code, >> >> _query = super().get_query(model, info, sort, **a

Re: [sqlalchemy] Modifying Query Object

2023-04-14 Thread Luis Del Rio IV
tamp, "%Y-%m-%d %H") > On Tue, Apr 11, 2023 at 4:24 PM Luis Del Rio IV > wrote: > >> Hello, >> >> I am currently using the following sqlalchemy code, >> >> _query = super().get_query(model, info, sort, **args) >>

Re: [sqlalchemy] Modifying Query Object

2023-04-14 Thread Luis Del Rio IV
tamp, "%Y-%m-%d %H") > On Tue, Apr 11, 2023 at 4:24 PM Luis Del Rio IV > wrote: > >> Hello, >> >> I am currently using the following sqlalchemy code, >> >> _query = super().get_query(model, info, sort, **args) >>

Re: [sqlalchemy] Query object modification

2023-04-13 Thread Luis Del Rio IV
t how to update the MetaData object in > it > > If modifying the "select" after its creation is not possible, we need to > start considering using a separate reporting table with hourly data. > > On Wednesday, April 12, 2023 at 3:12:46 PM UTC-7 Mike Bayer wrote: > >

[sqlalchemy] Query object modification

2023-04-12 Thread Luis Del Rio IV
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

[sqlalchemy] Modifying Query Object

2023-04-11 Thread Luis Del Rio IV
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