blob: 61810175031bf6057e41e0e18bb12edb8854fee5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
import sqlite3
import codecs
db = sqlite3.connect('iTunes/iTunesLibrary.db')
curs = db.cursor()
with codecs.open('tracks.txt', 'r', 'utf-8') as fp:
for track in fp:
curs.execute('insert into filesystem(location) values(?)', (track.strip(),))
db.commit()
|