comparison sqlite_to_tabular.py @ 2:123b9ca5e26a draft default tip

planemo upload for repository https://github.com/jj-umn/galaxytools/tree/master/sqlite_to_tabular commit ae4f3ee9048be3ebc9fa3bc0783e73ac31082899-dirty

1:78e9570fbe08

        cur = conn.cursor()
        results = cur.execute(query)
        if not options.no_header:
            outputFile.write("#%s\n" % '\t'.join([str(col[0]) for col in cur.description]))
        for i, row in enumerate(results):
            outputFile.write("%s\n" % '\t'.join([str(val) for val in row]))
    except Exception, exc:
        print >> sys.stderr, "Error: %s" % exc
        exit(1)

if __name__ == "__main__":

2:123b9ca5e26a

        cur = conn.cursor()
        results = cur.execute(query)
        if not options.no_header:
            outputFile.write("#%s\n" % '\t'.join([str(col[0]) for col in cur.description]))
        for i, row in enumerate(results):
            outputFile.write("%s\n" % '\t'.join([str(val) if val is not None else '' for val in row]))
    except Exception, exc:
        print >> sys.stderr, "Error: %s" % exc
        exit(1)

if __name__ == "__main__":