Back End Database

Description

This project involved creating a database and then using seed data to fill the database. After the database had info stored in it the user would be able to manipulate in any way they want by means of Create, Read, Update, and Delete.

I HAVE learned to:

1. Connect routes to models
2. Create a database and tables inside the database.
3. Link the database to mySQL
4. Use CRUD on a database

Built With

Insomnia, JavaScript, mySQL, Node.js, Sequelize, Express, DBeaver

Table of Contents

• Installation
• Usage
• Contributing
• Tests
• License
• Contact
• Acknowledgments

Installation

Install comment:

• Clone the Repo from github to your system.
• Install node.js installed.
• Install DBeaver installed.
• Install Insomnia.
• Open the terminal of the repo and run npm i.
• You will need to go into the db folder and click on the schema and run the contents of it in DBeaver.
• Lastly you will need to make sure you are in the outermost layer of the file and run npm run seed to seed the databases.

(back to top)

🔭 Walkthrough video🔭

Usage

1. Open the terminal and run the command line of npm start
2. Open Insomnia afterwards and type in the nav bar to manipulate your database.

(back to top)

Contributing

(back to top)

Tests

Test 1

(back to top)

License

(back to top)

Contact

For any further questions feel free to contact me via:

• GitHub: JonJon50
• Email: [email protected]
• LinkedIn: JonJon50

(back to top)

Acknowledgments

👨‍💻 We are Coding BootCamp Alumni of UCF ⭐️

MIT License

The MIT License (MIT)

Copyright (c)

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.