file = open('villages.txt')
conn = sqlite3.connect('villages')
c = conn.cursor()
for line in file.readlines():
    c.execute('INSERT INTO village VALUES (?, ?, ?, ?, ?, ?, ?)', tuple(line.split(','))
conn.commit()
conn.close()
file.close()