versions ---------------- Python 2.6 SQLAlchemy 0.6.0
command ---------------- imdbpy2sql.py -d C:\test\imdb_db\text_files -u sqlite:///C:\test\imdb_db\db.db --sqlite-transactions -o sqlalchemy error ---------------- IMPORTING psyco... FAILED (not a big deal, everything is alright...) RUNNING imdbpy2sql.py EXECUTING "BEGIN:PRAGMA synchronous = OFF;"... EXECUTING "PRAGMA synchronous = OFF;"... DONE! # TIME BEGIN command : 0min, 0sec (wall) 0min, 0sec (user) 0min, 0sec (system) SAVING imdbID values for movies... DONE! (0 entries) SAVING imdbID values for people... DONE! (0 entries) SAVING imdbID values for characters... DONE! (0 entries) SAVING imdbID values for companies... DONE! (0 entries) DROPPING current database... DONE! CREATING new tables... DONE! # TIME dropping and recreating the database : 0min, 0sec (wall) 0min, 0sec (user ) 0min, 0sec (system) SCANNING movies: #1 (2005) (movieID: 1) SCANNING movies: A Dog's Best Friend (1959) (movieID: 10001) SCANNING movies: Aa mujô - Dai nihen: Shichô no maki (1923) (movieID: 20001) SCANNING movies: Alimpuyo (1971) (movieID: 30001) SCANNING movies: Angels' Brigade (1979) (movieID: 40001) SCANNING movies: Au bout du bout du banc (1979) (movieID: 50001) SCANNING movies: Bats: Human Harvest (2007) (TV) (movieID: 60001) SCANNING movies: Billyboy (2008) (V) (movieID: 70001) SCANNING movies: Boy Wonder (2010) (movieID: 80001) SCANNING movies: Camomiles (2006) (movieID: 90001) EXECUTING "BEFORE_MOVIES_TODB:BEGIN TRANSACTION;"... EXECUTING "BEGIN TRANSACTION;"... DONE! * FLUSHING MoviesCache... Traceback (most recent call last): File "C:\Python26\Scripts\imdbpy2sql.py", line 5, in <module> pkg_resources.run_script('imdbpy==4.5.1', 'imdbpy2sql.py') File "C:\Python26\lib\site-packages\pkg_resources.py", line 489, in run_script self.require(requires)[0].run_script(script_name, ns) File "C:\Python26\lib\site-packages\pkg_resources.py", line 1207, in run_scrip t execfile(script_filename, namespace, namespace) File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 2911, in <module> run() File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 2747, in run readMovieList() File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 1460, in readMovieList mid = CACHE_MID.addUnique(title, yearData) File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 1068, in addUnique else: return self.add(key, miscData) File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 947, in add self[key] = c File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 857, in __setitem__ self.flush() File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 880, in flush self._toDB(quiet) File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 1052, in _toDB self._runCommand(l) File "c:\python26\lib\site-packages\imdbpy-4.5.1-py2.6-win32.egg\EGG-INFO\scri pts\imdbpy2sql.py", line 1056, in _runCommand CURS.executemany(self.sqlstr, self.converter(dataList)) sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a te xt_factory that can interpret 8-bit bytestrings (like text_factory = str). It is highly recommended that you instead just switch your application to Unicode str ings. comments ---------------- I naively tried changing the URI to: sqlite:///C:\test\imdb_db\db.db?text_factory=str That resulted in an unknown keyword argument error... ------------------------------------------------------------------------------ _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help