1 files changed, 12 insertions, 0 deletions
diff --git a/web/webqtl/search/pubmedsearch.py b/web/webqtl/search/pubmedsearch.py
new file mode 100755
index 00000000..d0d18ff5
--- /dev/null
+++ b/web/webqtl/search/pubmedsearch.py
@@ -0,0 +1,12 @@
+import sys
+import os
+import MySQLdb
+import time
+
+db='db_webqtl_leiyan'
+author="megan memphis"
+
+con = MySQLdb.Connect(db=db,user='webqtlupd',passwd='webqtl', host="localhost")
+cursor = con.cursor()
+cursor.execute('select PhenotypeId, Locus, DataId, Phenotype.Post_publication_description from PublishXRef, Phenotype where PublishXRef.PhenotypeId = Phenotype.Id and InbredSetId=%s'%InbredSetId)
+PublishXRefInfos = cursor.fetchall()