[Sqlalchemy-users] Firebird does not raise an error reflecting non existing table

2006-10-06 Thread Lele Gaifax
The FB reflection code does not raise the appropriate error when the table does not exist. This is checked by a test, that clearly fails. The attached patch cures the problem. ciao, lele. Fri Oct 6 23:09:17 CEST 2006 [EMAIL PROTECTED] * Firebird reflection wasn't raising the proper NoSuchTa

Re: [Sqlalchemy-users] Problem with tables been aliased (Firebird)

2006-10-06 Thread Roger Demetrescu
Hi Lele !! You were faster than me... :) I tested your patch and it run fine here... Thanks !!! Roger On 10/6/06, Lele Gaifax <[EMAIL PROTECTED]> wrote: > Michael Bayer wrote: > > any dropping of "AS" for alisases has to occur locally within the > > firebird dialect; > > That's of course wha

Re: [Sqlalchemy-users] Problem with tables been aliased (Firebird)

2006-10-06 Thread Lele Gaifax
Michael Bayer wrote: any dropping of "AS" for alisases has to occur locally within the firebird dialect; That's of course what I meant. feel free to send a patch. I have no test instance of firebird here I'm attaching two patches, one that enables the test frameword for firebird, and one

Re: [Sqlalchemy-users] Problem with tables been aliased (Firebird)

2006-10-06 Thread Roger Demetrescu
Hi Ezio, I am not sure if I can switch firebird's version... My client has a system build with Delphi 7 & BDE .. and we would have to re-test all this system with Firebird 2... :( I took a quick look at SA source code. If I am not wrong, all I have to do is override "visit_alias" method in FBCom

Re: [Sqlalchemy-users] Problem with tables been aliased (Firebird)

2006-10-06 Thread Michael Bayer
any dropping of "AS" for alisases has to occur locally within the firebird dialect; most other databases require it. you can add an overridden "visit_alias()" method in firebird's FBCompiler (the base method is in ansisql.py) to achieve this. (feel free to send a patch. I have no test ins

Re: [Sqlalchemy-users] Problem with tables been aliased (Firebird)

2006-10-06 Thread Lele Gaifax
Ezio Vernacotola wrote: > A possible workaround is switch to firebird 2.0 now, is very close to > final release, largely backward compatible and accepts "AS" in table > aliasing Unfortunately it's not an easy switch, so I gently insist SA should drop the "AS" keyword usage, even from the column