| # |
Mar 14th 2018, 16:23 |
 jeremyharris |
if you’re deciding between the two, I would run through their respective tutorials, hang out in the communities, explore the plugin space, and decide which one (if either) fits your needs. we’ll be happy to answer any cake specific questions if you’ve got them |
| # |
Mar 14th 2018, 16:21 |
jeremyharris |
picking a framework or a toolset depends on the job at hand. heck, even picking a language depends on the job |
| # |
Mar 14th 2018, 16:21 |
jeremyharris |
is a hammer better than a screwdriver? depends what you’re doing |
| # |
Mar 14th 2018, 16:19 |
sssd |
is cakephp better than laravel? |
| # |
Mar 14th 2018, 15:59 |
dereuromark |
would be nice if you can make a PR to fix this. |
| # |
Mar 14th 2018, 15:58 |
dereuromark |
https://github.com/dereuromark/cakephp-sandbox/blob/3.0/tests/Fixture/UsersFixture.php#L18 |
| # |
Mar 14th 2018, 15:57 |
dereuromark |
looks like it is not complete |
| # |
Mar 14th 2018, 15:40 |
alexmax |
there is no boolean type? |
| # |
Mar 14th 2018, 15:40 |
alexmax |
https://book.cakephp.org/3.0/en/development/testing.html#creating-fixtures |
| # |
Mar 14th 2018, 15:39 |
alexmax |
oh, found it |
| # |
Mar 14th 2018, 15:38 |
alexmax |
Where can I find a list of all schema data types? |
| # |
Mar 14th 2018, 15:19 |
pierre-baptiste.varle |
thank you @dereuromark |
| # |
Mar 14th 2018, 15:17 |
pierre-baptiste.varle |
I will use the standard php function |
| # |
Mar 14th 2018, 15:16 |
dereuromark |
you can use some own lib with your own url() method if you want to, this is not framework relevant though |
| # |
Mar 14th 2018, 15:16 |
dereuromark |
it is designed for the internal building |
| # |
Mar 14th 2018, 15:16 |
dereuromark |
performance issues |
| # |
Mar 14th 2018, 15:15 |
pierre-baptiste.varle |
I was thinking that router can be used for external url too |
| # |
Mar 14th 2018, 15:15 |
pierre-baptiste.varle |
yes I just found http://php.net/manual/fa/function.http-build-url.php thank |
| # |
Mar 14th 2018, 15:13 |
dereuromark |
build_query_strings() etc manually called will do the trick for u |
| # |
Mar 14th 2018, 15:13 |
dereuromark |
its mainly meant for internal URLs :slightly_smiling_face: for external you can skip it |
| # |
Mar 14th 2018, 15:08 |
pierre-baptiste.varle |
@narendravaghela Router::url('http://www.google.com') return 'http://www.google.com' right? why to use this function if it's do nothing? I would like to have something like thister::url(['http://www.google.com', '?'=>['q'=>'search Query']]) |
| # |
Mar 14th 2018, 14:11 |
lorenzo |
what was the generated query? |
| # |
Mar 14th 2018, 13:27 |
narendravaghela |
by the way, the query returns too many results - 451 rows |
| # |
Mar 14th 2018, 13:23 |
narendravaghela |
I am using ~3.2 |
| # |
Mar 14th 2018, 13:22 |
lorenzo |
It is like debug() but specialized to query objects |
| # |
Mar 14th 2018, 13:22 |
lorenzo |
There is also sql($query) if you are using the latest debugkit |
| # |
Mar 14th 2018, 13:19 |
narendravaghela |
dumpanddie, I did't know that |
| # |
Mar 14th 2018, 13:19 |
narendravaghela |
and also thanks @brettl for `dd` |
| # |
Mar 14th 2018, 13:19 |
narendravaghela |
thanks :thumbsup: |
| # |
Mar 14th 2018, 13:19 |
lorenzo |
Look at the generated query and fix any erros |
| # |
Mar 14th 2018, 13:19 |
lorenzo |
Cool I think you can figure it out from here |
| # |
Mar 14th 2018, 13:18 |
narendravaghela |
but now `Unknown column TL.id` |
| # |
Mar 14th 2018, 13:18 |
lorenzo |
Haha yes @brettl just going slower with him |
| # |
Mar 14th 2018, 13:17 |
lorenzo |
Remove it |
| # |
Mar 14th 2018, 13:17 |
lorenzo |
Yeah, it is |
| # |
Mar 14th 2018, 13:17 |
narendravaghela |
I think I need to remove newExpr() |
| # |
Mar 14th 2018, 13:17 |
lorenzo |
I think $q might already be newExpr() and I’m not remembering correctly |
| # |
Mar 14th 2018, 13:16 |
slackebot |
'start_time' => 'string', 'TimeLogs__end_time' => 'string', 'TimeLogs.end_time' => 'string', 'end_time' => 'string', 'TimeLogs__hours' => 'integer', 'TimeLogs.hours' => 'integer', 'hours' => 'integer', 'TimeLogs__mins' => 'integer', 'TimeLogs.mins' => 'integer', 'mins' => 'integer', 'TimeLogs__description' => 'text', 'TimeLogs.description' => 'text', 'description' => 'text', 'TimeLogs__created' => 'datetime', |
| # |
Mar 14th 2018, 13:16 |
slackebot |
'TimeLogs.created' => 'datetime', 'created' => 'datetime', 'TimeLogs__modified' => 'datetime', 'TimeLogs.modified' => 'datetime', 'modified' => 'datetime' ] [protected] _types => [] } } ``` |
| # |
Mar 14th 2018, 13:16 |
slackebot |
'TimeLogs.project_id' => 'integer', 'project_id' => 'integer', 'TimeLogs__task_id' => 'integer', 'TimeLogs.task_id' => 'integer', 'task_id' => 'integer', 'TimeLogs__work_activity_id' => 'integer', 'TimeLogs.work_activity_id' => 'integer', 'work_activity_id' => 'integer', 'TimeLogs__date' => 'date', 'TimeLogs.date' => 'date', 'date' => 'date', 'TimeLogs__start_time' => 'string', 'TimeLogs.start_time' => 'string', |
| # |
Mar 14th 2018, 13:16 |
narendravaghela |
``` object(Cake\Database\Expression\QueryExpression) { [protected] _conjunction => 'AND' [protected] _conditions => [] [protected] _typeMap => object(Cake\Database\TypeMap) { [protected] _defaults => [ 'TimeLogs__id' => 'integer', 'TimeLogs.id' => 'integer', 'id' => 'integer', 'TimeLogs__user_id' => 'integer', 'TimeLogs.user_id' => 'integer', 'user_id' => 'integer', 'TimeLogs__project_id' => 'integer', |