# |
Nov 14th 2017, 17:43 |
saeideng |
The requested URL could not be retrieved |
# |
Nov 14th 2017, 17:43 |
saeideng |
my local domain not works |
# |
Nov 14th 2017, 17:43 |
inoas |
but would be good if there was a standard @ cakephp/app |
# |
Nov 14th 2017, 17:43 |
inoas |
so create src/web-assets or something |
# |
Nov 14th 2017, 17:40 |
etipaced |
Where is the best place to store SCSS files in a Cake 3 project? I don’t know that I want to keep these inside webroot since that’s publicly accessible. |
# |
Nov 14th 2017, 17:39 |
inoas |
there must be a better way than this https://gist.github.com/inoas/7d5be16ddf8be8737b7142a9ec535f66 |
# |
Nov 14th 2017, 17:36 |
inoas |
found it in some older code of mine now ... too |
# |
Nov 14th 2017, 17:36 |
inoas |
return $exp->or_([ there is that thing I was looking for |
# |
Nov 14th 2017, 17:30 |
flavius |
more here -> https://book.cakephp.org/3.0/en/orm/query-builder.html#advanced-conditions |
# |
Nov 14th 2017, 17:30 |
inoas |
hehe, that is very low levely ;-) again I think where and andWhere() do the same thing here |
# |
Nov 14th 2017, 17:29 |
flavius |
@inoas example of query expressions if it helps you -- https://pastebin.com/vMj8cj7d |
# |
Nov 14th 2017, 17:09 |
inoas |
got an example for that, none in the book :E |
# |
Nov 14th 2017, 17:08 |
inoas |
right I am looking for the query expression way |
# |
Nov 14th 2017, 17:08 |
diego182 |
thats what i've been doing lately, i do this way or with query expression |
# |
Nov 14th 2017, 17:07 |
inoas |
just use where(['or' => $yourConditions]) for the most part |
# |
Nov 14th 2017, 17:07 |
inoas |
so it is dangerous to use IMHO |
# |
Nov 14th 2017, 17:06 |
inoas |
diego182 well orWhere can have its uses but as far as I know it basically sets the query object into a state to append addition statements as OR instead of AND |
# |
Nov 14th 2017, 17:06 |
inoas |
was it _or()? |
# |
Nov 14th 2017, 17:06 |
diego182 |
i saw something about it, i guess were at github, that orWhere is comming back, aboud andWhere, i didnt now about that, thanks! |
# |
Nov 14th 2017, 17:06 |
inoas |
which will fail as the keys are not unique |
# |
Nov 14th 2017, 17:06 |
inoas |
now next problem I want to iterate this multiple times $orConditions['Devices.identifier LIKE'] = $value; |
# |
Nov 14th 2017, 17:02 |
inoas |
well not sure if it will stay deprecated, btu you should not - as you were suggesting to use andWhere I just wanted to warn you about orWhere |
# |
Nov 14th 2017, 17:02 |
inoas |
ah wrong channel |
# |
Nov 14th 2017, 17:02 |
inoas |
doing this WHERE a.id IN ( <select article id values related to tag 'parrot'> ) AND a.id IN ( <select article id values related to tag 'bungie'> ) (found here https://stackoverflow.com/questions/24519215/mysql-match-all-tags-rather-than-any/24519276#24519276 ) |
# |
Nov 14th 2017, 17:01 |
diego182 |
not anymore, as its been deprecated |
# |
Nov 14th 2017, 17:00 |
inoas |
btw, are you using orWhere? |
# |
Nov 14th 2017, 17:00 |
inoas |
diego182 |
# |
Nov 14th 2017, 16:56 |
inoas |
it rocks for mixing and matching AND and OR |
# |
Nov 14th 2017, 16:56 |
inoas |
I wish I could easily create an ebay-like search syntax |
# |
Nov 14th 2017, 16:54 |
inoas |
this is how it works https://gist.github.com/inoas/368c0931066033493255f01fb8835a39 |
# |
Nov 14th 2017, 16:50 |
diego182 |
humm |
# |
Nov 14th 2017, 16:49 |
inoas |
the matchings collapse into one innerJoin and an AND statement to concat the conditions |
# |
Nov 14th 2017, 16:49 |
diego182 |
i'm not shure if that would work, but what if you call two matching on query builder? |
# |
Nov 14th 2017, 16:47 |
inoas |
if I create a subquery each time heh |
# |
Nov 14th 2017, 16:46 |
inoas |
sounds it is easily doable |
# |
Nov 14th 2017, 16:46 |
inoas |
WHERE a.id IN ( <select article id values related to tag 'parrot'> ) AND a.id IN ( <select article id values related to tag 'bungie'> ) |
# |
Nov 14th 2017, 16:44 |
inoas |
lorenzo do you have pointers for best practise: Fetch Article matching 2 tags (AND not OR)? |
# |
Nov 14th 2017, 16:44 |
inoas |
but it merges based on assoc name |
# |
Nov 14th 2017, 16:44 |
inoas |
basically using foreach + innerJoinWith (that's like matching without getting data) |
# |
Nov 14th 2017, 16:43 |
inoas |
I have tried the upper already without digging around |
# |
Nov 14th 2017, 16:43 |
inoas |
here is some sql solutions https://stackoverflow.com/a/24519276 |