if user == "" and os.environ.get( "REPET_USER" ) != "":
user = os.environ.get( "REPET_USER" )
if passwd == "" and os.environ.get( "REPET_PW" ) != "":
passwd = os.environ.get( "REPET_PW" )
if dbname == "" and os.environ.get( "REPET_DB" ) != "":
dbname = os.environ.get( "REPET_DB" )
if host == "" or user == "" or passwd == "" or dbname == "":
print "ERROR: missing information about MySQL connection"
sys.exit(1)
db = DbMySql( user, host, passwd, dbname )
if outTable == "":
outTable = "%s_noSSR" % ( qtable )
db.copyTable( qtable, outTable )
qtable = outTable
# prepare the query table
if qtype == "path":
db.createPathIndex( qtable )
qtablePathAdaptator = TablePathAdaptator( db, qtable )
lPathId = qtablePathAdaptator.getIdList()
elif qtype == "set":
db.createSetIndex( qtable )
qtableSetAdaptator = TableSetAdaptator( db, qtable )
lPathId = qtableSetAdaptator.getIdList()
else:
print "ERROR: unknown query table type: %s" % ( qtype )
sys.exit(1)
if dbname == "" and os.environ.get( "REPET_DB" ) != "":
dbname = os.environ.get( "REPET_DB" )
if host == "" or user == "" or passwd == "" or dbname == "":
print "*** Error: missing information about MySQL connection"
sys.exit(1)
global db
db = DbMySql( user, host, passwd, dbname )
dTmpH2InitH = getLinkTmp2Init( link )
if verbose > 0:
print "nb of relationships: %i" % ( len(dTmpH2InitH.keys()) )
tmpTable = "%s_tmp" % ( inTable )
db.copyTable( inTable, tmpTable )
if replaceQ == True:
for tmpH in dTmpH2InitH.keys():
qry = "UPDATE %s SET query_name=\"%s\" WHERE query_name=\"%s\"" % ( tmpTable, dTmpH2InitH[ tmpH ], tmpH )
db.execute( qry )
if replaceS == True:
for tmpH in dTmpH2InitH.keys():
qry = "UPDATE %s SET subject_name=\"%s\" WHERE subject_name=\"%s\"" % ( tmpTable, dTmpH2InitH[ tmpH ], tmpH )
db.execute( qry )
if outTable == "":
outTable = inTable
db.copyTable( tmpTable, outTable )
db.dropTable( tmpTable )
