Reservation API!
Routes
-
GET /info
-
GET /user
-
PATCH /info/:id
-
PATCH /tablesize/:table_id
-
GET /info/type
-
POST /table/:id
-
POST /find/:type/:party
-
POST /reservation
-
GET /myres
-
GET /adminres/:r_id
-
DELETE /reservation/:id
-
Returns information about the restaurant
-
Returns what kind of User it is
-
Edit the info of restaurant (where id is the restaurant ID) a. You must have r_name,r_adress,r_phone, and r_type of restaurant in the req body
-
Edit the Size of a table (where table_id is the table ID) a. You must have table_size in the req body
-
Returns the avilable types of restaurants
-
Add a new table (where id is the restaurant ID) a. You must have table_size and t_name in req body
-
Returns avilable table in the chosen time slot where type is the id of the type and party is the size of the party both a. You must have from and to in the req body (both JSON dates)
-
Returns the logged in users reservations
-
Returns all the reservations of the restaurant where r_id is the retaurant ID
-
Deletes a reservation where id is the reservation ID
Local dev setup
mv example.env .env
createdb -U "User" spaced-repetition
createdb -U "User" spaced-repetition-test
If your user has a password be sure to set it in .env
for all appropriate fields. Or if using a different user, update appropriately.
npm install
npm run migrate
And npm test
should work at this point
Configuring Postgres
For tests involving time to run properly, configure your Postgres database to run in the UTC timezone.
- Locate the
postgresql.conf
file for your Postgres installation.- E.g. for an OS X, Homebrew install:
/usr/local/var/postgres/postgresql.conf
- E.g. on Windows, maybe:
C:\Program Files\PostgreSQL\11.2\data\postgresql.conf
- E.g on Ubuntu 18.04 probably: '/etc/postgresql/10/main/postgresql.conf'
- E.g. for an OS X, Homebrew install:
- Find the
timezone
line and set it toUTC
:
# - Locale and Formatting -
datestyle = 'iso, mdy'
#intervalstyle = 'postgres'
timezone = 'UTC'
#timezone_abbreviations = 'Default' # Select the set of available time zone
Scripts
Start the application npm start
Start nodemon for the application npm run dev
Run the tests mode npm test
Run the migrations up npm run migrate
Run the migrations down npm run migrate -- 0