hi.
Lets have a Person having .address having .country having .name.
How would give-me-persons-which-live-in France be expressed in SA
(sorry for my SQL ignorance)?
e.g. all-persons-for-which person.address.country.name == 'France'
thanks
svil
Lets have a Person having .address having .country having .name.
How would give-me-persons-which-live-in France be expressed in
SA (sorry for my SQL ignorance)?
e.g. all-persons-for-which person.address.country.name ==
'France'
how about
q = session.query(D)
q.select(q.join_via([address, country]) (Country.c.name ==
'france'))
or
q = SelectResults(session.query(D))
q.join_to(address).join_to(country).select(Country.c.name=='france')
im not down with shoving literal strings into **kwargs at all
Hey what's with the bitwise AND operator? Does that actually work to AND
together parts of WHERE clauses?
On 1/21/07, Michael Bayer [EMAIL PROTECTED] wrote:
how about
q = session.query(D)
q.select(q.join_via([address, country]) (Country.c.name ==
'france'))
or
q =
the concretes fail because concrete is not a completed feature at the
momentim not even looking at those yet.
the session.clear() should be done in all cases, the tests are
completely pointless without it since you are just re-displaying the
relationships you already constructed. so i made
yes, although its a little inconvenient because it takes a high
precedence in the order of operations (thus you have to put () around
all expressions)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy
the concretes fail because concrete is not a completed feature at
the momentim not even looking at those yet.
the session.clear() should be done in all cases, the tests are
completely pointless without it since you are just re-displaying
the relationships you already constructed. so i
I have tried adding max_allowed_packet=16M to my.ini under [mysqld] but
it didn't work.
As far as I have seen BLOB type is used when mapping PickleType to
MySQL. I would like to use LONGBLOB, so I did:
class MyPickle(PickleType):
impl = mysql.MSLongBlob
and Column('data',MyPickle())
in a
there is no MSLongBlob at the moment. there is an MSMediumBlob which
comes out as MEDIUMBLOB, mysql says they are 16 megs in size.
or try doing this:
class MSLongBlob(MSBinary):
def get_col_spec(self):
return LONGBLOB
On Jan 21, 2007, at 5:03 PM, milena wrote:
I have tried
creating non-dynamic forms of the failing tests, like 2 or 3
of them (i.e. one or two concretes, one sisters=True test), will
save me the trouble of going through this script and extracting
them myself.
here. The thing generates them now itself.
$python sa_ref_A_B_A_all.py relink
im playing with some code to do this automatically, but looking back at
sa_ref_A_B_A_all.py, change your primaryjoins to:
mapper_A/link1:
primaryjoin= table_A.c.link1_id==(Alink=='A' and (poly and Ajoin or
table_A) or table_B).c.id,
mapper_B/link2:
primaryjoin= table_B.c.link2_id==(Blink=='A'
11 matches
Mail list logo