Python REST API -- Pet Hotel

REST API using Flask, performs basic CRUD operations on two data tables in a PostreSQL db. It's paired with a React front end. Made as part of a team challenge to spin up a web server in an unfamiliar language.

React front-end

Built With

• Python3
• Flask
• Psycopg3
• PostgreSQL on Postico

Getting Started

Prerequisites

• Python3
• Pip3
• PostgreSQL client like Postico
• Node.js (to get front-end packages)

Should come with repo, if not install with pip3:

• Flask
• psycopg2

Installing

Steps to get the development environment running.

1. Download this project.
2. Run queries in python_hotel.sql
3. Configure database stored in mainConnection
4. export FLASK_APP=server/server.py
5. flask run

To start front-end

1. Download React UI
2. npm install
3. npm start
4. Navigate to http://localhost:3000/

Completed Features

• CRUD for two tables
• Database information displayed on DOM

Next Steps

• Break up routes with a router
• More readable file structure

Authors

• Bradley Hennen
• Lili Bourgeois
• Jarvis Yang