| # |
Jul 20th 2018, 15:42 |
 pedroseco |
:slightly_smiling_face: |
| # |
Jul 20th 2018, 15:42 |
pedroseco |
thanks |
| # |
Jul 20th 2018, 15:42 |
pedroseco |
ill have to flatten those. |
| # |
Jul 20th 2018, 15:37 |
pedroseco |
as fot the views the data type aspect works great, unfortunatly I can’t seem to find a easy solution other than saving those fields on the database itself |
| # |
Jul 20th 2018, 15:36 |
pedroseco |
so I have the object saved, and after that I can / should have a OR conditions to look for various fields in there. |
| # |
Jul 20th 2018, 15:36 |
pedroseco |
not after the last query no. |
| # |
Jul 20th 2018, 15:36 |
lorenzo |
and is the table you are going to look for also dynamic? you don’t know what the field is named? |
| # |
Jul 20th 2018, 15:35 |
pedroseco |
I would prefet to ahve them as fields yes. |
| # |
Jul 20th 2018, 15:35 |
pedroseco |
because its dynamic fields form a external api |
| # |
Jul 20th 2018, 15:35 |
lorenzo |
no |
| # |
Jul 20th 2018, 15:35 |
pedroseco |
does Mysql JSON_EXTRACT works in a text column? |
| # |
Jul 20th 2018, 15:35 |
lorenzo |
but then again, why do that instead of just storing the field in the table itself? |
| # |
Jul 20th 2018, 15:34 |
lorenzo |
you may want to change the datatype of that field to an actual json column |
| # |
Jul 20th 2018, 15:34 |
lorenzo |
if you have stored it as a string (like in a varchar column, or text) then there is no way to find inside it |
| # |
Jul 20th 2018, 15:29 |
pedroseco |
Im using Data Type Json so the results already come in array format and no tin json. |
| # |
Jul 20th 2018, 15:29 |
pedroseco |
I have a json_encoded object in the database and would like to know what would be the best approuch to do a find() in the model where() a specific field on that json_object. |
| # |
Jul 20th 2018, 15:28 |
pedroseco |
Hi Guys! |
| # |
Jul 20th 2018, 13:35 |
neon1024 |
Assuming you meant ‘exists’ |
| # |
Jul 20th 2018, 13:35 |
neon1024 |
Yes, https://github.com/davidyell/CakePHP3-Proffer/blob/master/src/Model/Behavior/ProfferBehavior.php#L59 |
| # |
Jul 20th 2018, 12:31 |
birdy247 |
Is it possible to find if a given valitor exits |
| # |
Jul 20th 2018, 12:08 |
neon1024 |
Well it’s not wrong `resource(174) of type (Unknown)` |
| # |
Jul 20th 2018, 12:05 |
neon1024 |
Which might be unrelated |
| # |
Jul 20th 2018, 12:05 |
neon1024 |
..and a lot of this `PHP Warning: fwrite(): supplied resource is not a valid stream resource in /Users/david/Sites/TelecomsCCA/vendor/cakephp/cakephp/src/Console/ConsoleOutput.php on line 253` |
| # |
Jul 20th 2018, 12:04 |
neon1024 |
Just with a trace and sql errors |
| # |
Jul 20th 2018, 12:04 |
neon1024 |
Currently it spaffs out a HUGE Wall-O-Text |
| # |
Jul 20th 2018, 12:04 |
neon1024 |
I think there could be some improvements made to when Migrations fail to run |
| # |
Jul 20th 2018, 11:30 |
lubos |
@admad thanks for another great plugin, works like a charm |
| # |
Jul 20th 2018, 11:27 |
josbeir |
very nice ux |
| # |
Jul 20th 2018, 11:27 |
josbeir |
@neon1024 that tool is actually very good imo |
| # |
Jul 20th 2018, 11:20 |
admad |
@lubos yes using muffin/orderly |
| # |
Jul 20th 2018, 11:20 |
neon1024 |
Great thanks, I will try and remember that one if I refactor :slightly_smiling_face: |
| # |
Jul 20th 2018, 11:19 |
admad |
@neon1024 if you want 2.x style default ordering for a table there's my Orderly plugin :) |
| # |
Jul 20th 2018, 11:16 |
josbeir |
bookmarked |
| # |
Jul 20th 2018, 11:16 |
josbeir |
hey that looks nice |
| # |
Jul 20th 2018, 11:12 |
neon1024 |
@josbeir RE: Database design tools. I was curious and had a search to see if an application was event needed. It seems not. https://app.sqldbm.com/MySQL/Draft/ |
| # |
Jul 20th 2018, 10:51 |
neon1024 |
Or if you’re using an association, don’t forget you can define the sort in the association as well |
| # |
Jul 20th 2018, 10:50 |
neon1024 |
Or as @dereuromark suggests. Add a field to your Table class and process it with a behaviour which hooks queries and appends the sorting |
| # |
Jul 20th 2018, 10:49 |
neon1024 |
@lubos This is how I’ve tackled it. Not very clean, but it works. I’m sure you can adapt the technique to suit your use-case |
| # |
Jul 20th 2018, 10:48 |
neon1024 |
File uploaded https://cakesf.slack.com/files/U1BT622HW/FBU6U8G5T/default_ordering_using_crud.sh / https://slack-files.com/T053DPNCM-FBU6U8G5T-8efb7797da |
| # |
Jul 20th 2018, 10:48 |
hmic |
sorry, beforeFind |
| # |
Jul 20th 2018, 10:46 |
lubos |
hmic, you said in a beforeFilter call back, that's the controller callback or am I wrong? :slightly_smiling_face: |