Full log

Checking database connection...
Executing (default): SELECT 1+1 AS result
Database connection OK!
Executing (default): SELECT `id`, `title`, `description`, `apartmentId`, `termId` FROM `apartmentListings` AS `apartmentListing`;
GET /listings/apartments 200 7.373 ms - 2
Executing (31d9f432-424b-43cd-9dc1-a53ed6bcb967): BEGIN DEFERRED TRANSACTION;
Executing (31d9f432-424b-43cd-9dc1-a53ed6bcb967): SELECT `id`, `city`, `street`, `streetNum` FROM `addresses` AS `address` WHERE `address`.`city` = 'Novi Sad' AND `address`.`street` = 'Alekse Šantića' AND `address`.`streetNum` = 4 LIMIT 1;
Executing (31d9f432-424b-43cd-9dc1-a53ed6bcb967): INSERT INTO `addresses` (`id`,`city`,`street`,`streetNum`) VALUES (NULL,$1,$2,$3);
Executing (31d9f432-424b-43cd-9dc1-a53ed6bcb967): COMMIT;
{
  address: { id: 1, city: 'Novi Sad', street: 'Alekse Šantića', streetNum: 4 },
  addressCreated: true
}
Executing (db62a9a8-2386-4d9a-9c78-2c172018f32e): BEGIN DEFERRED TRANSACTION;
Executing (db62a9a8-2386-4d9a-9c78-2c172018f32e): SELECT `id`, `constructedIn`, `numOfFloors`, `parking`, `garage`, `elevator`, `cctv`, `intercom`, `addressId` FROM `buildings` AS `building` WHERE `building`.`addressId` = 1 AND `building`.`constructedIn` = 2009 AND `building`.`numOfFloors` = 1 AND `building`.`parking` = 1 AND `building`.`garage` = 0 AND `building`.`elevator` = 0 AND `building`.`cctv` = 1 AND `building`.`intercom` = 1 LIMIT 1;
Executing (db62a9a8-2386-4d9a-9c78-2c172018f32e): INSERT INTO `buildings` (`id`,`constructedIn`,`numOfFloors`,`parking`,`garage`,`elevator`,`cctv`,`intercom`,`addressId`) VALUES (NULL,$1,$2,$3,$4,$5,$6,$7,$8);
Executing (db62a9a8-2386-4d9a-9c78-2c172018f32e): COMMIT;
{
  building: {
    id: 1,
    addressId: 1,
    constructedIn: 2009,
    numOfFloors: 1,
    parking: true,
    garage: false,
    elevator: false,
    cctv: true,
    intercom: true
  },
  buildingCreated: true
}
Executing (default): SELECT `id`, `name` FROM `items` AS `item` WHERE `item`.`name` IN ('Ležaj', 'Plakar', 'Telefon', 'Internet', 'Kancelarijski nameštaj');
Executing (7a15155f-39a5-44f1-a550-912bcfed3e5c): BEGIN DEFERRED TRANSACTION;
Executing (7a15155f-39a5-44f1-a550-912bcfed3e5c): SELECT `id`, `location`, `area`, `price`, `state`, `heating`, `equipment`, `floor`, `numOofRooms`, `buildingId` FROM `apartments` AS `apartment` WHERE `apartment`.`buildingId` = 1 AND `apartment`.`location` = 'Grbavica' AND `apartment`.`area` = 30 AND `apartment`.`price` = 30 AND `apartment`.`state` = 'Izvorno' AND `apartment`.`heating` = 'Centralno' AND `apartment`.`equipment` = 'Namešten' AND `apartment`.`floor` = 0 AND `apartment`.`numOofRooms` = 0 LIMIT 1;
Executing (7a15155f-39a5-44f1-a550-912bcfed3e5c): INSERT INTO `apartments` (`id`,`location`,`area`,`price`,`state`,`heating`,`equipment`,`floor`,`numOofRooms`,`buildingId`) VALUES (NULL,$1,$2,$3,$4,$5,$6,$7,$8,$9);
Executing (7a15155f-39a5-44f1-a550-912bcfed3e5c): COMMIT;
{
  apartment: {
    id: 1,
    buildingId: 1,
    location: 'Grbavica',
    area: 30,
    price: 30,
    state: 'Izvorno',
    heating: 'Centralno',
    equipment: 'Namešten',
    floor: 0,
    numOofRooms: 0
  },
  apartmentCreated: true
}
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (1);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (2);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (4);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (6);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (16);
Executing (c6063ddd-c549-441b-a6fd-1b0c8a1213b8): BEGIN DEFERRED TRANSACTION;
Executing (c6063ddd-c549-441b-a6fd-1b0c8a1213b8): SELECT `id`, `available`, `deposit`, `forStudents`, `forWorkers`, `smoking`, `petFriendly` FROM `terms` AS `terms` WHERE `terms`.`available` = '2024-12-31 23:00:00.000 +00:00' AND `terms`.`deposit` = 1 AND `terms`.`forStudents` = 1 AND `terms`.`forWorkers` = 0 AND `terms`.`smoking` = 0 AND `terms`.`petFriendly` = 0 LIMIT 1;
Executing (c6063ddd-c549-441b-a6fd-1b0c8a1213b8): INSERT INTO `terms` (`id`,`available`,`deposit`,`forStudents`,`forWorkers`,`smoking`,`petFriendly`) VALUES (NULL,$1,$2,$3,$4,$5,$6);
Executing (default): INSERT INTO `ApartmentItems` (`apartmentId`,`itemId`) VALUES (1,1);
Executing (default): INSERT INTO `ApartmentItems` (`apartmentId`,`itemId`) VALUES (1,2);
Executing (default): INSERT INTO `ApartmentItems` (`apartmentId`,`itemId`) VALUES (1,4);
Executing (c6063ddd-c549-441b-a6fd-1b0c8a1213b8): COMMIT;
Executing (default): INSERT INTO `ApartmentItems` (`apartmentId`,`itemId`) VALUES (1,16);
Executing (default): INSERT INTO `ApartmentItems` (`apartmentId`,`itemId`) VALUES (1,6);
{
  terms: {
    id: 1,
    available: 2025-01-01T00:00:00.000Z,
    deposit: true,
    forStudents: true,
    forWorkers: false,
    smoking: false,
    petFriendly: false
  },
  termsCreated: true
}
Executing (a706dfb5-6edf-4a9b-b53d-ac21e69ed92f): BEGIN DEFERRED TRANSACTION;
Executing (a706dfb5-6edf-4a9b-b53d-ac21e69ed92f): SELECT `id`, `title`, `description`, `apartmentId`, `termId` FROM `apartmentListings` AS `apartmentListing` WHERE `apartmentListing`.`title` = 'Oglas 1' AND `apartmentListing`.`description` = 'Opis za oglas 1.' AND `apartmentListing`.`apartmentId` = 1 AND `apartmentListing`.`termId` = 1 LIMIT 1;
Executing (a706dfb5-6edf-4a9b-b53d-ac21e69ed92f): INSERT INTO `apartmentListings` (`id`,`title`,`description`,`apartmentId`,`termId`) VALUES (NULL,$1,$2,$3,$4);
Executing (a706dfb5-6edf-4a9b-b53d-ac21e69ed92f): COMMIT;
{
  listing: {
    id: 1,
    title: 'Oglas 1',
    description: 'Opis za oglas 1.',
    apartmentId: 1,
    termId: 1
  },
  listingCreated: true
}
POST /listings/apartments 200 204.312 ms - 22
Executing (97af2b39-c862-4169-a9ed-29f8ddc571ce): BEGIN DEFERRED TRANSACTION;
Executing (97af2b39-c862-4169-a9ed-29f8ddc571ce): SELECT `id`, `city`, `street`, `streetNum` FROM `addresses` AS `address` WHERE `address`.`city` = 'Novi Sad' AND `address`.`street` = 'Alekse Šantića' AND `address`.`streetNum` = 4 LIMIT 1;
Executing (97af2b39-c862-4169-a9ed-29f8ddc571ce): COMMIT;
{
  address: { id: 1, city: 'Novi Sad', street: 'Alekse Šantića', streetNum: '4' },
  addressCreated: false
}
Executing (f392490a-69d2-4d18-a0f6-b7abffa27f35): BEGIN DEFERRED TRANSACTION;
Executing (f392490a-69d2-4d18-a0f6-b7abffa27f35): SELECT `id`, `constructedIn`, `numOfFloors`, `parking`, `garage`, `elevator`, `cctv`, `intercom`, `addressId` FROM `buildings` AS `building` WHERE `building`.`addressId` = 1 AND `building`.`constructedIn` = 2009 AND `building`.`numOfFloors` = 1 AND `building`.`parking` = 1 AND `building`.`garage` = 0 AND `building`.`elevator` = 0 AND `building`.`cctv` = 1 AND `building`.`intercom` = 1 LIMIT 1;
Executing (f392490a-69d2-4d18-a0f6-b7abffa27f35): COMMIT;
{
  building: {
    id: 1,
    constructedIn: 2009,
    numOfFloors: 1,
    parking: true,
    garage: false,
    elevator: false,
    cctv: true,
    intercom: true,
    addressId: 1
  },
  buildingCreated: false
}
Executing (default): SELECT `id`, `name` FROM `items` AS `item` WHERE `item`.`name` IN ('Ležaj', 'Plakar', 'Telefon', 'Internet', 'Kancelarijski nameštaj');
Executing (7632026f-0cce-43e0-8afc-c7904c86b50b): BEGIN DEFERRED TRANSACTION;
Executing (7632026f-0cce-43e0-8afc-c7904c86b50b): SELECT `id`, `location`, `area`, `price`, `state`, `heating`, `equipment`, `floor`, `numOofRooms`, `buildingId` FROM `apartments` AS `apartment` WHERE `apartment`.`buildingId` = 1 AND `apartment`.`location` = 'Grbavica' AND `apartment`.`area` = 30 AND `apartment`.`price` = 30 AND `apartment`.`state` = 'Izvorno' AND `apartment`.`heating` = 'Centralno' AND `apartment`.`equipment` = 'Namešten' AND `apartment`.`floor` = 0 AND `apartment`.`numOofRooms` = 0 LIMIT 1;
Executing (7632026f-0cce-43e0-8afc-c7904c86b50b): COMMIT;
{
  apartment: {
    id: 1,
    location: 'Grbavica',
    area: 30,
    price: 30,
    state: 'Izvorno',
    heating: 'Centralno',
    equipment: 'Namešten',
    floor: 0,
    numOofRooms: 0,
    buildingId: 1
  },
  apartmentCreated: false
}
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (1);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (2);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (4);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (6);
Executing (default): SELECT `apartmentId`, `itemId` FROM `ApartmentItems` AS `ApartmentItems` WHERE `ApartmentItems`.`apartmentId` = 1 AND `ApartmentItems`.`itemId` IN (16);
Executing (c24cc51c-0d36-4a10-a145-6371d2ed6227): BEGIN DEFERRED TRANSACTION;
Executing (c24cc51c-0d36-4a10-a145-6371d2ed6227): SELECT `id`, `available`, `deposit`, `forStudents`, `forWorkers`, `smoking`, `petFriendly` FROM `terms` AS `terms` WHERE `terms`.`available` = '2024-12-31 23:00:00.000 +00:00' AND `terms`.`deposit` = 1 AND `terms`.`forStudents` = 1 AND `terms`.`forWorkers` = 0 AND `terms`.`smoking` = 0 AND `terms`.`petFriendly` = 0 LIMIT 1;
Executing (c24cc51c-0d36-4a10-a145-6371d2ed6227): INSERT INTO `terms` (`id`,`available`,`deposit`,`forStudents`,`forWorkers`,`smoking`,`petFriendly`) VALUES (NULL,$1,$2,$3,$4,$5,$6);
Executing (c24cc51c-0d36-4a10-a145-6371d2ed6227): COMMIT;
{
  terms: {
    id: 2,
    available: 2025-01-01T00:00:00.000Z,
    deposit: true,
    forStudents: true,
    forWorkers: false,
    smoking: false,
    petFriendly: false
  },
  termsCreated: true
}
Executing (5a218553-ba3e-4732-8d8c-e64d402fdd9e): BEGIN DEFERRED TRANSACTION;
Executing (5a218553-ba3e-4732-8d8c-e64d402fdd9e): SELECT `id`, `title`, `description`, `apartmentId`, `termId` FROM `apartmentListings` AS `apartmentListing` WHERE `apartmentListing`.`title` = 'Oglas 1' AND `apartmentListing`.`description` = 'Opis za oglas 1.' AND `apartmentListing`.`apartmentId` = 1 AND `apartmentListing`.`termId` = 2 LIMIT 1;
Executing (5a218553-ba3e-4732-8d8c-e64d402fdd9e): INSERT INTO `apartmentListings` (`id`,`title`,`description`,`apartmentId`,`termId`) VALUES (NULL,$1,$2,$3,$4);
Executing (5a218553-ba3e-4732-8d8c-e64d402fdd9e): COMMIT;
{
  listing: {
    id: 2,
    title: 'Oglas 1',
    description: 'Opis za oglas 1.',
    apartmentId: 1,
    termId: 2
  },
  listingCreated: true
}
POST /listings/apartments 200 26.405 ms - 22
Executing (default): SELECT `id`, `title`, `description`, `apartmentId`, `termId` FROM `apartmentListings` AS `apartmentListing`;
GET /listings/apartments 200 1.686 ms - 175