Log message #4267666

# At Username Text
# Jul 16th 2021, 08:29 paolo.bragagni $query = $this->Categorie ->find('search', ['search' => $this->request->getQueryParams()]) ->notMatching($return['returnmodel'], function ($q) { return $q->where([$return['returnmodel'] . '.id' => $return['returncontrollerid']]); });
# Jul 16th 2021, 08:29 paolo.bragagni how to do this?
# Jul 16th 2021, 08:29 paolo.bragagni morning
# Jul 15th 2021, 22:45 jh ```$articles->Comments->getTable()```
# Jul 15th 2021, 22:44 jh https://api.cakephp.org/4.2/class-Cake.ORM.Table.html#getTable()
# Jul 15th 2021, 22:42 jh https://book.cakephp.org/4/en/orm/table-objects.html
# Jul 15th 2021, 22:42 jh https://book.cakephp.org/3/en/orm/table-objects.html
# Jul 15th 2021, 22:42 jh or ->getTable()
# Jul 15th 2021, 22:41 jh `$posts->comments->getTableName()` or simiar
# Jul 15th 2021, 22:41 jh $tableClass->{'AssociationName')->getTableName() or similar
# Jul 15th 2021, 22:39 jh oh just the table name
# Jul 15th 2021, 22:38 jh get a table class instance
# Jul 15th 2021, 22:38 jh setup has-many/belongs to
# Jul 15th 2021, 15:31 sibusiso Resolving by doing the following: ```public function getForeignTable($column) { if ('_id' === substr($column, -3)){ $column = substr($column, 0, -3); } return Inflector::classify($column); }```
# Jul 15th 2021, 15:05 cnizzardini np, for really basic stuff I just have a shell script that i run which does all that plus runs migrations and whatever else i need. For more elaborate stuff i use github actions (or jenkins if i have to). but you don't need to worry about elaborate stuff for now.
# Jul 15th 2021, 14:56 davidmckenzie2015 Yes, I agree thanks - webapp dev is a side gig - so I have some learning and refresh to do on git - thanks for the help.
# Jul 15th 2021, 14:49 cnizzardini `git pull andand composer install --no-dev` and possibly some bin/cake cache clear commands added on is enough to deploy small/basic apps
# Jul 15th 2021, 14:47 cnizzardini you should just learn git
# Jul 15th 2021, 14:20 davidmckenzie2015 Thanks, I'll check out using rync.
# Jul 15th 2021, 14:14 admad You can also use rsync to upload files to server which would be blazing fast compared to FTP
# Jul 15th 2021, 13:57 davidmckenzie2015 Ya, disk space was a primary concern. Sounds like it will be better to have each webapp have its one set of cakephp files. Looks like I need to find some tutorials on how to use git hub and/or composer to manage the files on the server w/o having to transfer using an FTP client - that takes forever. Thanks for the help and tips.
# Jul 15th 2021, 13:56 sibusiso Hi everyone, Quick question: given a column name like "product_id," is there a simple built-in function that will return "Products" as a foreign table? Thanks you
# Jul 15th 2021, 13:43 cnizzardini There is probably some hacky way to do it with symbolic links, but I sense it being a lot of pain for little (any?) gain. What if you need to run cakephp 4.2 for one app and 4.3 for another? What about other dependency issues? Not worth.
# Jul 15th 2021, 11:34 hmic the simple answer is: you dont.
# Jul 15th 2021, 11:32 martin ``` $this->belongsToMany('Products', [ 'foreignKey' => 'store_id', 'targetForeignKey' => 'product_id', 'through' => 'StoresProducts', 'finder' => 'active', ]);``` like this does not work so I think I also need to create that active filter in Products table, but how do I filter there on the end_date in stores_products
# Jul 15th 2021, 11:27 martin I’ve a in table `Stores` a BelongsToMany relation ship with `Products`, I did add through to the relation ship, now in the through table there is an end date, so I just want to contain `Products` to the `Store` which are not expired. I already created a finder active in the `StoresProducts` table. but I think I can not use that one with the BelongsToMany?
# Jul 15th 2021, 11:13 g.garin20191123 Hi everyone! I am from originally Vietnam currently live in Krasnodar, Russia. I am a full stack developer. I can work full time remotely in any time zone. I am looking for full time remote job. Please send me a message if you are looking for a good experienced developer. Thank you, Gavril.
# Jul 15th 2021, 09:58 dereuromark right right
# Jul 15th 2021, 09:54 eax Schema was the way forward :+1:
# Jul 15th 2021, 09:54 eax @dereuromark That only returns the changed values, but thanks :)
# Jul 15th 2021, 09:53 dereuromark $entity->toArray()? :)
# Jul 15th 2021, 09:52 eax Sadly it does not, but good idea with the schema, trying that thanks! :)
# Jul 15th 2021, 09:52 Martin` and you can also read the table schema I think
# Jul 15th 2021, 09:51 Martin` it is not really a array, but it acts as one :P
# Jul 15th 2021, 09:51 Martin` does `foreach ($entity as $k => $v)` not work? or array_get_keys() ?
# Jul 15th 2021, 09:49 eax Hey folks :) In Cake3.8, is there a way to get the name of all the fields in an entity?
# Jul 15th 2021, 06:30 alamnaryab fixed now, I was passing wrong foreign key values.
# Jul 15th 2021, 06:21 alamnaryab For my above issue, I was mistakenly assigning user_ids instead of `Student_id` and `Guardian_id` so it is solved now.
# Jul 15th 2021, 06:05 rudy1976s Hello good morning! I am baking some seed for my plugin: I am creating using bake: my plugin is located in vendor but the bake sometimes creates seeds in app plugin folder and sometimes in the correct path; is there a way to set path for plugin baking ?
# Jul 15th 2021, 05:59 slackebot2 until I try to save `StudentGuardian` , because here I am passing `student_id` and `guardian_id` which is not yet committed to database so it is throwing error that these values does not exist in master tables. How can I handle this situation.
# Jul 15th 2021, 05:59 alamnaryab Good Morning I have school project, on admission entry process, I have to enter `Students` `Guardians` also I have to add `Users` entries for both to allow them login the application. there is student2Guardian relationship table, for which model is named as `StudentGuardians` which has `student_id` and `guardian_id` fields as foreign keys. I am doing all these insertions within a Transaction (to save all or none) all is good