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)
string = "total number of paths: %i" % ( len(lPathId) )
logging.info( string )
if verbose > 0:
print string
# prepare the subject table
if stype == "path":
