Skip to content

oyyarko/sequelize_node

Repository files navigation

Steps

NodeJs project with MySQL db with Sequelize ORM:

  1. npm init -y
  2. npm install express sequelize mysql2 body-parser
  3. mkdir models config
  4. npx sequelize-cli init
  5. npx sequelize-cli model:generate --name User --attributes firstName:string,lastName:string,email:string
  6. npx sequelize-cli db:migrate
  7. node index.js

TO-DO api's

  1. Pagination in Posts and Users
  2. Like and Unlike a Post
  3. Follow and Unfollow users
  4. Account freez and unfreez
  5. Account delete
  6. Account signup and login
  7. JWT authentication
  8. Search Users
  9. Delete Post
  10. Update Post
  11. Update User
  12. Delete Comment
  13. Save or Unsave Posts
  14. Suggested Users or Posts
  15. Users following/followers list
  16. Message between two user [Socket.io]
  17. Group Message [Socket.io]
  18. Nested Comment [hierarchy]
  19. Share posts with other Users
  20. Public or Private account
  21. Accept/Reject Request if private account
  22. Display posts when private and followed, no validation for public
  23. Followers list only if user request is accepted and public users
  24. Pending Requests
  25. Remove User from following

TO-DO issue fixing

  1. Only owner of Post/Comment can delete it
  2. Nested comment debug
  3. Don't allow reliking

Releases

No releases published

Packages

No packages published