Python mysql_proc示例

示例#1

文件： test_mysql.py 项目： dbrgn/pytest-dbfixtures

query = '''CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);'''


def test_proc(mysql_proc):
    assert mysql_proc.running()
    pass


def test_mysql(mysql):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()


mysql_proc2 = factories.mysql_proc(port=3308, params='--skip-sync-frm')
mysql2 = factories.mysql('mysql_proc2', port=3308)


def test_mysql_newfixture(mysql, mysql2):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()

    cursor = mysql2.cursor()
    cursor.execute(query)
    mysql2.commit()
    cursor.close()

示例#2

        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')

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


rabbitmq_proc = factories.rabbitmq_proc()
rabbitmq = factories.rabbitmq('rabbitmq_proc')

dynamodb_proc = factories.dynamodb_proc()

示例#3

文件： plugin.py 项目： domenkozar/pytest-dbfixtures

            '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()
elasticsearch = factories.elasticsearch('elasticsearch_proc')

示例#4

query = '''CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);'''


def test_proc(mysql_proc):
    assert mysql_proc.running()
    pass


def test_mysql(mysqldb):
    cursor = mysqldb.cursor()
    cursor.execute(query)
    mysqldb.commit()
    cursor.close()


mysql_proc2 = factories.mysql_proc(port=3308, params='--skip-sync-frm')
mysqldb2 = factories.mysqldb('mysql_proc2', port=3308)


def test_mysql_newfixture(mysqldb, mysqldb2):
    cursor = mysqldb.cursor()
    cursor.execute(query)
    mysqldb.commit()
    cursor.close()

    cursor = mysqldb2.cursor()
    cursor.execute(query)
    mysqldb2.commit()
    cursor.close()

示例#5

文件： test_mysql.py 项目： markovianhq/pytest-dbfixtures

query = '''CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);'''


def test_proc(mysql_proc):
    assert mysql_proc.running()


def test_mysql(mysql):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()


mysql_proc2 = factories.mysql_proc(port=3308, params='--skip-sync-frm')
mysql2 = factories.mysql('mysql_proc2')


def test_mysql_newfixture(mysql, mysql2):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()

    cursor = mysql2.cursor()
    cursor.execute(query)
    mysql2.commit()
    cursor.close()

示例#6

文件： test_mysql.py 项目： domenkozar/pytest-dbfixtures

query = '''CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
    species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);'''


def test_proc(mysql_proc):
    assert mysql_proc.running()


def test_mysql(mysql):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()


mysql_proc2 = factories.mysql_proc(port=3308, params='--skip-sync-frm')
mysql2 = factories.mysql('mysql_proc2')


def test_mysql_newfixture(mysql, mysql2):
    cursor = mysql.cursor()
    cursor.execute(query)
    mysql.commit()
    cursor.close()

    cursor = mysql2.cursor()
    cursor.execute(query)
    mysql2.commit()
    cursor.close()