diff options
Diffstat (limited to 'src/test.py')
-rw-r--r-- | src/test.py | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/src/test.py b/src/test.py new file mode 100644 index 0000000..3f5ccd8 --- /dev/null +++ b/src/test.py | |||
@@ -0,0 +1,21 @@ | |||
1 | import sqlite3 | ||
2 | |||
3 | def unfuck_unicode(text): | ||
4 | return ''.join([chr(n) for n in [ord(i) for i in text]]).decode('utf-8') | ||
5 | |||
6 | conn = sqlite3.connect('iTunesLibrary.db') | ||
7 | curs = conn.cursor() | ||
8 | upcurs = conn.cursor() | ||
9 | |||
10 | curs.execute('select track_id, location from track where location is not null') | ||
11 | |||
12 | |||
13 | for id, datum in curs.fetchall(): | ||
14 | try: | ||
15 | datum.decode('utf-8') | ||
16 | except UnicodeEncodeError: | ||
17 | print id, type(datum), datum.encode('utf-8') | ||
18 | #upcurs.execute('update track set location = ? where track_id = ?', | ||
19 | # (datum.encode('utf-8'), id)) | ||
20 | |||
21 | conn.commit() | ||