try turning on echo=True when you make the DBengine, it will show you
all the queries as well as their results sent to standard out.
its *possible* that something goes wrong with the toengine() call
with sqlite, try hardcoding your engines to a plain sqlite engine,
i.e. dont use a non-sqlite engine at all, and see if that fixes it.
On Nov 27, 2005, at 4:32 PM, Robert Leftwich wrote:
I was running my code on sqlite (out of curiosity as to its
performance and to make sure I'm not doing anything database
specific in my setup/coding) and found that it is not working at
all. The first issue is that the ResultProxy is failing to lookup a
column value by name or by column property. Having a look at the
returned ResultProxy for sqlite I see that its 'props' property has
names like 'foo.col1, foo.col2', where foo' is the table name and
yet the same object returned from postgres has 'col1, col2'.
Interestingly all the SQLAlchemy unit tests pass, so I'm wondering
if this is related to my using the toengine() approach to convert
from ansi to sqlite/postgres engines.
Anyone have any suggestions?
Robert
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through
log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Sqlalchemy-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
