本文整理匯總了Python中result.Result.snpInsertStart方法的典型用法代碼示例。如果您正苦於以下問題:Python Result.snpInsertStart方法的具體用法?Python Result.snpInsertStart怎麽用?Python Result.snpInsertStart使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類result.Result
的用法示例。
在下文中一共展示了Result.snpInsertStart方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的Python代碼示例。
示例1: snp
# 需要導入模塊: from result import Result [as 別名]
# 或者: from result.Result import snpInsertStart [as 別名]
rsidList[row[0]] = 0
insStr = "INSERT INTO snp (rsid, chr, has_sig) VALUES ('{0}', '{1}', {2}) RETURNING id".format(row[0], row[1], hasSig)
snpInserts[row[0]] = insStr
# Data for reporting
result.snpLoadEnd = time.time()
result.totalSnps = len(snpInserts)
# Insert SNP data into postgres
cursor = postgresConnection.cursor()
print "Chromosome " + str(curChr) + ". Inserting SNP Data."
sys.stdout.flush()
# Log current run start time
result.snpInsertStart = time.time()
# For each snp, insert record and then grab primary key
for rsid,snp in snpInserts.iteritems():
cursor.execute(snp)
rsidList[rsid] = cursor.fetchone()[0]
# Commit all inserts to pgsql and grab end time
postgresConnection.commit()
# Log completed time, close pgsql cursor
result.snpInsertEnd=time.time()
cursor.close()
# Clear list of SNPs to free up memory
snpInserts.clear()