Roger,
Please excuse the interrupt, but have you applied other fixes? I (and
others) can't event get SQLA to connect to
my Firebird v1.5.4 database running on SUSE Linux.
John
On 30 May, 19:47, "Roger Demetrescu" <[EMAIL PROTECTED]>
wrote:
> Michael, the patch did the trick...
>
> I was able to print the statement, execute it, and also do some
> inserts using ORM...
>
> Now the second part of my problem, which is not fixed yet... ;)
>
> here is the script (now using default value/expression):
>
> ================================
>
> from datetime import datetime
> from sqlalchemy import *
>
> db = create_engine("firebird://user:[EMAIL PROTECTED]//database.fdb")
>
> metadata = BoundMetaData(db)
>
> pessoa_table = Table('pessoa', metadata,
> Column('pes_id', Integer, primary_key=True),
> Column('pes_data', DateTime, default=func.current_timestamp()),
> Column('pes_nome', String(30)),
> Column('pes_sobrenome', String(30)),
> Column('pes_idade', Integer),
> Column('pes_idade', Integer))
>
> s = pessoa_table.select()
> u = pessoa_table.update()
> i = pessoa_table.insert()
>
> ================================
>
> Now my shell session :
>
> >>> i.execute(pes_id=111, pes_data=datetime.now())
>
> <sqlalchemy.engine.base.ResultProxy object at 0x018C0D50>
>
> >>> i.execute(pes_id=222)
>
> Traceback (most recent call last):
> File "<pyshell#11>", line 1, in <module>
> i.execute(pes_id=222)
> File "d:\sqlalchemy\lib\sqlalchemy\sql.py", line 1175, in execute
> return self.compile(engine=self.engine,
> parameters=compile_params).execute(*multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\sql.py", line 1064, in execute
> return e.execute_compiled(self, *multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 783, in
> execute_compiled
> return connection.execute_compiled(compiled, *multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 570, in
> execute_compiled
> context.pre_exec()
> File "d:\sqlalchemy\lib\sqlalchemy\engine\default.py", line 200, in pre_exec
> self._process_defaults()
> File "d:\sqlalchemy\lib\sqlalchemy\engine\default.py", line 303, in
> _process_defaults
> newid = drunner.get_column_default(c)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 1234, in
> get_column_default
> return column.default.accept_visitor(self)
> File "d:\sqlalchemy\lib\sqlalchemy\schema.py", line 807, in accept_visitor
> return visitor.visit_column_default(self)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 1275, in
> visit_column_default
> return self.exec_default_sql(default)
> File "d:\sqlalchemy\lib\sqlalchemy\databases\firebird.py", line 367,
> in exec_default_sql
> c = sql.select([default.arg],
> from_obj=["rdb$database"]).compile(engine=self.engine)
> AttributeError: 'FBDefaultRunner' object has no attribute 'engine'
>
> Now I'm going to explicitly insert a row with pes_data = NULL
> (should'nt that work ??):
>
> >>> i.execute(pes_id=333, pes_data=None)
>
> Traceback (most recent call last):
> File "<pyshell#12>", line 1, in <module>
> i.execute(pes_id=333, pes_data=None)
> File "d:\sqlalchemy\lib\sqlalchemy\sql.py", line 1175, in execute
> return self.compile(engine=self.engine,
> parameters=compile_params).execute(*multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\sql.py", line 1064, in execute
> return e.execute_compiled(self, *multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 783, in
> execute_compiled
> return connection.execute_compiled(compiled, *multiparams, **params)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 570, in
> execute_compiled
> context.pre_exec()
> File "d:\sqlalchemy\lib\sqlalchemy\engine\default.py", line 200, in pre_exec
> self._process_defaults()
> File "d:\sqlalchemy\lib\sqlalchemy\engine\default.py", line 303, in
> _process_defaults
> newid = drunner.get_column_default(c)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 1234, in
> get_column_default
> return column.default.accept_visitor(self)
> File "d:\sqlalchemy\lib\sqlalchemy\schema.py", line 807, in accept_visitor
> return visitor.visit_column_default(self)
> File "d:\sqlalchemy\lib\sqlalchemy\engine\base.py", line 1275, in
> visit_column_default
> return self.exec_default_sql(default)
> File "d:\sqlalchemy\lib\sqlalchemy\databases\firebird.py", line 367,
> in exec_default_sql
> c = sql.select([default.arg],
> from_obj=["rdb$database"]).compile(engine=self.engine)
> AttributeError: 'FBDefaultRunner' object has no attribute 'engine'
>
> Thanks Michael
>
> PS: I am in the process of upgrading a dedicated host running Firebird
> 1.5.... after it is finished, maybe we could talk about how you can
> use it to test firebird engine... (if you are interested, of
> course)...
>
> On 5/30/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> > hey roger -
>
> > the fix for that issue is trivial, however the code which it fixes is
> > doing something that should be done differently (that is, ensuring
> > that all pk columns are present in an INSERT statement). Since I
> > dont have FB here, can you try out the attached patch and see if it
> > works for you, not just for the "print i" part (that part works) but
> > for running some actual INSERT statements (and maybe the ORM) a
> > little bit as well ?
>
> > thanks
>
> > - mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
