about summary refs log tree commit diff
diff options
context:
space:
mode:
authorZachary Sloan2013-04-24 19:56:39 +0000
committerZachary Sloan2013-04-24 19:56:39 +0000
commit23dbf30e4c96faae3fda19f539be2a8b260dc957 (patch)
treeda4c0ec00396be2c23fc7181afdbd7b187ae0384
parent4e6722beb4302bf22719ad783443767bb1ba7f6a (diff)
downloadgenenetwork2-23dbf30e4c96faae3fda19f539be2a8b260dc957.tar.gz
Checking in quick_search_table.py before using pylin
-rw-r--r--wqflask/maintenance/quick_search_table.py13
1 files changed, 7 insertions, 6 deletions
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__":