Skip to content

Latest commit

 

History

History
33 lines (22 loc) · 783 Bytes

queriesAndRequest.md

File metadata and controls

33 lines (22 loc) · 783 Bytes

DROP TABLE tickets;

CREATE INDEX tickets_by_status ON tickets (status);

CREATE INDEX tickets_by_movie ON tickets (movie);

INSERT INTO tickets (ticket_id, movie, price, seat, status, user_id, timestamp) VALUES (1a76c0b5-08b0-416d-8ca5-255f92a0c77B, 'opa', 30, 12, 'free', '', '');

SELECT * FROM tickets;

POST http://localhost:3000/reserve/USERID Content-Type: application/json

{ "price": "half", "seat": 2, "movie": "canhassi", "ticketId": "7b527ca2-e377-11ed-b5ea-0242ac120002" }

GET http://localhost:3000/ticket/TICKETID Content-Type: application/json

PUT http://localhost:3000/reserve/TICKETID Content-Type: application/json

{ "userId": "7b527ca2-e377-11ed-b5ea-0242ac120002" }

GET http://localhost:3000/tickets/MOVIE Content-Type: application/json