[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Troy
It's not about case in the resultproxy, it's about case-insensitive for server-side compare, such as in the where clause and when ordering results. comparisonslike literal text injected into the SQL? why not use bind parameters ?there are cases where literal text should not be

[sqlalchemy] SQLAlchemy and Elixir at FOSDEM 2007

2007-02-19 Thread Gaetan de Menten
Just to let everyone who might be interested know, I'll be giving a talk about SQLAlchemy and Elixir at the FOSDEM 2007. It'll be in the python devroom. -- Gaëtan de Menten http://openhex.org --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Michael Bayer
On Feb 19, 2007, at 4:52 AM, Troy wrote: It's not just the literal text or the bind param. It is how the server compares character based data. In MySQL, MS-SQL, Sybase -- case does not matter. In Postgres, Oracle and DB2 it does. DB2 and Oracle (since version 10 I think) have some

[sqlalchemy] Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-19 Thread Matt Culbreth
Howdy Group, I'm playing out with a few things now and I wanted to see if anyone else has used SQLAlchemy in an asynchronous manner? For example, you could create a service which responded to asynchronous requests for data, and could be used by a web client, desktop client, other types of

[sqlalchemy] Re : [sqlalchemy] Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-19 Thread Stéphane Brault
I use sasync in production with twisted and I'm quite happy with it. My application reads and writes a lot and I haven't run into any major problem. Stéphane - Message d'origine De : Matt Culbreth [EMAIL PROTECTED] À : sqlalchemy sqlalchemy@googlegroups.com Envoyé le : Lundi, 19

[sqlalchemy] Re: Three questions from first usage

2007-02-19 Thread Michael Bayer
On Feb 19, 2007, at 12:16 AM, David Bolen wrote: 1. I have a simple add operation which does the basic object allocation, session.save() and session.flush(). The issue was when I tried to add an object with a SQL violation (duplicate value on unique column). No problems with the

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Troy
OK totally different issue. MySQL does have a case-sensitivity setting using COLLATE. not sure what MS-SQL has and we dont yet have sybase support. we've had people report the whole lower() issue in the past and im not sure that should be automatic within SA.You can just explicitly

[sqlalchemy] Re: Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-19 Thread Troy
We did a quick proof-of-concept with it and it appeared to work as advertised :) Troy On Feb 19, 10:11 am, Matt Culbreth [EMAIL PROTECTED] wrote: Howdy Group, I'm playing out with a few things now and I wanted to see if anyone else has used SQLAlchemy in an asynchronous manner? For

[sqlalchemy] Re: Getting list of referencing table

2007-02-19 Thread Troy
I believe this is what your looking for (from the sqlalchemy recipes section of the wiki) http://www.sqlalchemy.org/trac/wiki/UsageRecipes/DependentTables Troy On Feb 19, 12:11 am, Andreas Jung [EMAIL PROTECTED] wrote: Is there a way to get a list of tables or table names that reference a

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Michael Bayer
On Feb 19, 2:32 pm, Troy [EMAIL PROTECTED] wrote: Even though MySQL allows the setting of COLLATE, it does not support functional indexes, so if your code explicitly calls lower you technically now have code that will work for both MySQL and Postgres, but MySQL is going to take a big

[sqlalchemy] Re: An update and some questions

2007-02-19 Thread Paul Johnston
Hi, 4) I'm considering submitting a patch to make _CompoundClause.compare tell you if the clause has the same semantics as the comparison (at im curious how this function would work for more complex situations, i.e. with more operators, more levels of nesting, etc. without re-

[sqlalchemy] Re: An update and some questions

2007-02-19 Thread Michael Bayer
On Feb 19, 2007, at 3:39 PM, Paul Johnston wrote: Ok, the issue was noticed due to a unit test failure (engine.reflection.ReflectionTest.testcompositefk) where the test checks if the condition created by the join matches the condition it knows. The test was incorrectly failing because