| # |
Oct 8th 2018, 09:51 |
 rudy1976s |
I normally avoid using json fields when I need to translate info |
| # |
Oct 8th 2018, 09:51 |
rudy1976s |
that was I though too |
| # |
Oct 8th 2018, 09:50 |
edgaras.jan |
possible but pretty hard |
| # |
Oct 8th 2018, 09:50 |
rudy1976s |
is possible ? |
| # |
Oct 8th 2018, 09:49 |
rudy1976s |
last question: what can be the best way to use Translate Behavior in such field ? |
| # |
Oct 8th 2018, 09:48 |
edgaras.jan |
`JSON_EXTRACT(json_field, '$.color')` |
| # |
Oct 8th 2018, 09:48 |
rudy1976s |
thank you ! |
| # |
Oct 8th 2018, 09:47 |
edgaras.jan |
Read here first https://dev.mysql.com/doc/refman/5.7/en/json.html |
| # |
Oct 8th 2018, 09:44 |
rudy1976s |
for example in the json field I have a field called color : is possibile to use the ->where using the color json field? |
| # |
Oct 8th 2018, 09:42 |
rudy1976s |
but the query builder “knows” the fileds contained in the json ? |
| # |
Oct 8th 2018, 09:41 |
neon1024 |
The MySQL documentation shows you all the various sql you can use |
| # |
Oct 8th 2018, 09:41 |
neon1024 |
Sure you can |
| # |
Oct 8th 2018, 09:41 |
rudy1976s |
the column is used to store record parameters and sometimes I need to query against a value contained in that field |
| # |
Oct 8th 2018, 09:40 |
rudy1976s |
can I use the json fields in the query builder ? |
| # |
Oct 8th 2018, 09:39 |
rudy1976s |
I using a table with a columns used as json type |
| # |
Oct 8th 2018, 09:39 |
rudy1976s |
good morning |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I’m not convinced there are any, but need to test anyway |
| # |
Oct 8th 2018, 08:49 |
neon1024 |
I need to test my application for injections |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
`->where(['example' => $escaped]);` |
| # |
Oct 8th 2018, 08:47 |
neon1024 |
Just to sanity check, the values in a condition array are already escaped right? |
| # |
Oct 8th 2018, 08:00 |
turkles |
gooday |
| # |
Oct 8th 2018, 07:56 |
josbeir |
goood morning cakephphphhhhh |
| # |
Oct 8th 2018, 07:54 |
neon1024 |
Morning all |
| # |
Oct 8th 2018, 07:15 |
turkles |
I don't see why you would want to lose all that lovely functionality by doing that |
| # |
Oct 8th 2018, 07:15 |
turkles |
start_date is an object, so is at that level |
| # |
Oct 7th 2018, 22:59 |
rightscoreanalysis |
[0] => [id => 103, start_date => 'xxxx', 'end_date' => 'xxxx', 'object' => [.........] ] |
| # |
Oct 7th 2018, 22:58 |
rightscoreanalysis |
it could even be of the format: |
| # |
Oct 7th 2018, 22:57 |
rightscoreanalysis |
but I would like start_and end_date extracted into the top level index |
| # |
Oct 7th 2018, 22:57 |
slackebot |
<rightscoreanalysis> |
| # |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
for example this is my collection after groupby id |
| # |
Oct 7th 2018, 22:56 |
rightscoreanalysis |
@admad do you know if I can add other fields to the index I have grouped by |
| # |
Oct 7th 2018, 20:43 |
rightscoreanalysis |
perfect it works just as I need thank you |
| # |
Oct 7th 2018, 20:41 |
admad |
`debug($roomPricesByPeriod->toArray());` |
| # |
Oct 7th 2018, 20:36 |
rightscoreanalysis |
I'm not sure why |
| # |
Oct 7th 2018, 20:36 |
rightscoreanalysis |
which outputs: 'count' => (int) 6 |
| # |
Oct 7th 2018, 20:35 |
rightscoreanalysis |
$collection = new Collection($propertyTest->toArray()); $roomPricesByPeriod = $propertyTest->groupBy('id'); debug($roomPricesByPeriod); |
| # |
Oct 7th 2018, 20:35 |
rightscoreanalysis |
thanks @admad I tried this: |
| # |
Oct 7th 2018, 19:52 |
admad |
@rightscoreanalysis check out Collection::groupBy() |
| # |
Oct 7th 2018, 19:45 |
rightscoreanalysis |
slept on it and this morning wrote the raw sql to fully understand my needs, which made writing the query in cake much easier |
| # |
Oct 7th 2018, 19:44 |
rightscoreanalysis |
i was burning the midnight oil trying to nail it last night |
| # |
Oct 7th 2018, 19:44 |
rightscoreanalysis |
btw I nailed that join eventually |