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
[email protected]
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
