time-cafe-web-app/migrations/005_insert-into-bookings.sql

-- reservation format "YYYY-MM-DDTHH:MM"
-- time_reserve "HH:MM"
-- fail check time_reserve
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:00", "00:00", "");

-- fail check time_reserve
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:00", "00:29", "");

-- fail check time_reserve
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:00", "12:01", "");

-- success check time_reserve
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:00", "00:30", "");

-- success until 02:30
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T01:00", "01:30", "");

-- fail check begin
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:30", "01:00", "");

-- fail check middle
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:30", "01:30", "");

-- fail check end
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T00:30", "02:00", "");

-- fail check begin
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T01:00", "00:30", "");

-- fail check middle
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T01:30", "00:30", "");

-- fail check end
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T02:00", "00:30", "");

-- success 
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T02:30", "00:30", "");

-- success
INSERT INTO
  Bookings (
    id_tables,
    reservation,
    time_reserve,
    who_booked
  )
VALUES
  (1, "2000-01-01T03:00", "00:30", "");