On Thu, Apr 13, 2023, at 4:14 PM, Luis Del Rio IV wrote:
> Mike,
>
> Would this select query be able to get our aggregated data?
>
> query =
> select(func.max(DataModel.value)).select_from(_query.subquery()).group_by(
> func.date_format(DataModel.timestamp, "%Y-%m-%d %H")
On Thu, Apr 13, 2023, at 1:13 PM, Peter Harrison wrote:
> Thanks Mike,
>
> Ideally we'd prefer to find a solution via Graphene-SQLAlchemy. Unfortunately
> we don't have the luxury of creating our own query when interacting with
> Graphene-SQLAlchemy.
>
> So the key question for us is, can
Mike,
Would this select query be able to get our aggregated data?
query = select(func.max(DataModel.value)).select_from(_query
.subquery()).group_by(
func.date_format(DataModel.timestamp, "%Y-%m-%d %H")
)
We tried this route but are now getting this error
Thanks Mike,
Ideally we'd prefer to find a solution via Graphene-SQLAlchemy.
Unfortunately we don't have the luxury of creating our own query when
interacting with Graphene-SQLAlchemy.
So the key question for us is, can you modify an existing
sqlalchemy.orm.query.Query object to insert a
On Wed, Apr 12, 2023, at 5:21 PM, Luis Del Rio IV wrote:
> 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")
> )
>