import psycopg2 import pytest from pytest_dbfixtures import factories query = "CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);" pg_ctl = '/usr/lib/postgresql/{ver}/bin/pg_ctl' postgresql91 = factories.postgresql_proc(pg_ctl.format(ver='9.1'), port=9877) postgresql92 = factories.postgresql_proc(pg_ctl.format(ver='9.2'), port=9878) postgresql93 = factories.postgresql_proc(pg_ctl.format(ver='9.3'), port=9879) @pytest.mark.parametrize('postgres', ( 'postgresql91', 'postgresql92', 'postgresql93', )) def test_postgresql_proc(request, postgres): postgresql_proc = request.getfuncargvalue(postgres) assert postgresql_proc.running() is True def test_main_postgres(postgresql): cur = postgresql.cursor() cur.execute(query) postgresql.commit() cur.close()
import pytest from pytest_dbfixtures import factories query = "CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);" postgresql91 = factories.postgresql_proc('/usr/lib/postgresql/9.1/bin/pg_ctl', port=9877) postgresql92 = factories.postgresql_proc('/usr/lib/postgresql/9.2/bin/pg_ctl', port=9878) postgresql93 = factories.postgresql_proc('/usr/lib/postgresql/9.3/bin/pg_ctl', port=9879) @pytest.mark.parametrize('postgres', ( 'postgresql91', 'postgresql92', 'postgresql93', )) def test_postgresql_proc(request, postgres): postgresql_proc = request.getfuncargvalue(postgres) assert postgresql_proc.running() is True def test_main_postgres(postgresql): cur = postgresql.cursor() cur.execute(query) postgresql.commit() cur.close() postgresql_proc2 = factories.postgresql_proc(port=9876)
raise ValueError( 'argument passed to --dbfixtures-config is not a valid file path') redis_conf = early_config.getvalue('redis_conf') if redis_conf and not path(redis_conf).isfile(): raise ValueError( 'argument passed to --redis-config is not a valid file path') rabbit_conf = early_config.getvalue('rabbit_conf') if rabbit_conf and not path(rabbit_conf).isfile(): raise ValueError( 'argument passed to --rabbit-config is not a valid file path') redis_proc = factories.redis_proc() redisdb = factories.redisdb('redis_proc') postgresql_proc = factories.postgresql_proc() postgresql = factories.postgresql('postgresql_proc') mysql_proc = factories.mysql_proc() mysql = factories.mysql('mysql_proc') @pytest.fixture def mysqldb(mysql): warnings.warn( '`mysqldb` fixture is deprecated. Please use `mysql` instead.', DeprecationWarning, 2) return mysql elasticsearch_proc = factories.elasticsearch_proc()
from alembic import command as alembic_command from leaflets.app import setup_app from leaflets.views import BaseHandler # noqa from leaflets.models import User, Address, CampaignAddress, Campaign from leaflets.etc import options from leaflets.dev import add_users from leaflets import database as db options.DB_USER = '******' options.DB_PASSWORD = None options.DB_PORT = 15533 options.DB_HOST = '127.0.0.1' postgres_proc = factories.postgresql_proc( executable=options.POSTGRES_LOCATION + '9.3/bin/pg_ctl', port=options.DB_PORT, ) postgresdb = factories.postgresql('postgres_proc', db=options.DB_NAME) @pytest.yield_fixture def database(postgresdb): """Set up the database.""" alembic_ini = '../tests/test_alembic.ini' alembic_cfg = Config(alembic_ini) with (Path(__file__).parent.parent / 'leaflets'): alembic_command.upgrade(alembic_cfg, "head") yield postgresdb
redis_conf = early_config.getvalue('redis_conf') if redis_conf and not path(redis_conf).isfile(): raise ValueError( 'argument passed to --redis-config is not a valid file path' ) rabbit_conf = early_config.getvalue('rabbit_conf') if rabbit_conf and not path(rabbit_conf).isfile(): raise ValueError( 'argument passed to --rabbit-config is not a valid file path' ) redis_proc = factories.redis_proc() redisdb = factories.redisdb('redis_proc') postgresql_proc = factories.postgresql_proc() postgresql = factories.postgresql('postgresql_proc') mysql_proc = factories.mysql_proc() mysql = factories.mysql('mysql_proc') @pytest.fixture def mysqldb(mysql): warnings.warn( '`mysqldb` fixture is deprecated. Please use `mysql` instead.', DeprecationWarning, 2 ) return mysql
from pytest_dbfixtures import factories from tempfile import NamedTemporaryFile import os import pytest import re import subprocess from abridger.abridge_db import main from abridger.database.sqlite import SqliteDatabase from test.abridge_db_test_utils import TestAbridgeDbBase from test.conftest import got_postgresql from test.fixtures.postgresql import make_postgresql_database postgresql_proc2 = factories.postgresql_proc(port=5434) postgresql2 = factories.postgresql('postgresql_proc2') @pytest.mark.skipif(not got_postgresql(), reason='Needs postgresql') class TestAbridgeDbForPostgresql(TestAbridgeDbBase): def setup_method(self, method): self.src_database = None self.dst_database = None def teardown_method(self, method): # Belt and braces in case something unexpected fails if self.src_database is not None: self.src_database.disconnect if self.dst_database is not None: self.dst_database.disconnect def prepare_src(self, postgresql):
import pytest from pytest_dbfixtures import factories query = "CREATE TABLE test (id serial PRIMARY KEY, num integer, data varchar);" postgresql91 = factories.postgresql_proc( '/usr/lib/postgresql/9.1/bin/pg_ctl', port=9877) postgresql92 = factories.postgresql_proc( '/usr/lib/postgresql/9.2/bin/pg_ctl', port=9878) postgresql93 = factories.postgresql_proc( '/usr/lib/postgresql/9.3/bin/pg_ctl', port=9879) @pytest.mark.parametrize('postgres', ('postgresql91', 'postgresql92', 'postgresql93',)) def test_postgresql_proc(request, postgres): postgresql_proc = request.getfuncargvalue(postgres) assert postgresql_proc.running() is True def test_main_postgres(postgresql): cur = postgresql.cursor() cur.execute(query) postgresql.commit() cur.close() postgresql_proc2 = factories.postgresql_proc(port=9876) postgresql2 = factories.postgresql('postgresql_proc2', port=9876)
from pytest_dbfixtures import factories from tempfile import NamedTemporaryFile import os import pytest import re import subprocess from abridger.abridge_db import main from abridger.database.sqlite import SqliteDatabase from test.abridge_db_test_utils import TestAbridgeDbBase from test.conftest import got_postgresql from test.fixtures.postgresql import make_postgresql_database postgresql_proc2 = factories.postgresql_proc(port=5434) postgresql2 = factories.postgresql('postgresql_proc2') @pytest.mark.skipif(not got_postgresql(), reason='Needs postgresql') class TestAbridgeDbForPostgresql(TestAbridgeDbBase): def setup_method(self, method): self.src_database = None self.dst_database = None def teardown_method(self, method): # Belt and braces in case something unexpected fails if self.src_database is not None: self.src_database.disconnect if self.dst_database is not None: self.dst_database.disconnect