A MySQL database and application backend for an e-commerce site, where users are able to interact and manipulate data: they can create, update, delete or view desired products, tags and categories. Powered with MySQL2, Express, Sequelize and Dotenv.
Clone this repository on your local machine:
$ git clone https://github.com/lukecp5/e-commerce-backend.git
$ cd e-commerce-backendTo install and set up the application, run:
$ npm install employee-trackerYou will also need to place a .env file in the root directory of the project, in order to connect to your MySQL database.
file: .env
DB_NAME = employee_db
DB_PASSWORD = 'Your MySQL Password'
DB_USER = 'root'
After installation is complete and .env file created in root directory, complete the following steps:
- Create a MySQL database on your local machine using the schema.sql file located in the /db/ directory (From the MySQL CLI, write 'SOURCE db/schema.sql;')
- Seed the database with sample data to be used for testing purposes(Run npm run seed from inside the root directory of the project)
Now you're ready to start the application! You can start the server by running:
npm start
The application is covered under the following license: ISC
For the moment this project does not accept contributions from third parties. Thank you for your interest.
This application was built with:
- Node.js
- Sequelize
- Express.js
- MySQL2
- Dotenv
Please feel free to contact me using the following links: