| # |
Apr 15th 2019, 14:00 |
 jeremyharris |
so you could do `select (getrank(column1, column2) as rank` when you needed ranking |
| # |
Apr 15th 2019, 14:00 |
jeremyharris |
yeah sounds like a special method. you may want to use a custom DB function that holds the logic on how you “rank” your results based on what you wrote above |
| # |
Apr 15th 2019, 13:58 |
ricksaccous |
next relevant would probably be first word matched |
| # |
Apr 15th 2019, 13:58 |
ricksaccous |
most relevant would be a result like both words together |
| # |
Apr 15th 2019, 13:58 |
ricksaccous |
i would prob do an or, with likes in them |
| # |
Apr 15th 2019, 13:57 |
ricksaccous |
basically i want to do a like match on a field but let's say two words are used for the search, i'm thinking i want the most relevant 2 matches |
| # |
Apr 15th 2019, 13:57 |
ricksaccous |
haha |
| # |
Apr 15th 2019, 13:57 |
ricksaccous |
ugh |
| # |
Apr 15th 2019, 13:57 |
ricksaccous |
but on the second query i might still want to order by case :( |
| # |
Apr 15th 2019, 13:56 |
ricksaccous |
haha yep |
| # |
Apr 15th 2019, 13:56 |
jeremyharris |
:+1: always more than one way to solve the problem |
| # |
Apr 15th 2019, 13:55 |
ricksaccous |
so i'll do two queries and conglom the results how i want |
| # |
Apr 15th 2019, 13:55 |
ricksaccous |
I'm thinking I'll just divide what i'm doing in two queries anyway because I want the first where clause to prioritize the second where clause, but i might not want to do the first where clause anyway depending on information given to me from elsewhere |
| # |
Apr 15th 2019, 13:54 |
jeremyharris |
@ricksaccous I’ve put a case statement in an order clause once. in the end the code didn’t stick around but I may be able to help |
| # |
Apr 15th 2019, 13:52 |
jeremyharris |
oh were you using validation rules this whole time? I read it as “rules” as in application rules smh |
| # |
Apr 15th 2019, 13:52 |
jeremyharris |
that is for validators though |
| # |
Apr 15th 2019, 13:52 |
jeremyharris |
(I’m seeing it in the code finally) |
| # |
Apr 15th 2019, 13:52 |
birdy247 |
https://book.cakephp.org/3.0/en/core-libraries/validation.html#conditional-dynamic-error-messages |
| # |
Apr 15th 2019, 13:51 |
jeremyharris |
is that documented somewhere? |
| # |
Apr 15th 2019, 13:51 |
jeremyharris |
nice |
| # |
Apr 15th 2019, 13:51 |
birdy247 |
actually it does work :slightly_smiling_face: |
| # |
Apr 15th 2019, 13:50 |
jeremyharris |
I thought rule errors were set when you add the error to the rule builder, so they’re on that class not the invokable object |
| # |
Apr 15th 2019, 13:49 |
ricksaccous |
dang that sucks |
| # |
Apr 15th 2019, 13:49 |
birdy247 |
doesnt* |
| # |
Apr 15th 2019, 13:49 |
birdy247 |
Does seem to work with a custom rule |
| # |
Apr 15th 2019, 13:46 |
ricksaccous |
to make it dynamic |
| # |
Apr 15th 2019, 13:46 |
ricksaccous |
seems like you just return a string |
| # |
Apr 15th 2019, 13:46 |
birdy247 |
https://book.cakephp.org/3.0/en/core-libraries/validation.html#conditional-dynamic-error-messages |
| # |
Apr 15th 2019, 13:45 |
birdy247 |
similar to this |
| # |
Apr 15th 2019, 13:45 |
birdy247 |
Can i make the "message" dyanmic |
| # |
Apr 15th 2019, 13:45 |
birdy247 |
I have made a custom reuseable rule |
| # |
Apr 15th 2019, 13:42 |
ricksaccous |
does anyone have experience using queryBuilder to put cases in order statement? |
| # |
Apr 15th 2019, 13:05 |
J98hasjd |
Can I disable i18n merges for one specific finder? |
| # |
Apr 15th 2019, 13:04 |
J98hasjd |
hi |
| # |
Apr 15th 2019, 12:20 |
martin |
how can I use the mysql replace function in cakephp? I tried `$query->where([$query->func()->replace(['tel', '-', '']) => '21312312]);` but that does not work :S |
| # |
Apr 15th 2019, 08:59 |
dereuromark |
I wrote a tool in https://github.com/dereuromark/cakephp-test-helper to detect which classes are completely missing tests yet (no test file for it) and to quickly generate it via 1 click in GUI. I am sure the tooling here could be further enhanced. |
| # |
Apr 15th 2019, 08:57 |
neon1024 |
Morning :wave: |
| # |
Apr 15th 2019, 08:46 |
dereuromark |
or IDE "rightlick + detect usage" |
| # |
Apr 15th 2019, 08:46 |
dereuromark |
its called code coverage usually |
| # |
Apr 15th 2019, 08:42 |
val |
Is there an easy way to detect whether a class in Lib folder was called by a unit test if that class has no reference to any model? |
| # |
Apr 15th 2019, 08:39 |
challgren |
Ohhhhhh Im not sure on Cake 2. I push that version out of my memory months ago |