print "Creating ClinSig index..."
sys.stdout.flush()
idxStart = time.time()
cursor.execute(clinIndex)
postgresConnection.commit()
idxEnd = time.time()
result.idxClinSig = idxEnd - idxStart
print "Creating Gene index..."
sys.stdout.flush()
idxStart = time.time()
cursor.execute(geneIndex)
postgresConnection.commit()
idxEnd = time.time()
result.idxGene = idxEnd - idxStart
resultsFile.write(result.toString() + '\n')
# Run queries if requested in args
if runQueries:
for z in range(1,11):
result = Result()
result.method = "pgsql-Qry" + str(z)
result.tag = tag
print "Running queries, count " + str(z)
idxStart = time.time()
cursor.execute("SELECT * FROM locus l, snp s WHERE l.snp_id = s.id AND s.rsid = 'rs8788'")
idxEnd = time.time()
result.qryByRsid = idxEnd - idxStart
