Looking at the doc for 0.4 I see that I should be able to do this:
result = engine.execute("select username from users")
... do something with the result
result.close()
But I am getting the following exception. Note that I am using Firebird
SQL and the firebird.py is the one patched by Roger.
Am I doing something wrong or is this not supported in 0.4?
BTW, I would like to use this within a custom type ("class
MyType(types.TypeDecorator):" to do the I18N translation similar to what
Karsten suggested in another thread.
Best regards
Werner
Traceback (most recent call last):
File "sai18Test.py", line 15, in <module>
for entry in session.query(model.Test_i18n):
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line
619, in __iter__
return self._execute_and_instances(context)
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line
624, in _execute_and_instances
return iter(self.instances(result, querycontext=querycontext))
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\query.py", line
680, in instances
self.select_mapper._instance(context, row, result)
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\mapper.py",
line 1436, in _instance
self.populate_instance(context, instance, row, **flags)
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\mapper.py",
line 1517, in populate_instance
p(instance, row, ispostselect=ispostselect, isnew=isnew, **flags)
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\orm\strategies.py",
line 77, in new_execute
instance.__dict__[self.key] = row[self.columns[0]]
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\engine\base.py",
line 1580, in __getitem__
return self.__parent._get_col(self.__row, key)
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\engine\base.py",
line 1386, in _get_col
return rec[1](row[rec[2]])
File "c:\downloaded
software\python\sqlalchemy-0.4.0beta6\lib\sqlalchemy\types.py", line 46,
in process
return self.convert_result_value(value, dialect)
File "C:\Dev\BoaTest04\sqlalchemy\modelTest.py", line 16, in
convert_result_value
result = engine.execute("select output1 from t(?, ?)", ('some new
text here ddd', 'wbruhin'))
AttributeError: 'FBDialect' object has no attribute 'execute'
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
