Bug? - doctrine-user | Google Groups

Message from discussion Bug?

Alex

More options 14 May, 20:14

From: Alex <outroa...@gmail.com>

Date: Wed, 14 May 2008 16:14:58 -0300

Local: Wed 14 May 2008 20:14

Subject: Re: [doctrine-user] Re: Bug?

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

$query = Doctrine_Query::create()->select('c.*, u.*,
vc.*')->from('CommentItem c')->leftJoin('c.sfGuardUser u');
if ($this->getUser()->isAuthenticated())
{
$query->leftJoin('c.VoteComment vc WITH vc.user_id =
'.$this->getUser()->getId());
}

Gives me

SELECT c.id AS c__id, c.user_id AS c__user_id, c.body AS c__body,
c.votes_for_cache AS c__votes_for_cache, c.votes_against_cache AS
c__votes_against_cache, c.created_at AS c__created_at, c.updated_at AS
c__updated_at, c.root_id AS c__root_id, c.lft AS c__lft, c.rgt AS c__rgt,
c.level AS c__level, s.id AS s__id, s.username AS s__username, s.algorithm
AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.last_login
AS s__last_login, s.is_active AS s__is_active, s.is_super_admin AS
s__is_super_admin, s.created_at AS s__created_at, s.updated_at AS
s__updated_at, v.id AS v__id, v.user_id AS v__user_id, v.vote_type_id AS
v__vote_type_id, v.type AS v__type, v.item_id AS v__item_id, v.comment_id AS
v__comment_id, v.created_at AS v__created_at FROM comments c LEFT JOIN
sf_guard_user s ON c.user_id = s.id LEFT JOIN votes v ON c.id = v.comment_id
AND v.user_id = 1 WHERE (v.type = 2 OR v.type IS NULL)

$query = Doctrine_Query::create()->from('CommentItem
c')->leftJoin('c.sfGuardUser u');
if ($this->getUser()->isAuthenticated())
{
$query->leftJoin('c.VoteComment vc WITH vc.user_id =
'.$this->getUser()->getId());
}

Gives me

SELECT c.id AS c__id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level,
c.root_id AS c__root_id FROM comments c LEFT JOIN sf_guard_user s ON
c.user_id = s.id LEFT JOIN votes v ON c.id = v.comment_id AND v.user_id = 1
WHERE (v.type = 2 OR v.type IS NULL)

I'm using $treeObject->setBaseQuery($query);
echo $treeObject->getBaseQuery()->getSqlQuery();

Could the treeObject be altering default Doctrine behavior?

On Wed, May 14, 2008 at 4:09 PM, Jonathan Wage <jonw...@gmail.com> wrote:
> Hmm. Are you sure about that? If you don't specify a select() in 1.0 it
> will default to select all columns across all tables.

> - Jon

> On Wed, May 14, 2008 at 1:24 PM, Alex <outroa...@gmail.com> wrote:

>> One more question. When must ->select() be added to a Doctrine_Query
>> object? I've noticed that if I select from more than one table Doctrine
>> doesn't select columns from the joined tables. If I have ->from('Table t') ,
>> it selects t.* . But if I add ->innerJoin('Table2 t2'), it doesn't select
>> t2.*.

>> Couldn't find anything about it in the manual.

>> Thanks for your help Jon!

>> - alex

>> On Wed, May 14, 2008 at 3:18 PM, Jonathan Wage <jonw...@gmail.com> wrote:

>>> It is good practice. You should always use them so that all values are
>>> prepared. In this case it doesn't matter as much since the value isn't
>>> necessarily user input.

>>> - Jon

>>> On Wed, May 14, 2008 at 1:15 PM, Alex <outroa...@gmail.com> wrote:

>>>> Bingo! That worked. All DQL commands must be uppercased? What's the
>>>> advantage of using the tokens?

>>>> On Wed, May 14, 2008 at 3:13 PM, Jonathan Wage <jonw...@gmail.com>
>>>> wrote:

>>>>> Try capitalized WITH? Also I would use tokens in your query. ? instead
>>>>> of directly concatenating it in to the DQL query.

>>>>> - Jon

>>>>> On Wed, May 14, 2008 at 1:10 PM, Alex <outroa...@gmail.com> wrote:

>>>>>> $query = Doctrine_Query::create()->from('CommentItem
>>>>>> c')->leftJoin('c.sfGuardUser u')->leftJoin('c.VoteComment vc with vc.user_id
>>>>>> = '.$this->getUser()->getId());
>>>>>> }

>>>>>> $treeObject = $commentTable->getTree();
>>>>>> $treeObject->setBaseQuery($query);

>>>>>> echo $treeObject->getBaseQuery()->getSqlQuery();

>>>>>> Output is

>>>>>> "SELECT c.id AS c__id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS
>>>>>> c__level, c.root_id AS c__root_id FROM comments c LEFT JOIN sf_guard_user s
>>>>>> ON c.user_id = s.id LEFT JOIN votes v ON c.id = v.comment_id WHERE
>>>>>> (v.type = 2 OR v.type IS NULL)"

>>>>>> Doctrine seems to be discarding my last leftJoin's with condition. Is
>>>>>> this a bug or am I doing something wrong?
>>>>>> --

>>>>>> - Alex

>>>>> --
>>>>> Jonathan Wage
>>>>> http://www.jwage.com
>>>>> http://www.centresource.com

>>>> --

>>>> - Alex

>>> --
>>> Jonathan Wage
>>> http://www.jwage.com
>>> http://www.centresource.com

>> --

>> - Alex

> --
> Jonathan Wage
> http://www.jwage.com
> http://www.centresource.com

- Alex

Reply to author Forward