Ah Thanks! A bit of a hack but certainly works for now. Thanks for
helping out. Really appreciate it!
Jimmy Yuen Ho Wong
On 10/1/12 3:31 AM, Michael Bayer wrote:
> On Jan 9, 2012, at 11:19 AM, Michael Bayer wrote:
>
>> The first thing I note here is, if I were doing a model li
On 10/1/12 12:19 AM, Michael Bayer wrote:
> A common theme in SQLAlchemy is that, despite all the flak we get for being
> "complicated", SQLAlchemy is actually very simple. It has a handful of
> constructs which seek to do exactly the same thing in exactly the same way,
> as consistently as po
Here's a list of pathological test cases that confuses the hell out of SA
while trying to eager load more than 1 collections which are mapped to the
same table using single table inheritance. In short, only joinedload*()
appears to work out of all the eager loading methods. This pretty much
mea
ot;,
> some_complicated_geoalchemy_function_call(columns...))
>
> q = session.query(Product, Merchant.location, d)\
> .join(Merchant, Product.merchant_id == Merchant.id)\
> .filter(Product.numinstock > 0)\
> .options(subqueryload_all(Product.ori
yer wrote:
> On Jan 8, 2012, at 2:47 PM, Yuen Ho Wong wrote:
>
>
>
>
>
>
>
>
>
> > Hi,
>
> > I have a rather complicated problem and I was wondering if you guys
> > could help.
>
> > So I have a query, session.query(Product, Merchant, d)
BTW, aliased() and alias() don't work on a label() either. I tried
passing the label object straight into the order_by() as well to no
avail. I'm all out of ideas.
On Jan 9, 3:47 am, Yuen Ho Wong wrote:
> Hi,
>
> I have a rather complicated problem and I was wondering if yo
Hi,
I have a rather complicated problem and I was wondering if you guys
could help.
So I have a query, session.query(Product, Merchant, d), where Product
is 1-to-many with Merchant, and d is the distance from some lat long.
d is actually a sqlalchemy.sql.label() of some complicated GeoAlchemy
fun
Replace the double quotes around the "%s" with single quotes seems to
have solved the problem with either default SQL MODE or ANSI_QUOTES
set.
Thanks for the helping!
On Jun 7, 3:25 am, Yuen Ho Wong wrote:
> Ah it seems that this bug only happens with sql-mode = ANSI set in
&
Ah it seems that this bug only happens with sql-mode = ANSI set in
my.cnf. This doesn't seem to be an issue with the mysql-python driver
tho.
On Jun 7, 2:57 am, Michael Bayer wrote:
> On Jun 6, 2011, at 2:23 PM, Yuen Ho Wong wrote:
>
>
>
>
>
> > I'm testin
I'm testing this on SQLAlchemy 0.7.1, oursql 0.9.2, MySQL 5.5.13 on
Mac OS X 10.6.7
Here's my test script:
from sqlalchemy import create_engine, Column, Integer, Unicode
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import scoped_session, sessionmaker
Base = declar
(),
self.mapper.c.date_of_birth) / 365)
def operate(self, op, *args, **kwargs):
return op(self.__clause_element__(), *args, **kwargs)
Thanks a lot!
On Sep 27, 1:14 pm, Michael Bayer wrote:
> On Sep 27, 2009, at 12:49 PM, Yuen Ho Wong wrote:
>
>
>
>
>
>
>
> > So I have th
So I have this following code:
class User(Base):
class AgeComparator(PropComparator):
def __lt__(self, other):
pass
def __gt__(self, other):
pass
def __eq__(self, other):
pass
def __ne__(self, other):
return not (self == other)
12 matches
Mail list logo