class Relational(StorageInfo):
conn_str = Unicode
pool_size = UnsignedInteger
max_overflow = UnsignedInteger
pool_recycle = UnsignedInteger
pool_timeout = UnsignedInteger
sync_pool = Boolean
async_pool = Boolean
def __init__(self, *args, **kwargs):
super(Relational, self).__init__(*args, **kwargs)
self.itself = None
def apply(self):
self.itself = SqlDataStore(self.conn_str, pool_size=self.pool_size)
if not (self.async_pool or self.sync_pool):
logger.debug("Store '%s' is disabled.", self.name)
if self.async_pool:
if self.conn_str.startswith('postgres'):
self.itself.add_txpool()
else:
self.async_pool = False
if not self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.close()
self.itself.engine = None
class Relational(StorageInfo):
conn_str = Unicode
pool_size = UnsignedInteger(default=10)
max_overflow = UnsignedInteger(default=3)
pool_recycle = UnsignedInteger(default=3600)
pool_timeout = UnsignedInteger(default=30)
sync_pool = Boolean(default=True)
async_pool = Boolean(default=True)
def __init__(self, *args, **kwargs):
super(Relational, self).__init__(*args, **kwargs)
self.itself = None
def apply(self):
self.itself = SqlDataStore(self.conn_str, pool_size=self.pool_size)
if not (self.async_pool or self.sync_pool):
logger.debug("Store '%s' is disabled.", self.name)
if self.async_pool:
if self.conn_str.startswith('postgres'):
self.itself.add_txpool()
else:
self.async_pool = False
if not self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.close()
self.itself.engine = None
return self
class Relational(StorageInfo):
conn_str = Unicode
# move these to QueuePool config.
pool_size = UnsignedInteger(default=10)
pool_recycle = UnsignedInteger(default=3600)
pool_timeout = UnsignedInteger(default=30)
max_overflow = UnsignedInteger(default=3)
echo_pool = Boolean(default=False)
sync_pool = Boolean(default=True)
sync_pool_type = Unicode(
default='QueuePool',
values=[
'SingletonThreadPool', 'QueuePool', 'NullPool',
'StaticPool', 'AssertionPool'
],
)
async_pool = Boolean(default=True)
def __init__(self, *args, **kwargs):
super(Relational, self).__init__(*args, **kwargs)
self.itself = None
def apply(self):
self.itself = SqlDataStore(self.conn_str, pool_size=self.pool_size,
echo_pool=self.echo_pool)
if not (self.async_pool or self.sync_pool):
logger.debug("Store '%s' is disabled.", self.name)
if self.async_pool:
if self.conn_str.startswith('postgres'):
self.itself.add_txpool()
else:
self.async_pool = False
if not self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.dispose()
self.itself.engine = None
return self
def close(self):
if self.async_pool:
self.itself.txpool.close()
if self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.dispose()
self.itself.engine = None
self.itself = None
return self
def apply(self):
self.itself = SqlDataStore(self.conn_str, pool_size=self.pool_size)
if not (self.async_pool or self.sync_pool):
logger.debug("Store '%s' is disabled.", self.name)
if self.async_pool:
if self.conn_str.startswith('postgres'):
self.itself.add_txpool()
else:
self.async_pool = False
if not self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.close()
self.itself.engine = None
def apply(self):
self.itself = SqlDataStore(self.conn_str, pool_size=self.pool_size)
if not (self.async_pool or self.sync_pool):
logger.debug("Store '%s' is disabled.", self.name)
if self.async_pool:
if self.conn_str.startswith('postgres'):
self.itself.add_txpool()
else:
self.async_pool = False
if not self.sync_pool:
self.itself.Session = None
self.itself.metadata = None
self.itself.engine.close()
self.itself.engine = None
return self
