Re: 3.x - where and null
After this
section
http://book.cakephp.org/3.0/en/orm/query-builder.html#automatically-creating-in-clauses
On Saturday, August 9, 2014 5:34:13 PM UTC+2, Thomas von Hassel wrote:
>
> where ?
>
> On 09 Aug 2014, at 17:33, José Lorenzo wrote:
>
> No, I think we forgot to include it in the book. Would you be kind to do
> that as well? :)
>
> On Saturday, August 9, 2014 5:12:04 PM UTC+2, Thomas von Hassel wrote:
>>
>> It's not really documented is it ? (or maybe i'm just blind ?) (The IS
>> operator that is)
>>
>>
>> /thomas
>> On 09 Aug 2014, at 15:16, José Lorenzo wrote:
>>
>> Nope, it was added after I created the TreeBehavior. Do you have time to
>> submit a PR for changing that?
>>
>> On Saturday, August 9, 2014 3:12:28 PM UTC+2, Thomas von Hassel wrote:
>>>
>>> ok, because i can see in TreeBehavior you do something like this
>>>
>>> ->where(function($exp) use ($parentId, $parent) {
>>>return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
>>> $parentId);
>>> })
>>>
>>> Is there a downside to using IS ?
>>>
>>>
>>> On 09 Aug 2014, at 15:11, José Lorenzo wrote:
>>>
>>> ->where(['parent_id IS' => $parent_id])
>>>
>>> It will convert to NULL if needed or just use the provided value
>>>
>>> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
Hey
in 2.x you could do something like this:
‘conditions’ => array(‘parent_id’ => $parent_id);
where $parent_id could be an int or null
and it would find parent_id that were null in the table
This approach does not work in 3.x. Is there a right way to do this in
3.x where a field in an INT but can be null ?
/thomas
>>> --
>>> Like Us on FaceBook https://www.facebook.com/CakePHP
>>> Find us on Twitter http://twitter.com/CakePHP
>>>
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "CakePHP" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to cake-php+unsubscr...@googlegroups.com.
>>> To post to this group, send email to cake-php@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/cake-php.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "CakePHP" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
where ?
On 09 Aug 2014, at 17:33, José Lorenzo wrote:
> No, I think we forgot to include it in the book. Would you be kind to do that
> as well? :)
>
> On Saturday, August 9, 2014 5:12:04 PM UTC+2, Thomas von Hassel wrote:
> It's not really documented is it ? (or maybe i'm just blind ?) (The IS
> operator that is)
>
>
> /thomas
> On 09 Aug 2014, at 15:16, José Lorenzo wrote:
>
>> Nope, it was added after I created the TreeBehavior. Do you have time to
>> submit a PR for changing that?
>>
>> On Saturday, August 9, 2014 3:12:28 PM UTC+2, Thomas von Hassel wrote:
>> ok, because i can see in TreeBehavior you do something like this
>>
>> ->where(function($exp) use ($parentId, $parent) {
>>return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
>> $parentId);
>> })
>> Is there a downside to using IS ?
>>
>>
>> On 09 Aug 2014, at 15:11, José Lorenzo wrote:
>>
>>> ->where(['parent_id IS' => $parent_id])
>>>
>>> It will convert to NULL if needed or just use the provided value
>>>
>>> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
>>> Hey
>>>
>>> in 2.x you could do something like this:
>>>
>>> 'conditions' => array('parent_id' => $parent_id);
>>>
>>> where $parent_id could be an int or null
>>>
>>> and it would find parent_id that were null in the table
>>>
>>> This approach does not work in 3.x. Is there a right way to do this in 3.x
>>> where a field in an INT but can be null ?
>>>
>>> /thomas
>>>
>>>
>>> --
>>> Like Us on FaceBook https://www.facebook.com/CakePHP
>>> Find us on Twitter http://twitter.com/CakePHP
>>>
>>> ---
>>> You received this message because you are subscribed to the Google Groups
>>> "CakePHP" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an
>>> email to cake-php+unsubscr...@googlegroups.com.
>>> To post to this group, send email to cake-php@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/cake-php.
>>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "CakePHP" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
No, I think we forgot to include it in the book. Would you be kind to do
that as well? :)
On Saturday, August 9, 2014 5:12:04 PM UTC+2, Thomas von Hassel wrote:
>
> It's not really documented is it ? (or maybe i'm just blind ?) (The IS
> operator that is)
>
>
> /thomas
> On 09 Aug 2014, at 15:16, José Lorenzo wrote:
>
> Nope, it was added after I created the TreeBehavior. Do you have time to
> submit a PR for changing that?
>
> On Saturday, August 9, 2014 3:12:28 PM UTC+2, Thomas von Hassel wrote:
>>
>> ok, because i can see in TreeBehavior you do something like this
>>
>> ->where(function($exp) use ($parentId, $parent) {
>>return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
>> $parentId);
>> })
>>
>> Is there a downside to using IS ?
>>
>>
>> On 09 Aug 2014, at 15:11, José Lorenzo wrote:
>>
>> ->where(['parent_id IS' => $parent_id])
>>
>> It will convert to NULL if needed or just use the provided value
>>
>> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
>>>
>>> Hey
>>>
>>> in 2.x you could do something like this:
>>>
>>> ‘conditions’ => array(‘parent_id’ => $parent_id);
>>>
>>> where $parent_id could be an int or null
>>>
>>> and it would find parent_id that were null in the table
>>>
>>> This approach does not work in 3.x. Is there a right way to do this in
>>> 3.x where a field in an INT but can be null ?
>>>
>>> /thomas
>>>
>>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "CakePHP" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
It's not really documented is it ? (or maybe i'm just blind ?) (The IS operator
that is)
/thomas
On 09 Aug 2014, at 15:16, José Lorenzo wrote:
> Nope, it was added after I created the TreeBehavior. Do you have time to
> submit a PR for changing that?
>
> On Saturday, August 9, 2014 3:12:28 PM UTC+2, Thomas von Hassel wrote:
> ok, because i can see in TreeBehavior you do something like this
>
> ->where(function($exp) use ($parentId, $parent) {
>return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
> $parentId);
> })
> Is there a downside to using IS ?
>
>
> On 09 Aug 2014, at 15:11, José Lorenzo wrote:
>
>> ->where(['parent_id IS' => $parent_id])
>>
>> It will convert to NULL if needed or just use the provided value
>>
>> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
>> Hey
>>
>> in 2.x you could do something like this:
>>
>> 'conditions' => array('parent_id' => $parent_id);
>>
>> where $parent_id could be an int or null
>>
>> and it would find parent_id that were null in the table
>>
>> This approach does not work in 3.x. Is there a right way to do this in 3.x
>> where a field in an INT but can be null ?
>>
>> /thomas
>>
>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "CakePHP" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to cake-php+unsubscr...@googlegroups.com.
>> To post to this group, send email to cake-php@googlegroups.com.
>> Visit this group at http://groups.google.com/group/cake-php.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
Nope, it was added after I created the TreeBehavior. Do you have time to
submit a PR for changing that?
On Saturday, August 9, 2014 3:12:28 PM UTC+2, Thomas von Hassel wrote:
>
> ok, because i can see in TreeBehavior you do something like this
>
> ->where(function($exp) use ($parentId, $parent) {
>return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
> $parentId);
> })
>
> Is there a downside to using IS ?
>
>
> On 09 Aug 2014, at 15:11, José Lorenzo wrote:
>
> ->where(['parent_id IS' => $parent_id])
>
> It will convert to NULL if needed or just use the provided value
>
> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
>>
>> Hey
>>
>> in 2.x you could do something like this:
>>
>> ‘conditions’ => array(‘parent_id’ => $parent_id);
>>
>> where $parent_id could be an int or null
>>
>> and it would find parent_id that were null in the table
>>
>> This approach does not work in 3.x. Is there a right way to do this in
>> 3.x where a field in an INT but can be null ?
>>
>> /thomas
>>
>>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
ok, because i can see in TreeBehavior you do something like this
->where(function($exp) use ($parentId, $parent) {
return $parentId === null ? $exp->isNull($parent) : $exp->eq($parent,
$parentId);
})
Is there a downside to using IS ?
On 09 Aug 2014, at 15:11, José Lorenzo wrote:
> ->where(['parent_id IS' => $parent_id])
>
> It will convert to NULL if needed or just use the provided value
>
> On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote:
> Hey
>
> in 2.x you could do something like this:
>
> 'conditions' => array('parent_id' => $parent_id);
>
> where $parent_id could be an int or null
>
> and it would find parent_id that were null in the table
>
> This approach does not work in 3.x. Is there a right way to do this in 3.x
> where a field in an INT but can be null ?
>
> /thomas
>
>
> --
> Like Us on FaceBook https://www.facebook.com/CakePHP
> Find us on Twitter http://twitter.com/CakePHP
>
> ---
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cake-php+unsubscr...@googlegroups.com.
> To post to this group, send email to cake-php@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php.
> For more options, visit https://groups.google.com/d/optout.
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Re: 3.x - where and null
->where(['parent_id IS' => $parent_id]) It will convert to NULL if needed or just use the provided value On Saturday, August 9, 2014 3:04:51 PM UTC+2, Thomas von Hassel wrote: > > Hey > > in 2.x you could do something like this: > > ‘conditions’ => array(‘parent_id’ => $parent_id); > > where $parent_id could be an int or null > > and it would find parent_id that were null in the table > > This approach does not work in 3.x. Is there a right way to do this in 3.x > where a field in an INT but can be null ? > > /thomas > > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/d/optout.
3.x - where and null
Hey
in 2.x you could do something like this:
'conditions' => array('parent_id' => $parent_id);
where $parent_id could be an int or null
and it would find parent_id that were null in the table
This approach does not work in 3.x. Is there a right way to do this in 3.x
where a field in an INT but can be null ?
/thomas
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
