Mercurial > repos > iuc > sqlite_to_tabular
comparison load_db.py @ 2:150765965caa draft
planemo upload for repository https://github.com/galaxyproject/tools-iuc/tree/master/tools/query_tabular commit 4a3c9f195ba5d899b1a1ce5e80281cdf230f456a
| author | iuc |
|---|---|
| date | Mon, 23 Oct 2017 13:27:54 -0400 |
| parents | c1b700bc0150 |
| children | b722161a845a |
comparison
equal
deleted
inserted
replaced
| 1:c1b700bc0150 | 2:150765965caa |
|---|---|
| 164 def getValueType(val): | 164 def getValueType(val): |
| 165 if val or 0. == val: | 165 if val or 0. == val: |
| 166 try: | 166 try: |
| 167 int(val) | 167 int(val) |
| 168 return 'INTEGER' | 168 return 'INTEGER' |
| 169 except: | 169 except ValueError: |
| 170 try: | 170 try: |
| 171 float(val) | 171 float(val) |
| 172 return 'REAL' | 172 return 'REAL' |
| 173 except: | 173 except ValueError: |
| 174 return 'TEXT' | 174 return 'TEXT' |
| 175 return None | 175 return None |
| 176 | 176 |
| 177 | 177 |
| 178 def get_column_def(file_path, table_name, skip=0, comment_char='#', | 178 def get_column_def(file_path, table_name, skip=0, comment_char='#', |