blob: 3f5ccd8e39e5560685ec6bf164753cd441142d8c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
import sqlite3
def unfuck_unicode(text):
return ''.join([chr(n) for n in [ord(i) for i in text]]).decode('utf-8')
conn = sqlite3.connect('iTunesLibrary.db')
curs = conn.cursor()
upcurs = conn.cursor()
curs.execute('select track_id, location from track where location is not null')
for id, datum in curs.fetchall():
try:
datum.decode('utf-8')
except UnicodeEncodeError:
print id, type(datum), datum.encode('utf-8')
#upcurs.execute('update track set location = ? where track_id = ?',
# (datum.encode('utf-8'), id))
conn.commit()
|