of the (correct) first one, but it
works ! Or is it two errors cancelling each other ?
Y.Chaouche
--- On *Thu, 10/14/10, Thadeus Burgess thade...@thadeusb.com* wrote:
From: Thadeus Burgess thade...@thadeusb.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
...@thadeusb.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy@googlegroups.com
Date: Thursday, October 14, 2010, 8:42 AM
http://www.sqlalchemy.org/docs/reference/orm/query.html#sqlalchemy.orm.join
isouter = True
--
Thadeus
On Thu, Oct 14, 2010 at 10:26 AM
) ?
I don't think you'd have the same results (join order matters).
Y.Chaouche
--- On Wed, 10/20/10, Thadeus Burgess thade...@thadeusb.com wrote:
From: Thadeus Burgess thade...@thadeusb.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy
?
Y.Chaouche
--- On Thu, 10/14/10, Thadeus Burgess thade...@thadeusb.com wrote:
From: Thadeus Burgess thade...@thadeusb.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy@googlegroups.com
Date: Thursday, October 14, 2010, 8:42 AM
http://www.sqlalchemy.org/docs
...@yahoo.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy@googlegroups.com
Date: Wednesday, October 13, 2010, 5:25 AM
Thank you Thadeus, I believe
Face.query.filter(filter_cond).outerjoin(join_clause).all() does a full
outerjoin, or is there another way to do
...@yahoo.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy@googlegroups.com
Date: Wednesday, October 13, 2010, 5:25 AM
Thank you Thadeus, I believe
Face.query.filter(filter_cond).outerjoin(join_clause).all() does a full
outerjoin, or is there another way to do
(it should return faces with no bookings
at all but it doesen't).
Thanks for any help.
Y.Chaouche
--- On *Wed, 10/13/10, chaouche yacine yacinechaou...@yahoo.com* wrote:
From: chaouche yacine yacinechaou...@yahoo.com
Subject: Re: [sqlalchemy] Checking the availablity of a booked Item
For outer joins you need a where clause on the joined tables.
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
Using a full outer join should return the expected results.
--
Thadeus
On Tue, Oct 12, 2010 at 1:41 PM, chaouche yacine
yacinechaou...@yahoo.comwrote:
: [sqlalchemy] Checking the availablity of a booked Item
To: sqlalchemy@googlegroups.com
Date: Wednesday, October 13, 2010, 12:04 AM
For outer joins you need a where clause on the joined tables.
http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html
Using a full outer join
Hello,
Here's my simple model (For simplification, consider Face as a Billboard) :
+-+ +---+ +--+
|Face |.. |Campaign | ...|TimePeriod|
+-+ . +---+ . +--+
|code | . |time_period| |start_time|
+-+ .
10 matches
Mail list logo