[sqlalchemy] Sane rowcount

2007-12-19 Thread Lele Gaifax
Hi all, I'm trying to better understand the rowcount issue, starting from ticket:370. Currently Firebird has both 'supports_sane_rowcount' and 'supports_sane_multi_rowcount' set to False. I do not exactly get what sane means there... seeing the result of my tests (below). Maybe something

[sqlalchemy] Re: save_or_update and composit Primary Keys... MSSQL / pyodbc issue ?

2007-12-19 Thread Smoke
On 19 Dic, 01:37, Rick Morrison [EMAIL PROTECTED] wrote: Same here on pymssql. I tried it with 'start' as the only PK, and with both 'identifier' and 'start' as PK. Both work fine. Are you sure your in-database tabledef matches your declared schema? I've attached a script that works here.

[sqlalchemy] Syntax for IN (1,2,3)

2007-12-19 Thread Marcin Kasperski
Maybe I missed something but can't find... Does there exist SQLExpression syntax for WHERE column IN (1,2,3,4) ? -- -- | Marcin Kasperski | Software is not released, | http://mekk.waw.pl | it is allowed to escape. |

[sqlalchemy] Re: Syntax for IN (1,2,3)

2007-12-19 Thread Bertrand Croq
Le mercredi 19 décembre 2007 12:06, Marcin Kasperski a écrit : Maybe I missed something but can't find... Does there exist SQLExpression syntax for WHERE column IN (1,2,3,4) column.in_(1,2,3,4) -- Bertrand Croq ___ Net-ng

[sqlalchemy] Re: chunks of blob data...

2007-12-19 Thread Chris Withers
Michael Bayer wrote: cx_oracle's blob object is able to stream out blobs like filehandles, since thats how OCI wants it to be done. Im not sure if it only allows sequential access or access to any range. As far as other DBAPIs like psycopg2 and MySQLDB, you'd have to dig into the

[sqlalchemy] Re: Syntax for IN (1,2,3)

2007-12-19 Thread Rick Morrison
I believe that as of 0.4.0, that's now: column.in_([1,2,3,4]) On Dec 19, 2007 6:23 AM, Bertrand Croq [EMAIL PROTECTED] wrote: Le mercredi 19 décembre 2007 12:06, Marcin Kasperski a écrit: Maybe I missed something but can't find... Does there exist SQLExpression syntax for

[sqlalchemy] Re: save_or_update and composit Primary Keys... MSSQL / pyodbc issue ?

2007-12-19 Thread Rick Morrison
OK, I checked to make sure the updates were being fired (and from the looks of the log, they are). But I think I see that the lack of update executions hasn't been the problem all along, but rather that those updates are not finding their row... never checked that part. I'm offsite right now and

[sqlalchemy] Virtual column-attribute

2007-12-19 Thread maxi
Hi, I hope sombody can help me whit this. I've the next table, for instance: customer = Table('customer', metadata, Column('id', Integer, primery_key=True), Column('name', String(50), nullable=False) ) andthe class class Customer(object): pass and.. the mapper

[sqlalchemy] Re: Virtual column-attribute

2007-12-19 Thread Bertrand Croq
Le mercredi 19 décembre 2007 15:32, maxi a écrit : Then, I do a simple query: cust = session.query(Customer).get(1) but, when I want use cust.selected = True An exception ocurr, the cust object have not 'selected' attribute __init__ is not called when objects are fetched from the

[sqlalchemy] Re: Sane rowcount

2007-12-19 Thread Michael Bayer
On Dec 19, 2007, at 4:19 AM, Lele Gaifax wrote: Can you point me to a more correct way of testing the expected behaviour of sane_multi_rowcount? And given new results on sane_rowcount, is it right turning it to True on Firebird too? sane_multi_rowcount is specifically for an executemany,

[sqlalchemy] Implementing ranking

2007-12-19 Thread voltron
Could someone tell me how to simulate the rank() function? I am using PostgreSQL which does not have this a s a native function. Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to

[sqlalchemy] Caching

2007-12-19 Thread Anton V. Belyaev
Hello, Several people already wrote something about memcached + SqlAlchemy. Remember, Mike Nelson wrote a mapper extention, it is available at: http://www.ajaxlive.com/repo/mcmapper.py http://www.ajaxlive.com/repo/mcache.py I've rewritten it a bit to fit 0.4 release of SA. Any response and

[sqlalchemy] Re: Sane rowcount

2007-12-19 Thread Lele Gaifax
On Wed, 19 Dec 2007 10:21:15 -0500 Michael Bayer [EMAIL PROTECTED] wrote: sane_rowcount is set to False on FB probably because someones version of FB did not support it correctly. it might be worth tracking it down in svn blame to see why it was changed. I did that already, having changed

[sqlalchemy] association object to associate table to itself

2007-12-19 Thread Brett
Hello, I'm trying to create an association between two objects of the same type. For example I have table A and then I have an association table that has two foreign keys to table A. What I'm looking for is to be able to say: one_typeA.append(two_typeA) but the association_proxy seems only

[sqlalchemy] Re: Sane rowcount

2007-12-19 Thread Roger Demetrescu
Hi Lele - On Dec 19, 2007 9:08 PM, Lele Gaifax [EMAIL PROTECTED] wrote: On Wed, 19 Dec 2007 10:21:15 -0500 Michael Bayer [EMAIL PROTECTED] wrote: sane_rowcount is set to False on FB probably because someones version of FB did not support it correctly. it might be worth tracking it

[sqlalchemy] Re: Sane rowcount

2007-12-19 Thread Lele Gaifax
On Wed, 19 Dec 2007 22:00:54 -0300 Roger Demetrescu [EMAIL PROTECTED] wrote: At that time, the test script was also failing with 0.4 (unreleased), and turning off `supports_sane_multi_rowcount` fixed it. Yes, in fact. As said, `supports_sane_multi_rowcount` should stay to False, while I'm

[sqlalchemy] Re: Caching

2007-12-19 Thread Michael Bayer
On Dec 19, 2007, at 5:19 PM, Anton V. Belyaev wrote: Hello, Several people already wrote something about memcached + SqlAlchemy. Remember, Mike Nelson wrote a mapper extention, it is available at: http://www.ajaxlive.com/repo/mcmapper.py http://www.ajaxlive.com/repo/mcache.py I've

[sqlalchemy] Re: association object to associate table to itself

2007-12-19 Thread Michael Bayer
two tricks here - set up SpeciesSynonym as: class SpeciesSynonym(object): def __init__(self, species): self.synonym = species that it wasnt raising an exception for no constructor is a bug - ticket #908 added. The other thing that helps here is to set up your bidirectional

[sqlalchemy] Conventions for creating SQL alchemy apps

2007-12-19 Thread Morgan
Hi Guys, This may be a stupid question so flame away I don't care, but I have been wondering. Is there a better way to layout your SQL alchemy files that my random method? Does anyone have a convention that works well for them. I'm only asking this because I cannot decide how I want to lay

[sqlalchemy] 0.4 deprecation warnings, what is the new get_by/select_by?

2007-12-19 Thread iain duncan
Sorry if this seems a stupid question, but I thought that Mike had said that in sa0.4, if you used session_context that this User.query.get_by(name='john') was the replacement for the old assign mapper convenience call. But I'm getting deprecation warnings. What should I be doing instead of