| # |
Jul 5th 2018, 10:34 |
 neon1024 |
So we have this, https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#dynamic-finders |
| # |
Jul 5th 2018, 10:32 |
neon1024 |
So RTFM :P |
| # |
Jul 5th 2018, 10:32 |
neon1024 |
You need to scroll down and read about `$_extract` |
| # |
Jul 5th 2018, 10:32 |
neon1024 |
Yeah, it does |
| # |
Jul 5th 2018, 10:31 |
neon1024 |
It should be able to deal with ORM prepared data |
| # |
Jul 5th 2018, 10:31 |
neon1024 |
A csv plugin which doesn’t cope with this seems a bit crap to me |
| # |
Jul 5th 2018, 10:31 |
neon1024 |
Or just get an array and use `array_walk()` ? |
| # |
Jul 5th 2018, 10:30 |
neon1024 |
Then you can just use a Collection callback method to call `array_values` |
| # |
Jul 5th 2018, 10:30 |
neon1024 |
So probably don’t cast to array, and use a ResultSet, which implements the Collection |
| # |
Jul 5th 2018, 10:30 |
neon1024 |
http://php.net/array_values |
| # |
Jul 5th 2018, 10:29 |
neon1024 |
So you want `array_values()` ? |
| # |
Jul 5th 2018, 10:25 |
liaogz82 |
cos that is how csvview wants to mould the image |
| # |
Jul 5th 2018, 10:25 |
liaogz82 |
https://github.com/FriendsOfCake/cakephp-csvview#usage |
| # |
Jul 5th 2018, 10:24 |
liaogz82 |
like ``` $data = [ [ '0001', 'CHELLIAH PILLAI ANBALAGAN', '01-Jul-2018', '00:00', '07:57', '07:57', 'EQUINIX' ] ]; ``` |
| # |
Jul 5th 2018, 10:24 |
liaogz82 |
return an array without the keys? |
| # |
Jul 5th 2018, 10:22 |
neon1024 |
Or you can call `->execute()` or `->all()` or `->first()` if you want to execute the query and return a ResultSet or Entity |
| # |
Jul 5th 2018, 10:21 |
neon1024 |
@liaogz82 `$query->toArray();` |
| # |
Jul 5th 2018, 10:21 |
neon1024 |
Or check the Awesome CakepHP list |
| # |
Jul 5th 2018, 10:21 |
liaogz82 |
Guys, I crafted out a query, how do I get the array? |
| # |
Jul 5th 2018, 10:21 |
slackebot4 |
!awesome |
| # |
Jul 5th 2018, 10:21 |
slackebot4 |
Command sent from Slack by neon1024: |
| # |
Jul 5th 2018, 10:20 |
neon1024 |
@mohitprakashsharma555 I feel that’s something you could Google for yourself |
| # |
Jul 5th 2018, 10:18 |
mohitprakashsharma555 |
i want to event calendar, is there have any plugin in cakephp ? |
| # |
Jul 5th 2018, 10:10 |
josbeir |
and idd, chunking is a good solution |
| # |
Jul 5th 2018, 10:09 |
josbeir |
also, make sure to set cascade and callbacks to false if you are just trying to remove from 1 table, otherwise various ORM stuff will trigger and given the number of records that would indeed cause memory issues |
| # |
Jul 5th 2018, 10:09 |
neon1024 |
Chunk it, I guess |
| # |
Jul 5th 2018, 10:09 |
neon1024 |
Sounds like the php ini setting to me |
| # |
Jul 5th 2018, 10:06 |
josbeir |
le_gremz are you passing a large array of ids or something ? |
| # |
Jul 5th 2018, 09:59 |
le_gremz |
i work with cake 2.6.11 and i have some troubles with deleteAll. When i try to use to delet 1k elements, i got an error message "Allowed memory size of 1073741824 bytes exhausted (tried to allocate 523800 bytes)". I don't understand why. If i try do split in to 2 requests like using a "find" then a classic "delete" it's works. Is there anything in need to know about using DeleteAll ? Thx for your help. |
| # |
Jul 5th 2018, 09:53 |
le_gremz |
hello everyone |
| # |
Jul 5th 2018, 09:15 |
jm |
@steinkel thanks will do |
| # |
Jul 5th 2018, 09:14 |
steinkel |
check https://github.com/FriendsOfCake/awesome-cakephp#authentication-and-authorization if that's your case |
| # |
Jul 5th 2018, 09:13 |
steinkel |
@jm some people use ACL when they only require RBAC and some custom rules, like ownership and membership for their permissions |
| # |
Jul 5th 2018, 09:13 |
jm |
@saeideng one last question is wise to integrate ACL plugin on an existing project of just start from the scratch? |
| # |
Jul 5th 2018, 09:10 |
jm |
thanks il check it out |
| # |
Jul 5th 2018, 09:09 |
saeideng |
yes |
| # |
Jul 5th 2018, 09:09 |
jm |
is it now a plugin right? |
| # |
Jul 5th 2018, 09:09 |
saeideng |
I dont use it :slightly_smiling_face: |
| # |
Jul 5th 2018, 09:09 |
saeideng |
should be stable https://github.com/cakephp/acl/releases |
| # |
Jul 5th 2018, 09:08 |
jm |
@saeideng is it stable for production? |
| # |
Jul 5th 2018, 09:08 |
saeideng |
there are other options |