Re: Delay between consecutive SQL statements when using Alembic on Jenkins

2020-08-17 Thread Mike Bayer
On Sun, Aug 16, 2020, at 11:10 PM, MichaƂ Guzek wrote: > I have a problem with delays between consecutive SQL statements when Alembic > executes a migration script's upgrade() function on Jenkins: > def upgrade(): > op.execute("DELETE FROM employee WHERE name='John';") #John also has its >

[sqlalchemy] Re: compatibility between SQLite and PostgreSQL

2020-08-17 Thread Jonathan Vanasco
On Friday, August 14, 2020 at 10:00:46 AM UTC-4, Alceu Rodrigues de Freitas Junior wrote: > I have some projects that are using SQLAlchemy and PostgreSQL and they are > running fine until we have to run automated tests that uses PostgreSQL and > they took ~5 minutes to complete, even after

[sqlalchemy] Joining and labeling data on multiple tables

2020-08-17 Thread alireza...@gmail.com
Hello, I have 3 main tables and 3 association tables between them Main tables: Sites, Categories, Products Association Tables: Sites<->Categories, Categories<->Products, Sites<->ChosenProducts Here is a link to diagram: https://dbdiagram.io/d/5f3a863d39081a20ae94d500 Here is my code:

Re: [sqlalchemy] Flask SQlAlchemy BaseQuery Paginate not working correctly

2020-08-17 Thread Prerna Pandit
Hey Simon, I am indeed getting back duplicates of aggregate ids. I reworked my query to using exists like you suggested and now I get back correct result count. Thanks so much for your suggestion and saving my day! I can now move ahead on my work ticket. Many, many, thanks again,