iSrSSKrSSKJs Jr SSKrSSKrSSK J r J r SSK J r SSKJr SrS\4Sjr\R&"S S 9S 5r\R&S 5rg) z Test configuration and fixtures.N) create_enginetext)Session)BasecD[RRSS5 g)N DATABASE_URLzsqlite+pysqlite:///:memory:)osenviron setdefault3/root/tipsharks/tipsharks-elo-api/tests/conftest.pypytest_configurer sJJ.*GHr returncB[RRSS5$)z2Return the test database URL from env or fallback.TEST_DATABASE_URLzFpostgresql+psycopg://tipsharks:tipsharks@localhost:5432/tipsharks_test)r r getr r r_get_test_db_urlrs ::>>P r session)scopec## [5n[USS9n[RR U5 Uv UR 5nUR [S55 UR5 SSS5 [RRU5 UR5 g!,(df  N>=f7f)zCreate the test PostgreSQL engine and all tables once per session. Tables are created at session start and dropped at session end. T) pool_pre_pingz7DROP MATERIALIZED VIEW IF EXISTS latest_ratings CASCADEN) rrrmetadata create_allconnectexecutercommitdrop_alldispose)test_urlengineconns r db_enginer#s  !H 84 8FMMV$ L  T TSTU   MM6" NN  sAB> +B-58B>- B;7B>c## UR5nUR5n[US9nUv UR5 UR 5 UR5 g7f)zYield a database session rolled back after each test. Each test gets a clean transaction that is rolled back on teardown, providing isolation between tests. )bindN)rbeginrcloserollback)r# connection transactionrs r db_sessionr+.sS""$J""$K:&G M MMOsAA!)__doc__builtins @py_builtins_pytest.assertion.rewrite assertionrewrite @pytest_arr pytest sqlalchemyrrsqlalchemy.ormrpackages.core.storage.modelsrrstrrfixturer#r+r r rr9sb& *"-I#i !$r