async def test_t2_cleanup_resources_after_browser_is_closed( simcore_services, client, socketio_client, db_engine, redis_client): """ after a GUEST users with one opened project closes browser tab regularly (GC cleans everything) """ logged_guest_user = await login_guest_user(client) empty_guest_user_project = await new_project(client, logged_guest_user) assert await assert_users_count(db_engine, 1) is True assert await assert_projects_count(db_engine, 1) is True sio_connection_data = await connect_to_socketio(client, logged_guest_user, socketio_client) await asyncio.sleep(WAIT_FOR_COMPLETE_GC_CYCLE) # check user and project are still in the DB assert await assert_user_in_database(db_engine, logged_guest_user) is True assert await assert_project_in_database(db_engine, empty_guest_user_project) is True await disconnect_user_from_socketio(client, sio_connection_data) await asyncio.sleep(WAIT_FOR_COMPLETE_GC_CYCLE) # check user and project are no longer in the DB async with db_engine.acquire() as conn: user_result = await conn.execute(users.select()) user = await user_result.first() project_result = await conn.execute(projects.select()) project = await project_result.first() assert user is None assert project is None
async def query_project_from_db(aiopg_engine: aiopg.sa.Engine, project_uuid: str) -> Dict[str, Any]: async with aiopg_engine.acquire() as conn: project_result = await conn.execute( projects.select().where(projects.c.uuid == project_uuid)) project = await project_result.first() assert project is not None return dict(project)
async def test_t2_cleanup_resources_after_browser_is_closed( mock_garbage_collector_task, simcore_services_ready, client, socketio_client_factory: Callable, aiopg_engine, redis_client, tests_data_dir: Path, ): """After a GUEST users with one opened project closes browser tab regularly (GC cleans everything)""" logged_guest_user = await login_guest_user(client) empty_guest_user_project = await new_project( client, logged_guest_user, tests_data_dir ) assert await assert_users_count(aiopg_engine, 1) is True assert await assert_projects_count(aiopg_engine, 1) is True sio_connection_data = await connect_to_socketio( client, logged_guest_user, socketio_client_factory ) await asyncio.sleep(SERVICE_DELETION_DELAY + 1) await garbage_collector_core.collect_garbage(app=client.app) # check user and project are still in the DB assert await assert_user_in_database(aiopg_engine, logged_guest_user) is True assert ( await assert_project_in_database(aiopg_engine, empty_guest_user_project) is True ) await disconnect_user_from_socketio(client, sio_connection_data) await asyncio.sleep(SERVICE_DELETION_DELAY + 1) await garbage_collector_core.collect_garbage(app=client.app) # check user and project are no longer in the DB async with aiopg_engine.acquire() as conn: user_result = await conn.execute(users.select()) user = await user_result.first() project_result = await conn.execute(projects.select()) project = await project_result.first() assert user is None assert project is None
async def query_project_from_db(db_engine: aiopg.sa.Engine, user_project: Dict): async with db_engine.acquire() as conn: project_result = await conn.execute( projects.select().where(projects.c.uuid == user_project["uuid"])) return await project_result.first()