blob: 954b5a9fa4e54fe1544277bab2d0444971fd1150 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
"""Fixtures and utilities for migration-related tests"""
import pytest
from yoyo.backends import DatabaseBackend
from yoyo import get_backend, read_migrations
from yoyo.migrations import Migration, MigrationList
from gn_auth.auth.db import sqlite3 as db
from gn_auth.migrations import apply_migrations, rollback_migrations
@pytest.fixture(scope="session")
def auth_testdb_path(fxtr_app_config): # pylint: disable=redefined-outer-name
"""Get the test application's auth database file"""
return fxtr_app_config["AUTH_DB"]
@pytest.fixture(scope="session")
def auth_migrations_dir(fxtr_app_config): # pylint: disable=redefined-outer-name
"""Get the test application's auth database file"""
return fxtr_app_config["AUTH_MIGRATIONS"]
def apply_single_migration(backend: DatabaseBackend, migration: Migration):# pylint: disable=[redefined-outer-name]
"""Utility to apply a single migration"""
apply_migrations(backend, MigrationList([migration]))
def rollback_single_migration(backend: DatabaseBackend, migration: Migration):# pylint: disable=[redefined-outer-name]
"""Utility to rollback a single migration"""
rollback_migrations(backend, MigrationList([migration]))
@pytest.fixture(scope="session")
def backend(auth_testdb_path):# pylint: disable=redefined-outer-name
"""Fixture: retrieve yoyo backend for auth database"""
return get_backend(f"sqlite:///{auth_testdb_path}")
@pytest.fixture(scope="session")
def all_migrations(auth_migrations_dir): # pylint: disable=redefined-outer-name
"""Retrieve all the migrations"""
return read_migrations(auth_migrations_dir)
@pytest.fixture(scope="function")
def conn_after_auth_migrations(backend, auth_testdb_path, all_migrations): # pylint: disable=redefined-outer-name
"""Run all migrations and return a connection to the database after"""
apply_migrations(backend, all_migrations)
with db.connection(auth_testdb_path) as conn:
with db.cursor(conn) as cursor:
cursor.execute(
"UPDATE resources "
"SET resource_id='0248b289-b277-4eaa-8c94-88a434d14b6e' "
"WHERE resource_name='GeneNetwork System'")
yield conn
rollback_migrations(backend, all_migrations)
def migrations_up_to(migration, migrations_dir):
"""Run all the migration before `migration`."""
migrations = read_migrations(migrations_dir)
index = [mig.path for mig in migrations].index(migration)
return MigrationList(migrations[0:index])
|
