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)
def setUp(self):
self.cnx = get_connection(driver='mysql', host='crater',
database='maay_test', user='******',
password='******')
self.querier = MaayQuerier(connection=self.cnx)
