| # |
Sep 29th 2016, 19:08 |
harry1 |
Leonardo_0112: probably a cron job? |
| # |
Sep 29th 2016, 18:50 |
Leonardo_0112 |
Hi guys! I'm working in a cakephp2 project and i need to automatically generate a .csv file based on database records. The csv file is already been generated by controller/model when I access a URL. What is the best way to make it run automaticaaly every day, for instance. |
| # |
Sep 29th 2016, 17:37 |
 admad |
;) |
| # |
Sep 29th 2016, 17:36 |
noibilism |
@admad: i got itâ?¦.thanksâ?¦.some validation rules were violated |
| # |
Sep 29th 2016, 17:32 |
slackebot |
~tell noibilism about gist |
| # |
Sep 29th 2016, 17:32 |
slackebot |
Command sent from Slack by admad: |
| # |
Sep 29th 2016, 17:32 |
admad |
show the output of `debug($entities) before passing to saveMany() |
| # |
Sep 29th 2016, 17:31 |
noibilism |
@admad itâ??s not saving the data |
| # |
Sep 29th 2016, 17:31 |
noibilism |
itâ??s not saving the data |
| # |
Sep 29th 2016, 17:30 |
admad |
@noibilism Why do you think you are doing something wrong? |
| # |
Sep 29th 2016, 17:29 |
hmic |
additionally you can use a queue to process the data more easily *and* run multiple processes at once, which is a huge gain as your machine likely has more than one core |
| # |
Sep 29th 2016, 17:28 |
hmic |
still: split the qery up. your data will grow and memory will be exhausted at some point |
| # |
Sep 29th 2016, 17:27 |
hmic |
because theres no memory limit on the command line in the default configuration of php on debian or ubuntu |
| # |
Sep 29th 2016, 17:27 |
rudy1976s |
so I was thinking of a memory issue |
| # |
Sep 29th 2016, 17:27 |
rudy1976s |
but the same query on command line has no problem |
| # |
Sep 29th 2016, 17:26 |
rudy1976s |
I know I solved that way |
| # |
Sep 29th 2016, 17:25 |
hmic |
rudy1976s: the answer is simple: too much! process the query in smaller chunks |
| # |
Sep 29th 2016, 17:24 |
rudy1976s |
Hello , what is the memory needed to run a query which will process around 100k of records with 150k of records related with hasMany? I am facing problems with memory exhaust error, although I have already set ->bufferResults(false) |
| # |
Sep 29th 2016, 17:16 |
noibilism |
hello guysâ?¦i am having issues using the saveMany cakephp function |
| # |
Sep 29th 2016, 17:15 |
hmic |
Neon1024, he's just joking with me |
| # |
Sep 29th 2016, 17:15 |
admad |
cya, have a good night's sleep :slightly_smiling_face: |
| # |
Sep 29th 2016, 17:15 |
hmic |
admad: he's from the country that invented the bse disease :p |
| # |
Sep 29th 2016, 17:15 |
Neon1024 |
Later |
| # |
Sep 29th 2016, 17:15 |
Neon1024 |
But your sarcasm is enough to send me home |
| # |
Sep 29th 2016, 17:15 |
admad |
then what's your excuse for asking stupid question? :P |
| # |
Sep 29th 2016, 17:15 |
Neon1024 |
My excuse is that itâ??s 18:13, and Iâ??ve been at my desk for 10 hours |
| # |
Sep 29th 2016, 17:14 |
Neon1024 |
No, I haven't |
| # |
Sep 29th 2016, 17:14 |
Neon1024 |
Why? |
| # |
Sep 29th 2016, 17:14 |
admad |
Neon1024: have you also been working with js lately? |
| # |
Sep 29th 2016, 17:14 |
Neon1024 |
Or perhaps not as itâ??s not an entity yet |
| # |
Sep 29th 2016, 17:13 |
Neon1024 |
->select(â??first_nameâ??, â??last_nameâ??, â??mutatorFullNameâ??) |
| # |
Sep 29th 2016, 17:13 |
Neon1024 |
You can select a mutator in a query right? |
| # |
Sep 29th 2016, 17:09 |
admad |
do it! now! |
| # |
Sep 29th 2016, 17:07 |
hmic |
admad: you mean decreasing numbers from memory? - same happens to my money all the time. i should stop that js shit immediately! |
| # |
Sep 29th 2016, 17:05 |
hmic |
prepender, http://book.cakephp.org/3.0/en/core-libraries/collections.html#Cake\Collection\Collection::groupBy |
| # |
Sep 29th 2016, 17:04 |
admad |
yup too much js can do that to you, the symptoms fit |
| # |
Sep 29th 2016, 17:04 |
prepender |
hmic: im not following |
| # |
Sep 29th 2016, 17:04 |
hmic |
admad: might be that im doing too much nodejs lately :p |
| # |
Sep 29th 2016, 17:03 |
hmic |
prepender, Collection::indexBy i call it still |
| # |
Sep 29th 2016, 17:03 |
admad |
hmic: do i need to call a doctor? |
| # |
Sep 29th 2016, 17:02 |
prepender |
what is indexby? |