Giter Club home page Giter Club logo

node-basics's Issues

Add Sequelize

Currently the project has been using the fs module and has been in the process of converting to mySQL db for storing data. Some raw SQL has been implemented. However, as a developer, I'd like to see how sequelize can help with connecting models to the db -- especially as the complexity of the app grows.

Notes:

  • Sequelize is an Object-Relational Mapping library (ORM) that can help to map a regular javascript object to its relevant SQL queries.

Tasks:

  • Connect to db
  • Add Product model
  • Adds functionality to create a product
  • Retrieve data
  • Fetch admin products
    • Update a product
    • Delete a product
  • Add User model
    • Add one-to-many relationship
  • Add Cart model
    • Add to cart
    • Delete from cart
  • Add Order model
    • Store CartItems as OrderItems
    • Add functionality to reset cart

Change from SQL to noSQL

Now that SQL has been implemented, it's a good time to see how SQL contrasts to a noSQL db. To do this, the MongoDB engine will be used.

Notes:

  • MongoDB is schemaless
    • Fewer data relationships
    • Can be visualized as db (Shop) -> Collections (Users & Orders) -> Documents (data entry point).
      • Documents are stored as JSON (BSON - Binary JSON).
    • Relationships are different.
      • Two typical patterns exist
      • Nest the data
      • Use references to other documents/collections

Tasks:

  • Settup MongoDB
    • Install Driver
    • Connect to DB
  • Add Products functionality
    • Get all
    • Get a specific product
    • Update
    • Delete
    • Post
  • Add Users
    • Store User
    • Functionality for a user to have a cart and orders
    • Store multiple products in Cart
    • Display cart items
    • Delete cart items
    • get orders

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.