# |
Mar 16th 2018, 07:11 |
rudy1976s |
good morning ! |
# |
Mar 16th 2018, 07:05 |
savant |
@cookieguru if that was for submitting a talk to the conference, please reach out to @megan who can help facilitate :slightly_smiling_face: |
# |
Mar 16th 2018, 07:04 |
savant |
hope that helps (sorry for not responding earlier, was submitting talks to cakefest :P ) |
# |
Mar 16th 2018, 07:02 |
savant |
In regards to performance, that really depends upon the view itself and how its constructed for your particular datastore |
# |
Mar 16th 2018, 07:01 |
savant |
newer versions handle complex joins and subqueries in a much more performant manner |
# |
Mar 16th 2018, 07:00 |
savant |
@vwpoit I would definitely try to ensure you are using a newer version of MySQL |
# |
Mar 16th 2018, 07:00 |
savant |
james_fr: You need to `use` the class path |
# |
Mar 16th 2018, 06:49 |
james_fr |
i installed Piwik lib https://packagist.org/packages/piwik/device-detector in cakephp using composer and i can see its in vendor folder... not i want to use it in controller.. how can i do .. |
# |
Mar 16th 2018, 06:47 |
james_fr |
hi admad |
# |
Mar 16th 2018, 05:47 |
vwpoit |
It combines data from lots of different places and I'm trying to find out if creating a MySQL view directly into my database will help or not. |
# |
Mar 16th 2018, 05:46 |
vwpoit |
I ask because I keep getting very poor performance on one particular screen on my app. |
# |
Mar 16th 2018, 05:46 |
vwpoit |
Hello, everyone! I came here because I haven't found solid information on how CakePHP handles MySQL views in terms of performance. Does it cache them like it does with regular MySQL tables? If so, does that mean results are more readily available than traditional CakePHP find methods and/or queries? |
# |
Mar 16th 2018, 01:53 |
dereuromark |
We should make all magic strings auto-completeable.. |
# |
Mar 16th 2018, 01:53 |
dereuromark |
I added autocomplete for element() template calls: https://github.com/dereuromark/cakephp-ide-helper/pull/77 Can someone with PHPStorm maybe test and give feedback here? |
# |
Mar 16th 2018, 00:58 |
bez |
hi! i have a question about CakePHP 3 password hashing with DefaultPasswordHasher: does it uses the Security.salt for something? is it possible to change Security.salt in controller before hashing the password, for say, creating an account for another CakePHP application with a distinct Security.salt? |
# |
Mar 15th 2018, 22:27 |
obinoob |
It's hard to get some basic help around! I've to drop this... unfortunately php communities are extremely toxic |
# |
Mar 15th 2018, 22:23 |
obinoob |
ok thanks I've found it $this->paginate = [ 'order' => ['Users.id' => 'desc'] |
# |
Mar 15th 2018, 22:16 |
obinoob |
is it possible to sort after order? |
# |
Mar 15th 2018, 22:12 |
obinoob |
I can't sort asc or desc with query such as $this->Table->find()->where([...])->orderAsc(); |
# |
Mar 15th 2018, 20:39 |
phpnut |
will have it checked out |
# |
Mar 15th 2018, 20:36 |
lorenzo |
@phpnut ^ |
# |
Mar 15th 2018, 20:33 |
cookieguru |
I tried several different usernames, including gibberish, and every time I try and sign up at https://my.cakephp.org/join it says `This username is already in use.` |
# |
Mar 15th 2018, 19:23 |
inoas |
ok |
# |
Mar 15th 2018, 19:23 |
dereuromark |
because it doesnt need to, the main where() logic happens which is the obvious exception of the current behavior |
# |
Mar 15th 2018, 19:23 |
inoas |
no test case for false |
# |
Mar 15th 2018, 19:22 |
inoas |
https://github.com/cakephp/cakephp/pull/11782/files |
# |
Mar 15th 2018, 19:22 |
inoas |
I do |
# |
Mar 15th 2018, 19:22 |
dereuromark |
you should look into the core pr |
# |
Mar 15th 2018, 19:22 |
inoas |
ok |
# |
Mar 15th 2018, 19:22 |
inoas |
don't have a test suite around, but I tried the SQL and it is invalid |
# |
Mar 15th 2018, 19:22 |
dereuromark |
you are welcome to see what happens, ionas |
# |
Mar 15th 2018, 19:22 |
dereuromark |
try it |
# |
Mar 15th 2018, 19:22 |
conehead |
Still the same :S |
# |
Mar 15th 2018, 19:21 |
inoas |
latter is invalid syntax... |
# |
Mar 15th 2018, 19:21 |
inoas |
@dereuromark wouldn't $query->whereInList('id', [], ['allowEmpty' => false]); generate something similar to SELECT * FROM order WHERE id IN (); |
# |
Mar 15th 2018, 19:09 |
conehead |
I will check. It was all auto generated. So I thought it should work this way. Will add the 's' everywhere |
# |
Mar 15th 2018, 19:08 |
conehead |
you mean the 's' |
# |
Mar 15th 2018, 19:07 |
dereuromark |
you dont see my point? |
# |
Mar 15th 2018, 19:06 |
conehead |
https://pastebin.com/CejCBhLp |
# |
Mar 15th 2018, 19:05 |
dereuromark |
IngridientsRecipe => IngridientsRecipes ? |
# |
Mar 15th 2018, 19:03 |
conehead |
Has anything changed with 'through'? I set it up exactly like in the cookbook (https://book.cakephp.org/3.0/en/orm/associations.html#using-the-through-option), but when I try to open the edit page, it says: `Recipes is not associated with IngridientsRecipe` |