Untitled


#import data to sqlite db test.db
import sqlite3 as lite
import sys


con = lite.connect('test.db')
with con:
        cur = con.cursor()
        cur.executescript('drop table if exists Names;')
        cur.execute("CREATE TABLE Names(Id INT PRIMARY KEY, Name TEXT);")
        with open('file.txt') as f:
                for line in f:
                        line.strip()
                        print line
                        cur.execute('INSERT INTO Names(Name) VALUES(?)', line)