Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL

Oleg Deribas wrote: Hello, I'm trying to investigate possibility to use SQLAlchemy with Firebird SQL. And I've wrote this simple script following tutorial: - from sqlalchemy import * db =

[Sqlalchemy-users] debug print statement in default.py

Michael, would you please you remove the debug print statement (LAST INSERTED PARAMS) in line 197 of sqlalchemy/lib/sqlalchemy/engine/default.py? Thanks, Uwe Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology

Re: [Sqlalchemy-users] firebirdsql.py: global name 'sql' is not defined

. Uwe On Jul 3, 2006, at 9:47 AM, Uwe Grauer wrote: I started to use the firebird-module with svn-rev 1683. I got a NameError: global name 'sql' is not defined Could you please uncomment the statement 'import sqlalchemy.sql as sql' in firebirdsql.py? Thanks, Uwe Using Tomcat

[Sqlalchemy-users] firebirdsql.py: global name 'sql' is not defined

I started to use the firebird-module with svn-rev 1683. I got a NameError: global name 'sql' is not defined Could you please uncomment the statement 'import sqlalchemy.sql as sql' in firebirdsql.py? Thanks, Uwe Using Tomcat but need to do more? Need to support web services, security? Get stuff

Re: [Sqlalchemy-users] Constraints when defineing Metadata

Michael Bayer wrote: not currently. this can be added without too much complexity...just add a ticket and we'll try to milestone it for 0.3.0. On Jun 19, 2006, at 5:23 PM, Uwe Grauer wrote: I couldn't find documentation about check constraints for defining metadata. (something like col

[Sqlalchemy-users] Constraints when defineing Metadata

I couldn't find documentation about check constraints for defining metadata. (something like col in (1,2,3)) Does it exist somewhere? Thanks, Uwe ___ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net

Re: [Sqlalchemy-users] Uninterrupted Sequences

Koen Bok wrote: Hello, I have two questions concerning sequences. Whenever an INSERT fails and a ROLLBACK occurs, the sequence is skipped by one. What is the best way to prevent this? I could do a SELECT max(id) FROM table and reset the sequence with it by making a trigger on the table. But

Re: [Sqlalchemy-users] ILIKE function

Koen Bok wrote: The LIKE function in postgres is case sensitive (unlike other sql databases). Is there a way to use it, and keep database computability with other databases? Eg: not use it as a custom function, but in a user.c.name.like('koen') kind of way? Like should be case sensitive

Re: [Sqlalchemy-users] ILIKE function

Koen Bok wrote: Postgres had the ILIKE function, but is there a way to use it, while still keep compatibility with other databases? Oh, sorry. I thought that this was a typo. Never heard of ilike in SQL. Uwe On 30-mrt-2006, at 16:12, Uwe Grauer wrote: Koen Bok wrote: The LIKE function

[Sqlalchemy-users] view create-table script

I am a new user of Sqlalchemy. I want to integrate Firebird as a new engine. How can i print out the database create script? Would it be helpful to create a tool for sqlalchemy which prints out the generated sql? Thanks, Uwe --- This