From 23dbf30e4c96faae3fda19f539be2a8b260dc957 Mon Sep 17 00:00:00 2001
From: Zachary Sloan
Date: Wed, 24 Apr 2013 19:56:39 +0000
Subject: Checking in quick_search_table.py before using pylin

---
 wqflask/maintenance/quick_search_table.py | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)

(limited to 'wqflask/maintenance/quick_search_table.py')

diff --git a/wqflask/maintenance/quick_search_table.py b/wqflask/maintenance/quick_search_table.py
index 9ea8d2a3..aa40badf 100644
--- a/wqflask/maintenance/quick_search_table.py
+++ b/wqflask/maintenance/quick_search_table.py
@@ -136,7 +136,7 @@ class PublishXRef(Base):
                 "Phenotype.Original_description as description, "
                 "PublishXRef.LRS as lrs, "
                 "PublishXRef.PublicationId as publication_id, "
-                "Publication.PubMed_ID, "
+                "Publication.PubMed_ID as pubmed_id, "
                 "Publication.Year as year, "
                 "Publication.Authors as authors "
                 "FROM PublishXRef, "
@@ -450,11 +450,12 @@ QuickSearch = sa.Table("QuickSearch", Metadata,
         sa.Column('the_key', sa.String(30),
                   primary_key=True, nullable=False, autoincrement=False), # key in database table
         sa.Column('terms', sa.Text), # terms to compare search string with
-        sa.Column('result_fields', sa.Text)  # json
+        sa.Column('result_fields', sa.Text),  # json
+        mysql_engine = 'MyISAM',
                     )
 
-QuickSearch.drop(Engine, checkfirst=True)
-Metadata.create_all(Engine)
+#QuickSearch.drop(Engine, checkfirst=True)
+#Metadata.create_all(Engine)
 
 
 def row2dict(row):
@@ -476,8 +477,8 @@ def page_query(q):
 
 
 def main():
-    ProbeSetXRef.run()
-    GenoXRef.run()
+    #ProbeSetXRef.run()
+    #GenoXRef.run()
     PublishXRef.run()
 
 if __name__ == "__main__":
-- 
cgit v1.2.3