class TestSQLShardedDB(TestSQLDB):
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_DBS, create_tables=True)
# adding a node with 100 slots for sync
self.backend._safe_execute('sync',
"""insert into nodes (`node`, `service`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("phx12", "sync", 100, 100, 0, 0, 0)""")
self._sqlite = self.backend._dbs['sync'][0].driver == 'pysqlite'
def tearDown(self):
for service, (engine, __, __) in self.backend._dbs.items():
sqlite = engine.driver == 'pysqlite'
if sqlite:
filename = str(engine.url).split('sqlite://')[-1]
if os.path.exists(filename):
os.remove(filename)
else:
engine.execute('delete from nodes')
engine.execute('delete from user_nodes')
class TestSQLShardedDB(TestSQLDB):
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_DBS, create_tables=True)
# adding a node with 100 slots for sync
self.backend._safe_execute(
'sync', """insert into nodes (`node`, `service`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("phx12", "sync", 100, 100, 0, 0, 0)""")
self._sqlite = self.backend._dbs['sync'][0].driver == 'pysqlite'
def tearDown(self):
for service, (engine, __, __) in self.backend._dbs.items():
sqlite = engine.driver == 'pysqlite'
if sqlite:
filename = str(engine.url).split('sqlite://')[-1]
if os.path.exists(filename):
os.remove(filename)
else:
engine.execute('delete from nodes')
engine.execute('delete from user_nodes')
class TestSQLShardedDB(TestSQLDB):
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_SQLURI, create_tables=True)
# adding a node with 100 slots for sync 1.0
self.backend._safe_execute(
"""insert into nodes (`node`, `service`, `version`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("https://phx12", "sync", "1.0", 100, 100, 0, 0, 0)""",
service="sync",
)
self._sqlite = self.backend._dbs["sync"][0].driver == "pysqlite"
def tearDown(self):
for service, value in self.backend._dbs.items():
engine = value[0]
sqlite = engine.driver == "pysqlite"
if sqlite:
filename = str(engine.url).split("sqlite://")[-1]
if os.path.exists(filename):
os.remove(filename)
else:
engine.execute("delete from nodes")
engine.execute("delete from user_nodes")
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_DBS, create_tables=True)
# adding a node with 100 slots for sync
self.backend._safe_execute(
'sync', """insert into nodes (`node`, `service`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("phx12", "sync", 100, 100, 0, 0, 0)""")
self._sqlite = self.backend._dbs['sync'][0].driver == 'pysqlite'
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_DBS, create_tables=True)
# adding a node with 100 slots for sync
self.backend._safe_execute('sync',
"""insert into nodes (`node`, `service`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("phx12", "sync", 100, 100, 0, 0, 0)""")
self._sqlite = self.backend._dbs['sync'][0].driver == 'pysqlite'
def setUp(self):
super(TestSQLDB, self).setUp()
self.backend = ShardedSQLMetadata(_SQLURI, create_tables=True)
# adding a node with 100 slots for sync 1.0
self.backend._safe_execute(
"""insert into nodes (`node`, `service`, `version`, `available`,
`capacity`, `current_load`, `downed`, `backoff`)
values ("https://phx12", "sync", "1.0", 100, 100, 0, 0, 0)""",
service="sync",
)
self._sqlite = self.backend._dbs["sync"][0].driver == "pysqlite"
def setUp(self):
self.backend = ShardedSQLMetadata(_SQLURI, create_tables=True)
super(TestSQLShardedDB, self).setUp()
