A big thank you, bro. I was getting crazy (believe you or not) for already more than 6 months trying to understand how this works and how to apply it. Finally I could create this association.
Well done! It's a bit complicated...especially the Many-to-Many relationships but I think you did a good job. Thanks for taking the time to make this video. Cheers.
Hey men, im struggling a lot with a big API project that im developing. In this video, you use asociations between tables that are created by a const. Usign sequelize-CLI, every time that you create a new model, a new file is created and the asociations are declared in a static associate(models) {}. Its too dificult to explain doing associations by that method? Or maybe make a video about it?
@@WebDevJourney Yes, im sorry, my english isn't so good lol. I think you create the sequelize/models manually. When using Sequelize-CLI to create models, the associatios have a little different sintax. In my project, I have created the migrations files with the foreings keys associated columns and tables, but, when I wrote the associations in models file, things are quite different and having some errors of type "ForeignKeyConstraintError"
@@MegaGian2009 I found this levelup.gitconnected.com/creating-sequelize-associations-with-the-sequelize-cli-tool-d83caa902233 Let me know if it helps if not ill try to make a video around this
@@WebDevJourney i think i already read that post, it was posted before sequelize v6 launch. So, the models creations are different. Using the same logic structure of a one-to-Many associations don't work using sequelize v6.
I did an easier version of the code, kind of makes aa dirty model loading but in the end it's cleaner... Anyway TYSM I got so lost in the explanation I was given :c
Thank you for this video :), how to do with 3 tables, users, posts, comments ? 1 user has multiple posts, 1 post has only one user, 1 post has multiple comments, 1 user has multiple comments, 1 comment has only one user
I found how to do it, in file user i add : User.belongsToMany(models.Post, { through: "Comments" }); and in file post i add : Post.belongsToMany(models.User, { through: "Comments" }) in folder migrations in file comment : i add that : userId: { type: Sequelize.INTEGER, references: { model:{ tableName: "Users" }, key: "id" }, allowNull: false }, postId: { type: Sequelize.INTEGER, references: { model:{ tableName: "Posts" }, key: "id" }, allowNull: false
hmm I still dont get it in many-to-many relationship, why when user "wdj" followed "tom" the code say wdj.addUser(tom), isn't that should be wdj.addFollow(tom) ? assuming const wdj = user.findOne({where: {name: "wdj"}}) and const tom = user.findOne({where:{name: "tom"}})
