diff options
| author | Zachary Sloan | 2013-04-24 19:56:39 +0000 |
|---|---|---|
| committer | Zachary Sloan | 2013-04-24 19:56:39 +0000 |
| commit | 23dbf30e4c96faae3fda19f539be2a8b260dc957 (patch) | |
| tree | da4c0ec00396be2c23fc7181afdbd7b187ae0384 /wqflask/maintenance/quick_search_table.py | |
| parent | 4e6722beb4302bf22719ad783443767bb1ba7f6a (diff) | |
| download | genenetwork2-23dbf30e4c96faae3fda19f539be2a8b260dc957.tar.gz | |
Checking in quick_search_table.py before using pylin
Diffstat (limited to 'wqflask/maintenance/quick_search_table.py')
| -rw-r--r-- | wqflask/maintenance/quick_search_table.py | 13 |
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__": |