I document here a funny interaction between IMDbPY, SQLite and SQLAlchemy; maybe someone will be able to help.
The problem ONLY shows up running the imdbpy2sql.py script with SQLite, SQLAlchemy and the --sqlite-transactions command line option (it executes a "BEGIN TRANSACTION" query before every set of data is inserted, and a "COMMIT" right after). No problems with SQLObject (even using --sqlite-transactions), or with SQLAlchemy removing --sqlite-transactions. The exception I get is: pysqlite2.dbapi2.OperationalError: SQL logic error or missing database To be fair I don't get it: it's caught and managed as if the data was too huge, and so it's splitted and resend to the database (some data ends up in the table, but I assume most of it is lost) - anyway, the problem exists and can be serious (if the data is lost). The SQL query is: INSERT INTO title (id, title, imdb_index, kind_id, production_year, phonetic_code, episode_of_id, season_nr, episode_nr, series_years) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) The data is a list of tuples like: (19091, 'Alone, Unarmed, and Unafraid', None, 1, '1968', 'A4565', None, None, None, None) And they seem ok - remember that in imdbpy2sql.py the query is executed through the executemany method of a cursor object (and so they should not depend on SQLObject or SQLAlchemy). My question: what can be wrong in a query executed between a BEGIN TRANSACTION/COMMIT pair, using a cursors extracted from a connection to a SQLite db, made with SQLAlchemy? Any crazy ideas? My config: - SQLAlchemy from SVN - sqlite 3.3.8 -- Davide Alberani <[EMAIL PROTECTED]> [PGP KeyID: 0x465BFD47] http://erlug.linux.it/~da/ ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Imdbpy-devel mailing list Imdbpy-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-devel
