* Davide Alberani <davide.alber...@gmail.com> [2011-04-23 13:23:18]:
> If it still fails:
> - check your postgres settings.
> - try using SQLite (just for a test) - see notes in README.sqldb
Hi,
I've just had a try using sqlite with fresh lists and on my Debian
system and I get this:
thomas@ikaite:~$ /tmp/imdbpy2sql.py -d /home/thomas/Desktop/imdb/lists -u
sqlite:///home/thomas/Desktop/imdb/imdb.db --sqlite-transactions
IMPORTING psyco... DONE!
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... SKIPPING: no data.
SAVING imdbID values for people... SKIPPING: no data.
SAVING imdbID values for characters... SKIPPING: no data.
SAVING imdbID values for companies... SKIPPING: no data.
DROPPING current database... DONE!
CREATING new tables... DONE!
# TIME dropping and recreating the database : 0min, 2sec (wall) 0min, 0sec
(user) 0min, 0sec (system)
SCANNING movies: !Women Art Revolution (2010) (movieID: 1)
SCANNING movies: A Child's Garden of Verses (1992) (TV) (movieID: 10001)
SCANNING movies: A Strict Affair... Lessons in Discipline and Obedience (1992)
(V) (movieID: 20001)
SCANNING movies: AIDS: What Everyone Needs to Know (1987) (movieID: 30001)
SCANNING movies: Amour (1922) (movieID: 40001)
SCANNING movies: Arktinen lumous (1997) (TV) (movieID: 50001)
SCANNING movies: Baby's Storytime (1989) (V) (movieID: 60001)
SCANNING movies: Bei jiu gao ge (1974) (movieID: 70001)
SCANNING movies: Black in the Ass 8 (2005) (V) (movieID: 80001)
SCANNING movies: Breaking In (1925) (movieID: 90001)
EXECUTING "BEFORE_MOVIES_TODB:BEGIN TRANSACTION;"...
EXECUTING "BEGIN TRANSACTION;"... DONE!
* FLUSHING MoviesCache...
Traceback (most recent call last):
File "/tmp/imdbpy2sql.py", line 2950, in <module>
run()
File "/tmp/imdbpy2sql.py", line 2786, in run
readMovieList()
File "/tmp/imdbpy2sql.py", line 1467, in readMovieList
mid = CACHE_MID.addUnique(title, yearData)
File "/tmp/imdbpy2sql.py", line 1073, in addUnique
else: return self.add(key, miscData)
File "/tmp/imdbpy2sql.py", line 950, in add
self[key] = c
File "/tmp/imdbpy2sql.py", line 860, in __setitem__
self.flush()
File "/tmp/imdbpy2sql.py", line 883, in flush
self._toDB(quiet)
File "/tmp/imdbpy2sql.py", line 1057, in _toDB
self._runCommand(l)
File "/tmp/imdbpy2sql.py", line 1061, in _runCommand
CURS.executemany(self.sqlstr, self.converter(dataList))
pysqlite2.dbapi2.ProgrammingError: You must not use 8-bit bytestrings unless
you use a text_factory that can interpret 8-bit bytestrings (like text_factory
= str). It is highly recommended that you instead just switch your application
to Unicode strings.
thomas@ikaite:~$
Regards
--
Tom
------------------------------------------------------------------------------
Fulfilling the Lean Software Promise
Lean software platforms are now widely adopted and the benefits have been
demonstrated beyond question. Learn why your peers are replacing JEE
containers with lightweight application servers - and what you can gain
from the move. http://p.sf.net/sfu/vmware-sfemails
_______________________________________________
Imdbpy-help mailing list
Imdbpy-help@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-help
