# |
Nov 15th 2019, 10:41 |
Benjamin3 |
Thanks a lot! |
# |
Nov 15th 2019, 10:41 |
Benjamin3 |
That's an interesting approach, sadly doesn't work for postgres, but i'll have a look if i can steal some ideas there for an own solution :-) |
# |
Nov 15th 2019, 10:37 |
challgren |
@benjamin3 try https://github.com/FriendsOfCake/fixturize |
# |
Nov 15th 2019, 10:36 |
Benjamin3 |
? |
# |
Nov 15th 2019, 10:36 |
Benjamin3 |
But: Is there any way to keep the fixtures imported and not throw them away and reimport them after each test= |
# |
Nov 15th 2019, 10:35 |
Benjamin3 |
This seems to be a bit slow (not a problem by itself, schema introspection may take a bit of time |
# |
Nov 15th 2019, 10:35 |
Benjamin3 |
Load Test fixtures (Schema only) by public $import = ['model' =>TableName']; |
# |
Nov 15th 2019, 10:34 |
Benjamin3 |
Hello everyone, i'm using cakephp 3.8 with phpunit. I'm running Tests that |
# |
Nov 15th 2019, 10:32 |
chris-andre |
Cache is cleared. |
# |
Nov 15th 2019, 10:30 |
chris-andre |
Hi people! I have created a plugin inside `app_root/plugins/Bronnoysund` with AppController and BrregController and view files. On dev server (homestead) I can navigate to `domain.test/bronnoysund/brreg` and it works as expected. On prod. server (CloudLinux 6, apache) I get an error with the same url params: `Controller Brreg is not found`. Is a typical mistake for this error? |
# |
Nov 15th 2019, 08:27 |
jotpe |
thanks @kevin.pfeifer |
# |
Nov 15th 2019, 08:27 |
admad |
only one way to find out :slightly_smiling_face: |
# |
Nov 15th 2019, 08:27 |
kgb.acct.personal |
Does that guarantee that I won't run into max memory allocated error? |
# |
Nov 15th 2019, 08:24 |
admad |
@kgb.acct.personal disable results casting too, that will for e.g stop wasting memory converting datetime string to objects |
# |
Nov 15th 2019, 08:21 |
kevin.pfeifer |
@jote |
# |
Nov 15th 2019, 08:21 |
kgb.acct.personal |
I'll look into it. Thanks :+1: |
# |
Nov 15th 2019, 08:20 |
kgb.acct.personal |
That makes sense. Also the thing about CSV streaming |
# |
Nov 15th 2019, 08:19 |
admad |
error hydration not marshalling |
# |
Nov 15th 2019, 08:18 |
admad |
turn off query buffering and marshalling |
# |
Nov 15th 2019, 08:18 |
admad |
depending on how you fetched the data, i might be the resultset eating up the memory, not the generated csv |
# |
Nov 15th 2019, 08:17 |
kgb.acct.personal |
Not that large but "max allowed memory" error is triggered when large amount of data is queried for export |
# |
Nov 15th 2019, 08:16 |
admad |
exactly how large is "large"? |
# |
Nov 15th 2019, 08:15 |
admad |
unbuffered query and stream to csv file |
# |
Nov 15th 2019, 08:14 |
kgb.acct.personal |
@admad I mean from table to CSV :cakephp: |
# |
Nov 15th 2019, 08:13 |
admad |
@kgb.acct.personal one way is: directly load csv file into temp database table, perform cleanup / alterations required, then copy/move rows to required table |
# |
Nov 15th 2019, 08:12 |
jotpe |
Unfortunately my Client wants xlsx output :S |
# |
Nov 15th 2019, 08:11 |
kgb.acct.personal |
Speaking of CSVs. What strategy do you use when exporting large amount of data? |
# |
Nov 15th 2019, 08:11 |
admad |
wisest choice is to generate CSVs :slightly_smiling_face: |
# |
Nov 15th 2019, 08:07 |
jotpe |
or better use PHPExcel directly? |
# |
Nov 15th 2019, 08:07 |
jotpe |
and https://github.com/robotusers/cakephp-excel |
# |
Nov 15th 2019, 08:07 |
jotpe |
https://github.com/dakota/CakeExcel |
# |
Nov 15th 2019, 08:07 |
jotpe |
What's a wise choice to generate Excel Files? Awesome list has 2 Excel Plugins, but both updated 3years ago. |
# |
Nov 15th 2019, 07:08 |
jotpe |
Morning, people! And thanks @admad |
# |
Nov 14th 2019, 20:06 |
alexmax |
I find it a bit strange that the deprecation notices aren't context-dependent - i.e. they don't have a different deprecation depending on if you're using the old method as a getter or a setter. |
# |
Nov 14th 2019, 18:40 |
shifat.it |
started |
# |
Nov 14th 2019, 18:40 |
shifat.it |
ok |
# |
Nov 14th 2019, 17:39 |
admad |
@jotpe `Time extends MutableDateTime`, `MutableDateTime extends DateTime` |
# |
Nov 14th 2019, 17:34 |
jotpe |
Does `Cake\I18n\Time` throw any exceptions like PHP's `DateTime` does? Found nothin in the Api |
# |
Nov 14th 2019, 17:23 |
jotpe |
ty @dereuromark |
# |
Nov 14th 2019, 17:23 |
jotpe |
Ay sorry, was just to stupid to google the correct way :slightly_smiling_face: |
# |
Nov 14th 2019, 17:22 |
dereuromark |
Time class, not helper |