On 20 Okt., 17:11, "Michael Bayer" <[email protected]> wrote:
> goschtl wrote:
>
> > Hello SQLAlchemy,
>
> > i am new to sqlalchemy, i currently work on project which
> > needs sqlalchemy/informix integration.
>
> > Maybe someone can have a look on this:
>
> > >>> session = Session()
> > >>> session
> > <sqlalchemy.orm.session.Session object at ...>
>
> > >>> from sqlalchemy import MetaData
> > >>> metadata = MetaData(session.connection())
> > >>> metadata
> > MetaData(<sqlalchemy.engine.base.Connection object at ...
>
> > >>> from sqlalchemy import Table
> > >>> users = Table('ln_passwd', metadata, autoload=True)
>
> > >>> print users.c.az == "022301429"
> > ln_passwd.az = 1 <--- i guess this should be ln_passwd.az
> > = ?
>
> > >>> print users.insert(az='022301429')
> > INSERT INTO ln_passwd (az, az_key, passwort, berecht, versand,
> > e_m_dat, e_m_zeit, sb_id, ser_nr, s_flag, upd_count) VALUES (1, 2, 3,
> > 4, 5, 6, 7, 8, 9, 10, 11)
>
> you mean to say:
>
> insert().values(az='022301429')
Hi Michael,
you are right this seems to work... thanks for that?
>
> also the informix dialect to my knowledge has never been used in recent
> versions of SQLAlchemy, so your results may vary. at the moment its
> entirely unsupported since it lacks a maintainer.
>
>
Any idae where i can look for this error:
>>> print users.c.az == "022301429"
ln_passwd.az = 1
Do you think thats a problem of the driver or the
dialect in sqlalchemy itself?
Thanks for your help!
Christian
>
> > So it seems that anything with the parameters goes wrong. I have no
> > idea where i can look for this problem.
>
> > If you need more information please let me know?
>
> > sqlalchemy 0.5.6
> > informixdb 2.5
>
> > Christian
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
