First of all: is anyone out there who has successfully used
IMDbPY with DB2 or - at least - knows how to use the ibm_db module?
On Nov 13, Joachim Selke <[EMAIL PROTECTED]> wrote:
> Here are the results:
[...]
> > cursor.execute('INSERT INTO kind_type (kind) VALUES (?)', ['movie'])
> No error, but the table is still empty.
> > cursor.execute('INSERT INTO kind_type (kind) VALUES (?)', ('movie',))
> No error, but the table is still empty.
>
> Hm, what to do next? Upgrade to SQLAlchemy 5?
It's a thing to try, at least.
In the above tests we weren't using SQLAlchemy, but directory the
SQL query it built.
For some reason, the query seems to be wrong.
It can be a problem:
- in your database (some settings about unicode/collations?).
- in the ibm_db module.
- of the ibm_db_sa adapter.
- of SQLAlchemy, in case it built a wrong query.
Right now I tend to exclude an IMDbPY problem, but who knows...
The first thing, is to understand how you can insert a valid set of
values in the DB2 database with the ibm_db module (how is the
documentation?): maybe we're calling cursor.execute with the wrong
style/paramters, or maybe you set up the connection to the database
with the wrong parameters (can you read data from an existing database?);
after that we should know if SQLAlchemy is creating a correct query.
Anyway, a test with SQLAlchemy 0.5 looks like a good idea, now.
Thank you very much!
--
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
