To install, please clone this repository to your computer using the following steps in Github:
- Click the "Code" dropdown menu and copy the SSH URL.
- Open your terminal and navigate to the directory you would like to clone this repository into.
- Type "git clone ", replacing with your copied SSH URL. You can substitute an SSH URL with an HTTPS URL.
- Press enter.
This is the back-end of an e-commerce site for the (fictional) company "McAuliffe Co." This website uses node and sequelize to maintain a database of the products McAuliffe Co. sells online, with sub-tables based on category, product, and tag.
If a user utilizes Insomnia or a similar API client application, the user can add, update, or remove any categories, products, or tags of their choice.
Enter the following commands via the terminal for server.js to ensure node is installed and your sql database is running:
npm install psql -U postgres \i database/schema.sql \q node seeds/index.js node server.js
Once you have confirmed the server is running, the user can navigate to Insomnia or a similar program to issue GET, POST, PUT, or DELETE commands so the user can view or update the database.
GET commands can be entered to retrieve either lists of all or individual categories, products, and/or tags. Individual items can be gathered by ID.
POST commands can be entered to create new categories, products, and/or tags.
PUT commands can be entered to update existing categories, products, and/or tags by ID.
DELETE commands can be entered to remove existing categories, products, and/or tags by ID.
Please see this video demo. If unable to view, you can also find the video in assets/videos/screenrecording1.mov.
When contributing to this repository, please reach out to me via e-mail to discuss the change you would like to make first. I am open to ideas both with regards to data stored in the tables and alterations to user interaction with the data.
This project is licensed under the MIT License. For more information, please see the MIT License.
This program was created by Jacob McAuliffe for the UC Berkeley eDX Coding Boot Camp.
In the future, I would like to incorporate both more data within both the database and tables. There's opportunity to expand the tables into categories such as release date, items sold, or manufacturer. The tables themselves could also be expanded to include much of this new information, creating a more organized and user-friendly back-end experience.
If you have further questions, you can reach me at [email protected].
GitHub Account: jacobmca