Source code for panko.tests.db

#
# Copyright 2012 New Dream Network, LLC (DreamHost)
# Copyright 2013 eNovance
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.

"""Base classes for API tests."""
import os
import warnings

import fixtures
import mock
from oslo_utils import uuidutils
from oslotest import mockpatch
import six
from six.moves.urllib import parse as urlparse
import sqlalchemy
from testtools import testcase

from panko import service
from panko import storage
from panko.tests import base as test_base
try:
    from panko.tests import mocks
except ImportError:
    mocks = None   # happybase module is not Python 3 compatible yet


[docs]class MongoDbManager(fixtures.Fixture): def __init__(self, url, conf): self._url = url self.conf = conf
[docs] def setUp(self): super(MongoDbManager, self).setUp() with warnings.catch_warnings(): warnings.filterwarnings( action='ignore', message='.*you must provide a username and password.*') try: self.connection = storage.get_connection(self.url, self.conf) except storage.StorageBadVersion as e: raise testcase.TestSkipped(six.text_type(e))
@property def url(self): return '%(url)s_%(db)s' % { 'url': self._url, 'db': uuidutils.generate_uuid(dashed=False) }
[docs]class SQLManager(fixtures.Fixture): def __init__(self, url, conf): db_name = 'panko_%s' % uuidutils.generate_uuid(dashed=False) engine = sqlalchemy.create_engine(url) conn = engine.connect() self._create_database(conn, db_name) conn.close() engine.dispose() parsed = list(urlparse.urlparse(url)) parsed[2] = '/' + db_name self.url = urlparse.urlunparse(parsed) self.conf = conf
[docs] def setUp(self): super(SQLManager, self).setUp() self.connection = storage.get_connection(self.url, self.conf)
[docs]class PgSQLManager(SQLManager): @staticmethod def _create_database(conn, db_name): conn.connection.set_isolation_level(0) conn.execute('CREATE DATABASE %s WITH TEMPLATE template0;' % db_name) conn.connection.set_isolation_level(1)
[docs]class MySQLManager(SQLManager): @staticmethod def _create_database(conn, db_name): conn.execute('CREATE DATABASE %s;' % db_name)
[docs]class ElasticSearchManager(fixtures.Fixture): def __init__(self, url, conf): self.url = url self.conf = conf
[docs] def setUp(self): super(ElasticSearchManager, self).setUp() self.connection = storage.get_connection( self.url, self.conf) # prefix each test with unique index name inx_uuid = uuidutils.generate_uuid(dashed=False) self.connection.index_name = 'events_%s' % inx_uuid # force index on write so data is queryable right away self.connection._refresh_on_write = True
[docs]class HBaseManager(fixtures.Fixture): def __init__(self, url, conf): self._url = url self.conf = conf
[docs] def setUp(self): super(HBaseManager, self).setUp() self.connection = storage.get_connection( self.url, self.conf) # Unique prefix for each test to keep data is distinguished because # all test data is stored in one table data_prefix = uuidutils.generate_uuid(dashed=False) def table(conn, name): return mocks.MockHBaseTable(name, conn, data_prefix) # Mock only real HBase connection, MConnection "table" method # stays origin. mock.patch('happybase.Connection.table', new=table).start() # We shouldn't delete data and tables after each test, # because it last for too long. # All tests tables will be deleted in setup-test-env.sh mock.patch("happybase.Connection.disable_table", new=mock.MagicMock()).start() mock.patch("happybase.Connection.delete_table", new=mock.MagicMock()).start() mock.patch("happybase.Connection.create_table", new=mock.MagicMock()).start()
@property def url(self): return '%s?table_prefix=%s&table_prefix_separator=%s' % ( self._url, os.getenv("PANKO_TEST_HBASE_TABLE_PREFIX", "test"), os.getenv("PANKO_TEST_HBASE_TABLE_PREFIX_SEPARATOR", "_") )
[docs]class SQLiteManager(fixtures.Fixture): def __init__(self, url, conf): self.url = url self.conf = conf
[docs] def setUp(self): super(SQLiteManager, self).setUp() self.connection = storage.get_connection( self.url, self.conf)
@six.add_metaclass(test_base.SkipNotImplementedMeta)
[docs]class TestBase(test_base.BaseTestCase): DRIVER_MANAGERS = { 'mongodb': MongoDbManager, 'mysql': MySQLManager, 'postgresql': PgSQLManager, 'sqlite': SQLiteManager, 'es': ElasticSearchManager, } if mocks is not None: DRIVER_MANAGERS['hbase'] = HBaseManager
[docs] def setUp(self): super(TestBase, self).setUp() db_url = os.environ.get('PIFPAF_URL', "sqlite://").replace( "mysql://", "mysql+pymysql://") engine = urlparse.urlparse(db_url).scheme # in case some drivers have additional specification, for example: # PyMySQL will have scheme mysql+pymysql engine = engine.split('+')[0] # NOTE(Alexei_987) Shortcut to skip expensive db setUp test_method = self._get_test_method() if (hasattr(test_method, '_run_with') and engine not in test_method._run_with): raise testcase.TestSkipped( 'Test is not applicable for %s' % engine) self.CONF = service.prepare_service([], []) manager = self.DRIVER_MANAGERS.get(engine) if not manager: self.skipTest("missing driver manager: %s" % engine) self.db_manager = manager(db_url, self.CONF) self.useFixture(self.db_manager) self.conn = self.db_manager.connection self.conn.upgrade() self.useFixture(mockpatch.Patch('panko.storage.get_connection', side_effect=self._get_connection))
[docs] def tearDown(self): self.conn.clear() self.conn = None super(TestBase, self).tearDown()
def _get_connection(self, url, conf): return self.conn
def run_with(*drivers): """Used to mark tests that are only applicable for certain db driver. Skips test if driver is not available. """ def decorator(test): if isinstance(test, type) and issubclass(test, TestBase): # Decorate all test methods for attr in dir(test): value = getattr(test, attr) if callable(value) and attr.startswith('test_'): if six.PY3: value._run_with = drivers else: value.__func__._run_with = drivers else: test._run_with = drivers return test return decorator

Project Source