Initial importHEADmaster

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 @@
+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()