def __init__(self, **kwargs):
self.log = logger
self.host = kwargs['host']
self.port = int(kwargs.get('port', 5432))
self.username = kwargs['username']
self.schema = kwargs['schema']
self.db_name = kwargs['database']
self.db = sqldbx.PostgreSQLDatabase(self.host, self.db_name, self.port)
self.db.login(self.username, kwargs['password'])
self._data_manager = sqldbx.PersistenceManager(self.db)
def __init__(self, **kwargs):
self.host = kwargs['host']
self.port = int(kwargs.get('port', 3306))
self.username = kwargs['username']
self.db_name = kwargs['database']
self.db = sqldbx.MySQLDatabase(self.host, self.db_name, self.port)
self.db.login(self.username, kwargs['password'])
self._data_manager = sqldbx.PersistenceManager(self.db)
self.Base = automap_base()
self.Base.prepare(self.db.engine, reflect=True)
def __init__(self, **kwargs):
kwreader = common.KeywordArgReader('host', 'username', 'database', 'password')
kwreader.read(**kwargs)
self.host = kwreader.get_value('host')
self.port = int(kwreader.get_value('port') or 1433)
self.username = kwreader.get_value('username')
self.db_name = kwreader.get_value('database')
self.password = kwreader.get_value('password')
self.db = sqldbx.SQLServerDatabase(self.host, self.db_name, self.port)
self.db.login(self.username, self.password)
self._data_manager = sqldbx.PersistenceManager(self.db)
def __init__(self, **kwargs):
port = int(kwargs['port'])
self.db = sqldbx.PostgreSQLDatabase(kwargs['host'],
kwargs['database'],
port)
self.username = kwargs['username']
self.password = kwargs['password']
self.schema = kwargs['schema']
self.data_manager = None
self.db.login(self.username, self.password)
self.data_manager = sqldbx.PersistenceManager(self.db)
self.Base = automap_base()
self.Base.prepare(self.db.engine, reflect=True)
def __init__(self, source_tablespec, source_sqldb):
self._src_tablespec = source_tablespec
self._src_pmgr = sqlx.PersistenceManager(source_sqldb)
def login(self, password):
self.db.login(self.username, password, self.schema)
self.data_manager = sqldbx.PersistenceManager(self.db)