Re: Weird join conditions

2011-07-02 Thread peroksid
, which go in ON() in FROM clause. Alexander. On 2 июл, 14:53, Gianluca Sforna wrote: > On Thu, Jun 30, 2011 at 5:19 PM, peroksid > wrote: > > > I need to have for the "ON" expression slighlty more complex > > expression, something like > > "left_tabl

Re: Weird join conditions

2011-07-02 Thread peroksid
I do not really get what you mean under reusable raw query factory. But object manager's method raw() returns RawQueryManager, which is pretty useless. When you first mentioned raw SQL I considered it and made method I write to get SQL query after all join() and extra() calls were done and return r

Re: Weird join conditions

2011-07-01 Thread peroksid
laces join condition with required one in one of data chunks. How do you think, will there be problems? On 1 июл, 01:35, Michal Petrucha wrote: > On Thu, Jun 30, 2011 at 02:13:05PM -0700, peroksid wrote: > > Thank you, Michal, > > > Unfortunately, I need join condition, not

Re: Weird join conditions

2011-07-01 Thread peroksid
On 1 июл, 01:35, Michal Petrucha wrote: > On Thu, Jun 30, 2011 at 02:13:05PM -0700, peroksid wrote: > > Thank you, Michal, > > > Unfortunately, I need join condition, not a WHERE clause, which can be > > easily extended with extra() method arguments. > > It is no

Re: Weird join conditions

2011-06-30 Thread peroksid
ite keys (great respect). Could you please hint me about this "assembler" method I babble about? Alexander. On 30 июн, 23:55, Michal Petrucha wrote: > On Thu, Jun 30, 2011 at 08:19:36AM -0700, peroksid wrote: > > Hi. > > > Queryset attribute query has method join() which

Weird join conditions

2011-06-30 Thread peroksid
Hi. Queryset attribute query has method join() which allows to explicitly make JOINs. First argument passed to this method is a tuple of left table, right table, left column and right column, and rest of arguments define if we have LEFT OUTER or INNER join. Arguments from the tuple are used to cre