pytest-mysql 2.2.0

Populating database for tests

With SQLAlchemy

This example shows how to populate database and create an SQLAlchemy’s ORM connection:

Sample below is simplified session fixture from pyramid_fullauth tests:

from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy.pool import NullPool
from zope.sqlalchemy import register


@pytest.fixture
def db_session(mysql):
    """Session for SQLAlchemy."""
    from pyramid_fullauth.models import Base  # pylint:disable=import-outside-toplevel

    # assumes setting, these can be obtained from pytest-mysql config or mysql_proc
    connection = f'mysql+mysqldb://root:@127.0.0.1:3307/tests?charset=utf8'

    engine = create_engine(connection, echo=False, poolclass=NullPool)
    pyramid_basemodel.Session = scoped_session(sessionmaker(extension=ZopeTransactionExtension()))
    pyramid_basemodel.bind_engine(
        engine, pyramid_basemodel.Session, should_create=True, should_drop=True)

    yield pyramid_basemodel.Session

    transaction.commit()
    Base.metadata.drop_all(engine)


@pytest.fixture
def user(db_session):
    """Test user fixture."""
    from pyramid_fullauth.models import User
    from tests.tools import DEFAULT_USER

    new_user = User(**DEFAULT_USER)
    db_session.add(new_user)
    transaction.commit()
    return new_user


def test_remove_last_admin(db_session, user):
    """
    Sample test checks internal login, but shows usage in tests with SQLAlchemy
    """
    user = db_session.merge(user)
    user.is_admin = True
    transaction.commit()
    user = db_session.merge(user)

    with pytest.raises(AttributeError):
        user.is_admin = False

Connecting to MySQL/MariaDB (in a docker)

To connect to a docker run postgresql and run test on it, use noproc fixtures.

docker run --name some-db -e MYSQL_ALLOW_EMPTY_PASSWORD=yes -d mysql --expose 3306

docker run --name some-db -e MARIADB_ALLOW_EMPTY_PASSWORD=yes -d mariadb --expose 3306

This will start postgresql in a docker container, however using a postgresql installed locally is not much different.

In tests, make sure that all your tests are using mysql_noproc fixture like that:

mysql_in_docker = factories.mysql_noproc()
mysql = factories.mysql("mysql_in_docker")


def test_mysql_docker(mysql):
    """Run test."""
    cur = mysql.cursor()
    cur.query("CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);")
    mysql.commit()
    cur.close()

And run tests:

pytest --mysql-host=127.0.0.1

Package resources

• Bug tracker: https://github.com/ClearcodeHQ/pytest-mysql/issues

2.2.0

2.1.0

2.0.3

• [enhancement] Do not assume that mysql executables are in /usr/bin

2.0.2

• [enhancement] Preemptively read data after each test in mysql client fixture. This will make test run if the test itself forgot to fetch queried data.

• [enhnacement] Require at least mirakuru 2.3.0 - forced by changed stop method parameters change

2.0.1

• [fix] Improved mysql version detection on osx

• [build] extracted xdist into separate stage on travis

• [build] have deployemt as separate stage on travis

2.0.0

• [Enhancements] Add support for MySQL 5.7.6 and up with new configuration options. Legacy configuration supports older MySQL and MariaDB databases.

• [breaking] mysql_exec ini option replaced with mysql_mysqld_safe

• [breaking] –mysql-exec cmd option replaced with –mysql-mysqld-safe

• [breaking] replaced mysql_init ini option with mysql_install_db

• [breaking] replaced –mysql-init cmd option with –mysql-install-db

• [breaking] added mysql_mysqld option and –mysql-mysqld cmd option

1.1.1

• [enhancements] removed path.py dependency

1.1.0

• [enhancement] change deprecated getfuncargvalaue to getfixturevalues, require at least pytest 3.0.0

1.0.0

• [enhancements] create command line and pytest.ini configuration options for mysql’s log directory location

• [enhancements] create command line and pytest.ini configuration options for mysql’s starting parametetrs

• [enhancements] create command line and pytest.ini configuration options for mysql test database name

• [enhancements] create command line and pytest.ini configuration options for mysql’s user password

• [enhancements] create command line and pytest.ini configuration options for mysql user

• [enhancements] create command line and pytest.ini configuration options for mysql host

• [enhancements] create command line and pytest.ini configuration options for mysql port

• [enhancements] create command line and pytest.ini configuration options for mysql’s init executable

• [enhancements] create command line and pytest.ini configuration options for mysql’s admin executable

• [enhancements] create command line and pytest.ini configuration options for mysql executable

• [enhancements] create command line and pytest.ini configuration options for mysql logsdir