Mercurial > repos > jjohnson > query_tabular
comparison load_db.py @ 22:bed5018e7ae3 draft
Uploaded
author | jjohnson |
---|---|
date | Mon, 17 Jul 2017 15:22:04 -0400 |
parents | ab27c4bd14b9 |
children |
comparison
equal
deleted
inserted
replaced
21:357fe86f245d | 22:bed5018e7ae3 |
---|---|
120 print('Failed at line: %d err: %s' % (linenum, e), | 120 print('Failed at line: %d err: %s' % (linenum, e), |
121 file=sys.stderr) | 121 file=sys.stderr) |
122 conn.commit() | 122 conn.commit() |
123 c.close() | 123 c.close() |
124 except Exception as e: | 124 except Exception as e: |
125 print('Failed: %s' % (e), file=sys.stderr) | 125 exit('Error: %s' % (e)) |
126 exit(1) | |
127 | 126 |
128 | 127 |
129 def create_index(conn, table_name, index_name, index_columns, unique=False): | 128 def create_index(conn, table_name, index_name, index_columns, unique=False): |
130 index_def = "CREATE %s INDEX %s on %s(%s)" % ( | 129 index_def = "CREATE %s INDEX %s on %s(%s)" % ( |
131 'UNIQUE' if unique else '', index_name, | 130 'UNIQUE' if unique else '', index_name, |