def test_active_connections(self):
"""connecting to a database on a specified server should be done once
only, but same database on a different server should be done"""
ensembl_acct = get_ensembl_account(release='46')
engine1 = DbConnection(account=ensembl_acct,
db_name="homo_sapiens_core_46_36h")
engine2 = DbConnection(account=ensembl_acct,
db_name="homo_sapiens_core_46_36h")
self.assertEqual(engine1, engine2)
def __init__(self, account, species=None, db_type=None, release=None,
pool_recycle=None, division=None):
self._tables = {}
self.db_name = get_db_name(account=account, species=species,
release=release, db_type=db_type, division=division)
if not self.db_name:
raise RuntimeError("%s db doesn't exist for '%s' on '%s'" % \
(db_type, species, account.host))
else:
self.db_name = self.db_name[0]
self._db = DbConnection(account=account, db_name=self.db_name,
pool_recycle=pool_recycle)
self._meta = sql.MetaData(self._db)
self.Type = db_type
def test_pool_recycle_option(self):
"""excercising ability to specify a pool recycle option"""
ensembl_acct = get_ensembl_account(release='56')
engine1 = DbConnection(account=ensembl_acct,
db_name="homo_sapiens_core_46_36h",
pool_recycle=1000)
