def setUp(self): self.cnx = get_connection(driver='mysql', host='localhost', database='maay_test', user='******', password='******') self.querier = MaayQuerier(connection=self.cnx) self.nodeId = '0'*40 self.querier.registerNode(self.nodeId, "127.0.0.1", 6789, 10)
def _do_backup(): import time from logilab.common.db import get_connection dbhost = sys.argv[2] dbname = sys.argv[3] filename = sys.argv[4] cnx = get_connection( driver="sqlserver2005", host=dbhost, database=dbname, extra_args="autocommit;trusted_connection" ) cursor = cnx.cursor() cursor.execute("BACKUP DATABASE ? TO DISK= ? ", (dbname, filename)) prev_size = -1 err_count = 0 same_size_count = 0 while err_count < 10 and same_size_count < 10: time.sleep(1) try: size = os.path.getsize(filename) except OSError, exc: err_count += 1 print exc if size > prev_size: same_size_count = 0 prev_size = size else: same_size_count += 1
def setUp(self): self.cnx = get_connection(driver='mysql', host='crater', database='maay_test', user='******', password='******') self.querier = MaayQuerier(connection=self.cnx)
def setUp(self): self.cnx = get_connection(driver='mysql', host='localhost', database='maay_test', user='******', password='******') self.querier = MaayQuerier(connection=self.cnx) self.nodeId = '0'*40 self.querier.registerNode(self.nodeId, "192.168.0.123", 6789, 10)
def _do_restore(): """return the SQL statement to restore a backup of the given database""" from logilab.common.db import get_connection dbhost = sys.argv[2] dbname = sys.argv[3] filename = sys.argv[4] cnx = get_connection( driver="sqlserver2005", host=dbhost, database="master", extra_args="autocommit;trusted_connection" ) cursor = cnx.cursor() cursor.execute("RESTORE DATABASE ? FROM DISK= ? WITH REPLACE", (dbname, filename)) sys.exit(0)