I replied to your trac ticket regarding this, this particular issue is
fixed in r4175 but you're likely to have more problems with the
tutorial combined with informix...
On Feb 17, 2008, at 5:26 AM, Bernd Zimmermann wrote:
> I am new to Sqlalchemy and started to check it with the tutorial.
> The database I have to use is Informix (10.3). But with that database
> I get the
> "TypeError: __init__() got multiple values for keyword argument
> 'column_keys'"
> Exception Traceback below. Using Postgres it runs fine.
>
> Any idea for a work-around or fix?
> Thanks,
> Bernd
>
> ----------- Here is what I copied from the tutorial so far
> ----------------------
>
> import sqlalchemy
> from sqlalchemy import create_engine
>
> #no Exception with this engine
> #engine =
> create_engine('postgres://bernd:[EMAIL PROTECTED]/testdb',echo=True)
>
> engine =
> create_engine('informix://bernd:[EMAIL PROTECTED]/testdb',echo=True)
>
> from sqlalchemy import Table, Column, Integer, String, MetaData,
> ForeignKey
> metadata = MetaData()
> users_table = Table('users', metadata,
> Column('id', Integer, primary_key=True),
> Column('name', String(40)),
> Column('fullname', String(100)),
> Column('password', String(15))
> )
> metadata.create_all(engine)
> class User(object):
> def __init__(self, name, fullname, password):
> self.name = name
> self.fullname = fullname
> self.password = password
>
> def __repr__(self):
> return "<User('%s','%s', '%s')>" % (self.name, self.fullname,
> self.password)
> from sqlalchemy.orm import mapper
> mapper(User, users_table)
> ed_user = User('ed', 'Ed Jones', 'edspassword')
> from sqlalchemy.orm import sessionmaker
> Session = sessionmaker(bind=engine, autoflush=True,
> transactional=True)
> session = Session()
> session.save(ed_user)
> session.commit()
>
>
> ------------- Exception thrown when Informix is used
> -----------------------------------
>
> Traceback (most recent call last):
> File "tutorial.py", line 43, in <module>
> session.commit()
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\session.py",
> line 544, in commit
> self.transaction.commit()
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\session.py",
> line 250, in commit
> self._prepare_impl()
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\session.py",
> line 234, in _prepare_impl
> self.session.flush()
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\session.py",
> line 764, in flush
> self.uow.flush(self, objects)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\unitofwork.py",
> line 215, in flush
> flush_context.execute()
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\unitofwork.py",
> line 437, in execute
> UOWExecutor().execute(self, tasks)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\unitofwork.py",
> line 927, in execute
> self.execute_save_steps(trans, task)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\unitofwork.py",
> line 942, in execute_save_steps
> self.save_objects(trans, task)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\unitofwork.py",
> line 933, in save_objects
> task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \orm\mapper.py",
> line 1106, in _save_obj
> c = connection.execute(statement.values(value_params), params)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \engine\base.py",
> line 846, in execute
> return Connection.executors[c](self, object, multiparams, params)
> File
> "c:\python25\lib\site-packages\SQLAlchemy-0.4.3-py2.5.egg\sqlalchemy
> \engine\base.py",
> line 897, in execute_clauseelement
> return self._execute_compiled(elem.compile(dialect=self.dialect,
> column_keys=keys, inline=len(params) > 1), distilled_params=params)
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \sql\expression.py",
> line 1043, in compile
> compiler = dialect.statement_compiler(dialect, self,
> column_keys=column_keys, inline=inline)
> File
> "C:\Python25\lib\site-packages\sqlalchemy-0.4.3-py2.5.egg\sqlalchemy
> \databases\informix.py",
> line 374, in __init__
> compiler.DefaultCompiler.__init__( self , dialect , statement ,
> parameters , **kwargs )
> TypeError: __init__() got multiple values for keyword argument
> 'column_keys'
>
> >
> begin:vcard
> fn:Bernd Zimmermann
> n:Zimmermann;Bernd
> org:it-consulting
> adr:;;Alter Postweg 104 D;Seevetal - Horst;;21220;Germany
> email;internet:[EMAIL PROTECTED]
> tel;work:+49 4105 668033
> tel;fax:+49 4105 668032
> tel;cell:+49 170 4735471
> x-mozilla-html:FALSE
> url:www.zedv.de
> version:2.1
> end:vcard
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
