Back end for an e-commerce site with a configured working Express.js API to use Sequelize to interact with a MySQL database. Walkthrough Video here.
- General Info
- Technologies Used
- Features
- Screenshots
- Setup
- Usage
- Project Status
- Acknowledgements
- Contact
Given a functional Express.js API, the user is able to connect to a database using Sequelize once the database name, MySQL usernames, and MySQL password are added to an environment file. When schema and seed commands are entered, a development database is created and is seeded with test data. When the user enters the command to invoke the application in the terminal, the server is started and the Sequelize models are synced to the MySQL database. The API GET routes for categories, products, or tags can all be opened in Insomnia which also the data for each of these routes is displayed in a formatted JSON. The API POST, PUT, and DELETE routes can be tested in Insomnia and data can be successfully created, updated, and deleted in the database.
- Express.js
- Sequelize
- MySQL
- dotenv
- Nodemon
- GET all or one product, tag, or category with all of its data.
- POST, PUT, and DELETE products, tags, or categories succesfully performing CRUD operations using Sequelize models.
- Awesome feature 3
In order to get started with the project, the user must add the database name and MySQL username and password in the .env file. In the terminal, use the commands to invoke MySQL, seed the database with test data, and run the application.
npm i
mysql -u root -p
SOURCE db/schema.sql;
npm run seed
npm run start
or npm run watch
to use Nodemon
Project is: in progress.
- Many thanks to my instructor, Michael Pacheco, the TAs, Nirav and Julius, tutor Dane Shrewsbury, and all the AskBCS learning assistants.
Created by Kristine Kim. Feel free to contact me at [email protected]!