diff options
Diffstat (limited to 'src/load_filesystem.py')
-rw-r--r-- | src/load_filesystem.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/load_filesystem.py b/src/load_filesystem.py new file mode 100644 index 0000000..6181017 --- /dev/null +++ b/src/load_filesystem.py | |||
@@ -0,0 +1,11 @@ | |||
1 | import sqlite3 | ||
2 | import codecs | ||
3 | |||
4 | db = sqlite3.connect('iTunes/iTunesLibrary.db') | ||
5 | curs = db.cursor() | ||
6 | |||
7 | with codecs.open('tracks.txt', 'r', 'utf-8') as fp: | ||
8 | for track in fp: | ||
9 | curs.execute('insert into filesystem(location) values(?)', (track.strip(),)) | ||
10 | |||
11 | db.commit() | ||