| # |
May 29th 2017, 08:53 |
 medic |
I'm talking using a cakephp sql statement. |
| # |
May 29th 2017, 08:51 |
hmic |
with the orm the results are streamable, so you can use the technique i was talking about too: chunk the result (collection!) of your query and save the chunks individually, instead of all records at once. |
| # |
May 29th 2017, 08:50 |
hmic |
if its an sql result you can do "insert into ... select from" syntax with mysql at least |
| # |
May 29th 2017, 08:49 |
medic |
My data is returned from the search results. After I give add all to array, then i using saveMany(); |
| # |
May 29th 2017, 08:47 |
hmic |
we are talking about an async task anyways here. just to make sure! |
| # |
May 29th 2017, 08:47 |
hmic |
you can use the collection class to split a large dataset into chunks, while not needing to load all the data upfront, so memory footprint will be doable |
| # |
May 29th 2017, 08:46 |
kareylo |
Or create a seed (lel) |
| # |
May 29th 2017, 08:46 |
hmic |
saving large amounts at once is a bad idea. multiple tasks will help too to speed it up |
| # |
May 29th 2017, 08:46 |
kareylo |
+1 |
| # |
May 29th 2017, 08:46 |
hmic |
medic: iterate. |
| # |
May 29th 2017, 08:23 |
medic |
Hi All, I have question about process data when save to DB. I want save more 1 billions records from table to other table. I using saveMany() but not good. Any good solution to help me. Thanks! |
| # |
May 29th 2017, 06:36 |
kareylo |
@joshuaso91 What's the request you make ? |
| # |
May 29th 2017, 04:06 |
alex-xhs456 |
@admad That did it, thanks! |
| # |
May 29th 2017, 03:50 |
admad |
@alex-xhs456: use 'hiddenField' false in form->input options to prevent anything being submitted |
| # |
May 29th 2017, 03:49 |
josh_rodarte |
I figured it out. I Deleted session files for apache. Had a blackout, probably what caused it. |
| # |
May 29th 2017, 03:45 |
alex-xhs456 |
Have a question with 2.9. A form as a Yes / No radiobutton. If I don't select anything it will submit the field and an empty value ("question": "") which is saved as 'false' in the db (TINYINT(1) field that is nullable). I want it to be NULL instead. Should I make sure the field is not included on submit or look somewhere else? |
| # |
May 29th 2017, 03:42 |
josh_rodarte |
I see it is a ghost error in the repo. great lol |
| # |
May 29th 2017, 03:17 |
josh_rodarte |
I suddenly am getting the error, "Session was already started". The error output is only showing core files. How can I locate the problem? |
| # |
May 29th 2017, 03:13 |
Lander |
It returns articles with only comments from "markstory" or only articles that were commented by "markstory"? |
| # |
May 29th 2017, 03:12 |
Lander |
I didn't get it |
| # |
May 29th 2017, 03:12 |
Lander |
https://pastebin.com/Y2j1L1C5 |
| # |
May 28th 2017, 23:25 |
gustavocp |
hmm, change it from char(36) to varchar(36) and database is ok |
| # |
May 28th 2017, 23:22 |
gustavocp |
FK needs to be varchar(36) or char(36)? |
| # |
May 28th 2017, 23:22 |
gustavocp |
task has a owner, i called it user_id and i put dropdown getting all from users table put it still showing UUID unstead name. And it does not save in database this field |
| # |
May 28th 2017, 23:21 |
gustavocp |
Thank you for reply. bake put displayField on TaskTable look: https://gist.github.com/gustavocp/b905f3c657d219573abd56330ab2ce4e |
| # |
May 28th 2017, 23:17 |
hiromi2424 |
I don’t think UUID dropdown is normal. missing displayField config? |
| # |
May 28th 2017, 23:16 |
hiromi2424 |
@gustavocp There is no difference with integer PK. bin your code |
| # |
May 28th 2017, 23:08 |
gustavocp |
Hello, im using FriendsOfCake/bootstrap-ui and CakeDC/Users. Im doing a exercise and i bake Projects (that belongs to User, so it has user_id as FK poiting to ID using UUID char(36). On add view it takes users on dropdown by UUID but when i saves on database the field user_id is blank. Is there any difference to implement belongsTo relation using UUID ? |
| # |
May 28th 2017, 22:27 |
thomasnucleus |
l |
| # |
May 28th 2017, 20:59 |
igreat |
And it's working fine now |
| # |
May 28th 2017, 20:59 |
igreat |
To root/src/Template/Plugin/CakeDC/Users/Users |
| # |
May 28th 2017, 20:58 |
igreat |
I have resolved my issue Changed this >The view templates are located in root/src/Template/Plugin/cakedc/users/Users |
| # |
May 28th 2017, 20:10 |
dereuromark |
depends on your auth setup |
| # |
May 28th 2017, 20:05 |
chris-andre |
:) I'm using your auth plugin. Guess it queries that often on dev environment only then :P |
| # |
May 28th 2017, 20:02 |
dereuromark |
well, that you dont have to ;) at least if you all combine that into a single "sth changed" flag |
| # |
May 28th 2017, 19:56 |
chris-andre |
True. Ill work something out with the db session. That being said, roles are being checked every request, so sometimes we just _have to_ |
| # |
May 28th 2017, 19:51 |
dereuromark |
if you use a cookie based login, you can also remove the session and let the relogin happen silently, but then you have issues with POSTs fired. would need to preflight ajax then. so that makes it more overkill than a simple and not soo expensive single lookup :slightly_smiling_face: |
| # |
May 28th 2017, 19:47 |
chris-andre |
db query on every request sounds like "overkill". Thanks @dereuromark , Ill look into db sessions |
| # |
May 28th 2017, 19:45 |
dereuromark |
with DB sessions you do that anyway :slightly_smiling_face: |
| # |
May 28th 2017, 19:44 |
chris-andre |
Okay. But that means I will have to query the db to check if any changes has been made for the user, right? |
| # |
May 28th 2017, 19:40 |
dereuromark |
thats why you need db sessions and a privot table of some sorts to manage those relations from user to session |