# |
Jul 25th 2017, 15:26 |
ra7bi |
i think the table name should be "user_snippet_like" |
# |
Jul 25th 2017, 15:26 |
inoas |
yes many of them ;) |
# |
Jul 25th 2017, 15:25 |
cleptric |
Some of them, like me ^^ |
# |
Jul 25th 2017, 15:25 |
tawriq |
Does anyone know if any of the "https://cakephp.org/pages/team" Core Members are usually active on this slack channel ? |
# |
Jul 25th 2017, 15:25 |
ra7bi |
i will try to find out if there is a solution out of the box with cakephp for this case |
# |
Jul 25th 2017, 15:24 |
ra7bi |
Yah |
# |
Jul 25th 2017, 15:23 |
cleptric |
To be honest, the first time i didn’t find it either ;) |
# |
Jul 25th 2017, 15:22 |
cleptric |
> This is especially handy if you need to define multiple belongsToMany relationships. The default value for this key is the underscored, singular name of the current model, suffixed with ‘_id’. |
# |
Jul 25th 2017, 15:22 |
cleptric |
https://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations |
# |
Jul 25th 2017, 15:22 |
ra7bi |
i could not find in doc anything about this case |
# |
Jul 25th 2017, 15:21 |
cleptric |
Just if you want all the Cake Awesomeness, you have to follow the conventions. But you already have a association that doe this ^^ |
# |
Jul 25th 2017, 15:20 |
cleptric |
I tend to name my relation tables in alphabetically order, but in this case it’s up to you. |
# |
Jul 25th 2017, 15:20 |
cleptric |
Yes, and then in your `UsersTable` ``` $this->belongsToMany('Snippets', [ 'joinTable' => 'likes_users' ]); ``` and maybe some more options. Haven’t tried this yet. |
# |
Jul 25th 2017, 15:19 |
ra7bi |
then each time user like snippet , his id along with the snippet he liked will be on this table? |
# |
Jul 25th 2017, 15:18 |
ra7bi |
which has -user_id -snippet_id |
# |
Jul 25th 2017, 15:18 |
ra7bi |
so can i name the table " users_likes" |
# |
Jul 25th 2017, 15:18 |
cleptric |
You have to name them differently and configure the assocation in your table |
# |
Jul 25th 2017, 15:17 |
ra7bi |
liked* |
# |
Jul 25th 2017, 15:17 |
ra7bi |
what would be the name of the table ? |
# |
Jul 25th 2017, 15:17 |
ra7bi |
now i want to link likes with ( users and snippets ) which mean table will store all snippet likes by user |
# |
Jul 25th 2017, 15:16 |
ra7bi |
Yes that is what i have to link the snippets with users |
# |
Jul 25th 2017, 15:16 |
cleptric |
Speaking of Cake conventions, which work out of the box, the table should be named `users_snippets` with the fields `user_id` and `snippet_id` |
# |
Jul 25th 2017, 15:16 |
ra7bi |
if i create table "users_likes" which has user_id snippet_id |
# |
Jul 25th 2017, 15:15 |
ra7bi |
they are same logic |
# |
Jul 25th 2017, 15:14 |
ra7bi |
it's okay i want to understand one of them |
# |
Jul 25th 2017, 15:14 |
cleptric |
So you want favourite and liked? |
# |
Jul 25th 2017, 15:13 |
ra7bi |
favourite* |
# |
Jul 25th 2017, 15:13 |
ra7bi |
if user want to store his flavorist snippets |
# |
Jul 25th 2017, 15:12 |
ra7bi |
sorry i dont understand what do you mean by Users m:n Snippets |
# |
Jul 25th 2017, 15:12 |
cleptric |
So Users m:n Snippets? |
# |
Jul 25th 2017, 15:11 |
ra7bi |
now i want to store all snippets liked by the user |
# |
Jul 25th 2017, 15:10 |
ra7bi |
all snippets belong to the user |
# |
Jul 25th 2017, 15:10 |
ra7bi |
it store all snippets saved by user |
# |
Jul 25th 2017, 15:09 |
cleptric |
What does users_snippets? |
# |
Jul 25th 2017, 15:07 |
ra7bi |
but seems not working |
# |
Jul 25th 2017, 15:07 |
ra7bi |
i'v three tables users snippets users_snippets now i want to create another table for likes (snippets which liked by user ) what should i call the table ? i've tried users_snippets_likes - user_id -snippet_id |
# |
Jul 25th 2017, 15:06 |
ra7bi |
hey |
# |
Jul 25th 2017, 14:20 |
neon1024 |
It almost got me learning NodeJS too, so I could contribute |
# |
Jul 25th 2017, 14:18 |
neon1024 |
It’s how I know to check my screen wash in the car today :) |
# |
Jul 25th 2017, 14:16 |
joris_ |
Looks cool, but for me hard to keep it up to date |
# |
Jul 25th 2017, 14:16 |
jeremyharris |
that’s very cool. I had a similar idea a while ago, cool to see someone make it happen :slightly_smiling_face: |