blob: 89ee106adb4c6152d3a4d76012691081dd458404 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
#! /usr/bin/env python3
import sys
import sqlite3
if len(sys.argv) == 3:
inp = open(sys.argv[2])
elif len(sys.argv) == 2:
inp = sys.stdin
else:
print("bad arguments")
sys.exit(1)
with sqlite3.connect(sys.argv[1]) as conn:
conn.execute('''CREATE TABLE IF NOT EXISTS LUT (K TEXT UNIQUE);''')
conn.execute('DELETE FROM LUT;')
for l in inp:
conn.execute('INSERT OR IGNORE INTO LUT(K) VALUES (?);', (l[:-1],))
|
