NOTE: Remember to create the .env file with the information for your database. The username, password, database and host information needs to be in the .env file.
Insert default values with no users
INSERT INTO Hotels (Name, Location)
VALUES ('Street Motel', 'Chicago');
INSERT INTO Hotels (Name, Location)
VALUES ('Mariott', 'Warshaw');
INSERT INTO Rooms (Capacity, PricePerDay, HotelId)
VALUES (2, 22.50, 1),(4, 40, 1);
INSERT INTO Rates (UserId, HotelId, Value)
VALUES (1, 1, 4);
INSERT INTO Reservations (UserId, RoomId, StartDate, EndDate)
VALUES (1, 1, '2022-11-11 10:00:00', '2022-11-14 10:00:00');
CREATE PROCEDURE `insert_reservation` (_UserId INT, _RoomId INT, _StartDate DATETIME, _EndDate DATETIME)
BEGIN
INSERT INTO Reservations SET UserId = _UserId, StartDate = _StartDate, EndDate = _EndDate, RoomId = _RoomId
ON DUPLICATE KEY UPDATE StartDate = _StartDate, EndDate = _EndDate;
END