| # |
Oct 5th 2018, 21:03 |
GloriousYellow_ |
ohh nice, let me try |
| # |
Oct 5th 2018, 20:40 |
 dereuromark |
darn, 0.10 of phinx might solve the "Specified key was too long; max key length is ..." constraint unique issue.. but migrations plugin is still stuck on 0.8 |
| # |
Oct 5th 2018, 19:50 |
itmpls |
user_groups._ids is the fieldname, ->save($entity, ['associated' => 'SiteUsers.UserGroups']); and $this->belongsToMany('UserGroups', ['className' => 'SiteUsers.UserGroups', 'joinTable' => 'user_groups_users', 'foreignKey' => 'user_id', 'className' => 'SiteUsers.UserGroups']); |
| # |
Oct 5th 2018, 19:48 |
itmpls |
updated associations and field name too |
| # |
Oct 5th 2018, 19:48 |
itmpls |
well, renamed the classes to have no prefix and same thing. hmm |
| # |
Oct 5th 2018, 19:42 |
itmpls |
yeah i suppose i just wanted to differentiate it but i'll try messing around with it |
| # |
Oct 5th 2018, 19:41 |
btx |
you’re in a plugin, right? so everything is already prefixed with the plugin name |
| # |
Oct 5th 2018, 19:41 |
itmpls |
it's within the SiteUser plugin, which overrides the Users plugin from cake/dc |
| # |
Oct 5th 2018, 19:41 |
btx |
is there a reason you’re prefixing everything? |
| # |
Oct 5th 2018, 19:40 |
btx |
Cake is gonna be looking for `site_user_group_id` so you’ll have to correct your primary/foreign keys on your Join and Tables |
| # |
Oct 5th 2018, 19:39 |
itmpls |
class name is SiteUserGroupsTable, SiteUsersTable, SiteUserGroupsUsersTable |
| # |
Oct 5th 2018, 19:38 |
itmpls |
user_id and user_group_id, sorry |
| # |
Oct 5th 2018, 19:27 |
btx |
what are the columns in the join table? `user_id` and `site_user_group_id` or `user_group_id` |
| # |
Oct 5th 2018, 19:25 |
btx |
Cake doesn’t care what the db is named, as long as the class names work it can automagic the files/classes to load |
| # |
Oct 5th 2018, 19:24 |
btx |
is that on `UsersTable`? |
| # |
Oct 5th 2018, 19:23 |
itmpls |
hah |
| # |
Oct 5th 2018, 19:23 |
itmpls |
but the className again is SiteUserGroupsUsers not UserGroupsUsers |
| # |
Oct 5th 2018, 19:23 |
itmpls |
for example |
| # |
Oct 5th 2018, 19:23 |
itmpls |
currently i have $this->belongsToMany('SiteUserGroups', ['className' => 'SiteUsers.SiteUserGroups', 'foreignKey' => 'user_id', 'joinTable' => 'user_groups_users']); |
| # |
Oct 5th 2018, 19:22 |
itmpls |
I do a setTable override |
| # |
Oct 5th 2018, 19:22 |
itmpls |
no |
| # |
Oct 5th 2018, 19:22 |
btx |
is it prefixed in the database? |
| # |
Oct 5th 2018, 19:22 |
itmpls |
prefixed by Site |
| # |
Oct 5th 2018, 19:22 |
itmpls |
if the table is 'user_groups_user' but the class name is say, 'SiteUserGroupsUsers' |
| # |
Oct 5th 2018, 19:21 |
itmpls |
also, if the class name for my join table was prefixed, would I have to set that in the belongsToMany association? |
| # |
Oct 5th 2018, 19:14 |
btx |
(plural on second `user`) |
| # |
Oct 5th 2018, 19:14 |
itmpls |
yeah that makes sense |
| # |
Oct 5th 2018, 19:14 |
btx |
the join table should be `user_groups_users` I think tho |
| # |
Oct 5th 2018, 19:14 |
btx |
should be UserGroups first because G < S |
| # |
Oct 5th 2018, 19:12 |
itmpls |
end goal is to save my entity which belongsToMany('UserGroupsUser', ['joinTable' => 'user_groups_user']); |
| # |
Oct 5th 2018, 19:12 |
itmpls |
with how cake expects things to be alphabetical, if i have a 'UserGroupsUser' table does it expect 'User' to be plural and in front, or UserGroups since they start with the same word? |
| # |
Oct 5th 2018, 18:16 |
quinquo |
mescalito: pdksh+openbsd |
| # |
Oct 5th 2018, 18:16 |
quinquo |
fixes lots of crashes. I have to admit, i don't think I've ever had it crash on me |
| # |
Oct 5th 2018, 17:40 |
flashios09 |
so the **post entity** will have **my_fake_table entity** `$post->my_fake_table` |
| # |
Oct 5th 2018, 17:37 |
slackebot |
<flashios09> |
| # |
Oct 5th 2018, 17:36 |
flashios09 |
and it will generate this query: |
| # |
Oct 5th 2018, 17:35 |
slackebot |
<flashios09> |
| # |
Oct 5th 2018, 17:35 |
flashios09 |
then we can do: |
| # |
Oct 5th 2018, 17:28 |
slackebot |
<flashios09> |
| # |
Oct 5th 2018, 17:26 |
slackebot |
// .. ]); } } ``` |
| # |
Oct 5th 2018, 17:26 |
flashios09 |
```php <?php namespace App\Model\Table; use App\ORM\Table; class MyFakeTable extends Table { public function initialize(array $config){ // don't use a hard table $this->table(false); // create a fake schema // i don't know, maybe something like this $this->schema([ 'id' => 'MYSQL_CUSTOM_FUNCTION()', 'another_fake_field' => 'ANOTHER_MYSQL_CUSTOM_FUNCTION()', |