def __init__(self):
self.status = True # initialize status to o.k.
source_dbinfo = dbconfig.getConfig('projectdata')
destination_dbinfo = dbconfig.getConfig('importdata')
if source_dbinfo['host'] != destination_dbinfo['host']:
self.escape('projectdata and importdata not on the same host')
self.dbhost = source_dbinfo['host']
self.source_dbname = source_dbinfo['db']
self.destination_dbname = destination_dbinfo['db']
def checkSinedon():
try:
destination_dbinfo = dbconfig.getConfig('importdata')
except KeyError:
print "Please define impordata module in sinedon.cfg"
sys.exit(1)
if not hasattr(sinedon.dbdatakeeper.DBDataKeeper,'initImported'):
print "sinedon must be imported from myami-dbcopy branch"
print "currently from %s",sinedon.__file__
sys.exit(1)
def importInstall(self):
print "Importing Installation Log...."
source_dbinfo = dbconfig.getConfig('projectdata')
destination_dbinfo = dbconfig.getConfig('importdata')
q = 'select * from install where 1;'
results = directq.complexMysqlQuery('projectdata',q)
q = 'select * from install where 1;'
imported_results = directq.complexMysqlQuery('importdata',q)
for row in results:
keys = row.keys()
values = map((lambda x: row[x]),keys)
if not imported_results:
keystring = '`'+'`,`'.join(keys)+'`'
valuestring = "'"+"','".join(values)+"'"
q = "INSERT into `install` (%s) VALUES (%s)" % (keystring, valuestring)
directq.complexMysqlQuery('importdata',q)
else:
q = "UPDATE `install` SET `value` = '%s' where `install`.`key` = '%s';" % (row['value'],row['key'])
directq.complexMysqlQuery('importdata',q)
def checkSinedonConfig():
from sinedon import dbconfig
confdirs = pyami.fileutil.get_config_dirs(dbconfig)
printSearch('sinedon.cfg')
print "\t",confdirs
allconfigfiles = dbconfig.configfiles
configfile = printResult('sinedon',allconfigfiles)
if configfile:
for module in ['leginondata','projectdata']:
try:
value = dbconfig.getConfig(module)
except:
printError('%s required' % (module))
if not value:
printError('%s required' % (module))
def checkSinedonConfig():
from sinedon import dbconfig
confdirs = pyami.fileutil.get_config_dirs(dbconfig)
printSearch('sinedon.cfg')
print "\t", confdirs
allconfigfiles = dbconfig.configfiles
configfile = printResult('sinedon', allconfigfiles)
if configfile:
for module in ['leginondata', 'projectdata']:
try:
value = dbconfig.getConfig(module)
except:
printError('%s required' % (module))
if not value:
printError('%s required' % (module))
