Re: [sqlalchemy] Query object modification

2023-04-12 Thread Mike Bayer
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") > ) >

[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] Re: trying to create a custome dialect did not find proper step guide

2023-04-12 Thread Jonathan Vanasco
There are no guides, because this is a very advanced topic. If you are unable to code this based on the examples I shared above, you will have to find someone who can. On Friday, April 7, 2023 at 11:41:30 PM UTC-4 sayakchak...@gmail.com wrote: > Thank you sir for your response ,can you

Re: [sqlalchemy] chinook with sqlalchemy core

2023-04-12 Thread Soumaya Mauthoor
Or any sample database would e.g. northwind https://docs.devexpress.com/XtraReports/403995/product-information/sample-northwind-database Le mer. 12 avr. 2023 à 20:40, sumau a écrit : > Hello > > Is there a sqlalchemy core version of the chinook database >

[sqlalchemy] chinook with sqlalchemy core

2023-04-12 Thread sumau
Hello Is there a sqlalchemy core version of the chinook database https://github.com/lerocha/chinook-database? A python script which creates the different tables and populates them with the same data? Regards Soumaya -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper