at its most simplistic level, IN is just a bunch of X=Y joined
together via OR. Can that approach work here ? (seems like it would
be the best way considering its polymorphic scalar elements being
compared). At a higher level, seems like you'd want to group elements
of common types
Marc -
is it the case that mxODBC only accepts DSNs and not TCP hosts as an
argument, but PyODBC accepts both ?
On May 27, 2008, at 9:10 AM, M.-A. Lemburg wrote:
On 2008-04-23 15:04, Michael Bayer wrote:
On Apr 23, 2008, at 8:07 AM, M.-A. Lemburg wrote:
The DSN style setup fits in
Hi Michael,
Thank you for the quick response. I had thought about using a
straightforward OR statement - are you suggesting that this would form
the body of the in_() method on the Comparator or were you referring
more to just compiling the OR statements in the base query?
Also, what is the
My previous description was a bit simplistic. Turns out the problem
only occurs when a join is involved.
See the following code:
###
from sqlalchemy import *
from sqlalchemy import orm
class One(object): pass
class Many(object): pass
sm =
On May 26, 5:09 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On May 26, 2008, at 6:20 PM, Waldemar Osuch wrote:
Reading the docs for arraysize, its not clear if this only applies to
fetchone() and a non-arg fetchmany(), or to all fetches (I'm hoping
you have better detail on this.). If
On May 27, 2008, at 3:11 PM, Martin Pengelly-Phillips wrote:
Hi Michael,
Thank you for the quick response. I had thought about using a
straightforward OR statement - are you suggesting that this would form
the body of the in_() method on the Comparator or were you referring
more to just
On May 27, 2008, at 3:21 PM, Waldemar Osuch wrote:
Quote:
Up to this point the default arraysize is 1 meaning that a single row
is internally fetched at a time. This has nothing to do with
fetchone(), fetchmany() or fetchall(). Regardless of which of those
methods is used, internally
i am trying to generate an or_ clauselist and was wondering if i could
do so with a list comprehension, below is a small example of what i
first tried:
status = [1,2,3]
or_([users.c.status_id == item for item in status])
any ideas or tips would be great.
thanks,
Matt
On Tuesday 27 May 2008 23:37:20 mg wrote:
i am trying to generate an or_ clauselist and was wondering if i
could do so with a list comprehension, below is a small example of
what i first tried:
status = [1,2,3]
or_([users.c.status_id == item for item in status])
any ideas or tips would be
you could use the in_ for this without looping over the list
eg:-
or_(users.c.status_id.in_(status))
On Tue, May 27, 2008 at 4:30 PM, [EMAIL PROTECTED] wrote:
On Tuesday 27 May 2008 23:37:20 mg wrote:
i am trying to generate an or_ clauselist and was wondering if i
could do so with a list
That makes sense - thanks again.
Martin
On May 27, 9:09 pm, Michael Bayer [EMAIL PROTECTED] wrote:
On May 27, 2008, at 3:11 PM, Martin Pengelly-Phillips wrote:
Hi Michael,
Thank you for the quick response. I had thought about using a
straightforward OR statement - are you
Hey, i did a test included below with this output:
$ python cxotest.py
Setting arraysize to 1 before execution yields 25.8921508181
Setting arraysize to 500 before execution yields 0.26524348765
Setting arraysize to 1 after execution yields 25.8829982582
Setting arraysize to 500 after execution
On May 27, 2008, at 5:35 PM, TP wrote:
From reading the docs, it sounds like calling .close() on a session
implicitly does a .rollback():
When the Session is closed, it remains attached, but clears all of
its contents and releases any ongoing transactional resources,
including rolling
So, I think i'll probably implement the patch I posted earlier and
actually default arraysize to 50, although I have a feeling it might
mess around with some of the BLOB-oriented functionality (since BLOBs
must be fetched at the point of receiving the row, else the cursor
moves on)..if
We're using SA 0.4.4. We're creating non-threadlocal sessions that are
bound to an engine at session factory creation time. Any ideas for why
even after closing one session and creating a new session with the
session factory that we're seeing old data? If we do an explicit
commit or rollback,
15 matches
Mail list logo