On May 13, Dustin Wyatt <dustin.wy...@gmail.com> wrote: Hi!
> imdbpy2sql.py -d C:\test\imdb_db\text_files -u > sqlite:///C:\test\imdb_db\db.db --sqlite-transactions -o sqlalchemy I think it's a better idea to use the UNIX path separator (/), even on Windows. See the 'Microsoft Windows paths' section in the README.sqldb file of the documentation (one of these days I'll fix every troubles with the Windows' path separator...) > 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. I see - that's a new feature introduced in the SQLite module shipped with Python 2.6. Thank you very much for the report: I wasn't aware of it: I've already fixed it in the Mercurial repository: http://imdbpy.sf.net/?page=download#hg By they way, I keep noticing other problems with SQLite and SQLAlchemy. I see a 'cannot commit - no transaction is active' error trying to executing the 'COMMIT;' statement (--sqlite-transactions option). The script goes on but... who know what's going on. Anyway, thank you again for the bug report: I've added your name to the credits. Bye! -- Davide Alberani <davide.alber...@gmail.com> [GPG KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help