Mercurial > repos > iuc > sqlite_to_tabular

comparison sqlite_to_tabular.py @ 1:c1b700bc0150 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
planemo upload for repository https://github.com/galaxyproject/tools-iuc/tree/master/tools/query_tabular commit 81f69ad5f39223059c40501e55ac777d3feca845
author iuc
date Fri, 18 Aug 2017 16:48:20 -0400
parents 859064f07be4
children
comparison
equal deleted inserted replaced
0:859064f07be4 1:c1b700bc0150
19 parser.add_option('-Q', '--query_file', dest='query_file', default=None, 19 parser.add_option('-Q', '--query_file', dest='query_file', default=None,
20 help='SQL query file') 20 help='SQL query file')
21 parser.add_option('-n', '--no_header', dest='no_header', default=False, 21 parser.add_option('-n', '--no_header', dest='no_header', default=False,
22 action='store_true', 22 action='store_true',
23 help='Include a column headers line') 23 help='Include a column headers line')
24 parser.add_option('-c', '--comment_char', dest='comment_char', default='',
25 help='comment character to prefix column header line')
24 parser.add_option('-o', '--output', dest='output', default=None, 26 parser.add_option('-o', '--output', dest='output', default=None,
25 help='Output file for query results') 27 help='Output file for query results')
26 (options, args) = parser.parse_args() 28 (options, args) = parser.parse_args()
27 29
28 # determine output destination 30 # determine output destination
49 exit('Error: %s' % (e)) 51 exit('Error: %s' % (e))
50 exit(0) 52 exit(0)
51 else: 53 else:
52 try: 54 try:
53 run_query(get_connection(options.sqlitedb), query, outputFile, 55 run_query(get_connection(options.sqlitedb), query, outputFile,
54 no_header=options.no_header) 56 no_header=options.no_header,
57 comment_char=options.comment_char)
55 except Exception as e: 58 except Exception as e:
56 exit('Error: %s' % (e)) 59 exit('Error: %s' % (e))
57 60
58 61
59 if __name__ == "__main__": 62 if __name__ == "__main__":