\ o / I've nearly monorepod enough libraries to de...
# generala
ambitious-actor-36781
08/03/2021, 3:03 AM\ o / I've nearly monorepod enough libraries to deploy a service.
But the "db library" (read: pile of unnecessary garbage gluing sqlalchemy into... nothing?) doesn't do database isolation very well and as such all the tests fail when run in parallel 😂
SO CLOSE.
w
witty-crayon-22786
08/03/2021, 3:42 AMnice!
witty-crayon-22786
08/03/2021, 3:43 AMnote that there is one helper for the concurrent access usecase: https://www.pantsbuild.org/docs/reference-pytest#section-execution-slot-var
witty-crayon-22786
08/03/2021, 3:43 AMit allows tests to ask for an environment variable that gives them a unique (at any given time) slot number
witty-crayon-22786
08/03/2021, 3:44 AMso if you have 8 cores, you’d get slots 1-8, and could have 8 unique databases/tables/etc
a
ambitious-actor-36781
08/03/2021, 3:50 AMooh
ambitious-actor-36781
08/03/2021, 3:52 AMI've gone for maximum jank.
Copy code
cur.execute(f"CREATE DATABASE {random_db_name}")
yield random_db_name
cur.execute(f"""
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '{random_db_name}'
AND pid <> pg_backend_pid();""")
cur.execute(f"DROP DATABASE {random_db_name};")3 Views