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
>
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
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:
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,