# |
Nov 6th 2019, 00:38 |
daniel.upshaw |
But that's the output I have in `bin/cake --help` |
# |
Nov 6th 2019, 00:38 |
slackebot1 |
migrations dump - migrations mark_migrated - migrations migrate - migrations orm-cache-build - migrations orm-cache-clear - migrations rollback - migrations seed - migrations status``` |
# |
Nov 6th 2019, 00:38 |
daniel.upshaw |
```Bake: - bake - bake all - bake behavior - bake cell - bake command - bake component - bake controller - bake controller all - bake fixture - bake fixture all - bake form - bake helper - bake mailer - bake middleware - bake model - bake model all - bake plugin - bake shell - bake shell_helper - bake task - bake template - bake template all - bake test Migrations: - migrations - migrations create - |
# |
Nov 6th 2019, 00:38 |
daniel.upshaw |
Yep. I see they're still in the `Task` folder: https://github.com/cakephp/migrations/tree/4.x/src/Shell/Task |
# |
Nov 6th 2019, 00:36 |
dereuromark |
bake part? snapshot etc? very much possible |
# |
Nov 6th 2019, 00:34 |
daniel.upshaw |
Perusing that at the moment |
# |
Nov 6th 2019, 00:34 |
daniel.upshaw |
Looks like the `4.x` Migrations still needs the functionality to generate from existing schemas, yes? |
# |
Nov 6th 2019, 00:04 |
daniel.upshaw |
No, more likely my config :,) |
# |
Nov 6th 2019, 00:04 |
daniel.upshaw |
Oh, interesting |
# |
Nov 6th 2019, 00:03 |
daniel.upshaw |
Lol |
# |
Nov 6th 2019, 00:03 |
daniel.upshaw |
Oops |
# |
Nov 6th 2019, 00:02 |
daniel.upshaw |
```/* * The actual directory name for the application directory. Normally * named 'src'. */ define('APP_DIR', 'src'); /* * Path to the application's directory. */ define('APP', CMS_CORE_PATH . DS . APP_DIR . DS);``` |
# |
Nov 6th 2019, 00:02 |
daniel.upshaw |
Yes it appears to be in the code |
# |
Nov 5th 2019, 23:53 |
daniel.upshaw |
Fair |
# |
Nov 5th 2019, 23:53 |
dereuromark |
still alpha |
# |
Nov 5th 2019, 23:53 |
dereuromark |
u never know |
# |
Nov 5th 2019, 23:53 |
daniel.upshaw |
Yah, I mean it's such a basic thing I'm sure it won't be present in a fresh app install |
# |
Nov 5th 2019, 23:51 |
dereuromark |
verified in minutes, and then hopefully it becomes a bit easier to track down the rest |
# |
Nov 5th 2019, 23:51 |
dereuromark |
still good to exclude such things as core bugs |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
This is really bare bones though.. I'm trying to work with a basic `require cakephp/cakephp` |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
That'll be the way to go |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
Oddly, it's only some of the templates, specifically Error templates |
# |
Nov 5th 2019, 23:50 |
dereuromark |
see if you can replicate with fresh 4.x app |
# |
Nov 5th 2019, 23:49 |
daniel.upshaw |
I wouldn't put it past a config issue... but I did normalize things to Cake4 as closely as I could |
# |
Nov 5th 2019, 23:45 |
dereuromark |
sounds like a config issue, or a bug |
# |
Nov 5th 2019, 23:42 |
daniel.upshaw |
Any ideas offhand why Cake4 branch would look for any templates in `src/templates`? |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
variable does have the contain ``` $query = $this->Table->find( 'all' ) ->contain( ['Table2'] ); ``` The contain also works if i remove my function from above (to show related information in my index page) but i dont know how i can perform a custom where in which both my tables are being searched with concatinated fields |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
->like( $conc2, "%$search%" ) ->like( $conc3, "%$search%" ) ->like( $conc4, "%$search%" ); } ); } ``` But all I get is a ``` Column not found: 1054 Unknown column 'Table2.first_name' in 'where clause' ``` due to the fact, that the Query doesn't join. This functions resides in my index() function of my Table1Controller and the initialization of the $query |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
'Table2.last_name' => 'literal' ] ); $conc4 = $q->func() ->concat( [ 'Table2.last_name' => 'literal', ' ', 'Table2.first_name' => 'literal' ] ); return $exp->or( [ 'Table1.company LIKE' |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
=> "%$search%", 'Table1.first_name LIKE' => "%$search%", 'Table1.last_name LIKE' => "%$search%", 'Table1.city LIKE' => "%$search%", 'Table2.first_name LIKE' => "%$search%", 'Table2.last_name LIKE' => "%$search%" ] ) ->like( $conc1, "%$search%" ) |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
'Table1.last_name' => 'literal', ' ', 'Table1.first_name' => 'literal' ] ); // Concatenated EasybillCustomersContacts Name $conc3 = $q->func() ->concat( [ 'Table2.first_name' => 'literal', ' ', |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
*/ // Concatenated EasybillCustomers Name $conc1 = $q->func() ->concat( [ 'Table1.first_name' => 'literal', ' ', 'Table1.last_name' => 'literal' ] ); $conc2 = $q->func() ->concat( [ |
# |
Nov 5th 2019, 23:19 |
kevin.pfeifer |
i try to do something like that ``` // Change query if a search parameter is given in GET data if ( $search ) { // Search for concat fields in cakephp >=3 // https://stackoverflow.com/questions/35405261/search-with-concat-fields-in-cakephp-3 $query->where( function( $exp, $q ) use ( $search ) { /** * @var QueryExpression $exp * @var Query $q |
# |
Nov 5th 2019, 21:56 |
phantomwatson |
Ah, nevermind for my question. `Table::getDependent()` was right in front of me the whole time. |
# |
Nov 5th 2019, 21:50 |
phantomwatson |
I might be misunderstanding what you're trying to do. |
# |
Nov 5th 2019, 21:49 |
phantomwatson |
@kevin.pfeifer, does it work to specify a join and include the table name in the field name, e.g. `concat(['title' => 'Articles.title', 'author' => 'Authors.name'])`? |
# |
Nov 5th 2019, 21:47 |
phantomwatson |
Does anyone happen to know how to query a table or entity and determine which associations are marked as dependent? |
# |
Nov 5th 2019, 21:35 |
kevin.pfeifer |
i found that, but this only works for the same table https://stackoverflow.com/questions/35405261/search-with-concat-fields-in-cakephp-3 |
# |
Nov 5th 2019, 21:34 |
kevin.pfeifer |
someones know how I can use connected tables inside a custom QueryExpression for a concatenated where search? |
# |
Nov 5th 2019, 21:23 |
daniel.upshaw |
Just getting used to the new folder structure... still confusing why it was searching in `src/` if the folder is moved |
# |
Nov 5th 2019, 21:21 |
daniel.upshaw |
Yeah oddly it wanted to find that template in `src/templates` |