92xg1kGK

1import sqlite3
2import sys
3import time
4
5DB_CREATE_TABLE = 'CREATE TABLE IF NOT EXISTS items (item TEXT)'
6DB_INSERT = 'INSERT INTO items VALUES (?)'
7FILENAME = 'test.db'
8
9
10def main():
11    index = int()
12    c = sqlite3.connect(FILENAME)
13    c.execute(DB_CREATE_TABLE)
14    c.commit()
15
16    while True:
17        item = '{name}_{index}'.format(name=sys.argv[1], index=index)
18        c.execute(DB_INSERT, (item,))
19        c.commit()
20        time.sleep(1)
21        index += 1
22
23    c.close()
24
25
26if __name__ == '__main__':
27    main()
28	
29python3 test.py foo &
30python3 test.py bar &