Hébergement "Chez Gustave" Docker sur serveur Synology
Conditions d’achèvement
Déployer un projet Docker que vous avez développé en localhost sur un serveur Synology nécessite plusieurs étapes, principalement axées sur la préparation de votre NAS Synology pour exécuter des conteneurs Docker, et ensuite transférer et exécuter votre projet. Voici un guide étape par étape pour réaliser cela :
1. Prérequis
- Avoir un NAS Synology qui supporte Docker. Vous pouvez vérifier cela dans les spécifications de votre modèle sur le site de Synology.
- Installer le paquet Docker via le Centre de paquets de Synology si ce n’est pas déjà fait.
2. Préparer votre projet Docker
- Assurez-vous que votre projet Docker fonctionne correctement en localhost. Cela inclut tous les fichiers nécessaires tels que
Dockerfile,docker-compose.yml(si utilisé), et autres fichiers de configuration ou dossiers. - Vérifiez que toutes les configurations spécifiques à l’environnement sont paramétrables via des variables d'environnement ou des fichiers de configuration externes.
3. Transfert du projet sur Synology
- Via File Station : Connectez-vous à l'interface web de votre Synology, utilisez File Station pour créer un dossier pour votre projet et transférez les fichiers de votre projet.
- Via SSH : Si SSH est activé sur votre Synology, vous pouvez aussi utiliser
scpou un client FTP pour transférer les fichiers.- Pour vous connecter par ssh depuis Internet vous devrez configurer votre routeur pour que le port 22 soit rediriger vers le NAS Synology.
- C'est expliqué plus en détail à la fin du cours?
4. Charger l'image Docker
- Si votre image Docker n'est pas encore construite, vous pouvez la construire directement sur votre Synology via SSH :
cd chemin/vers/votre/projet docker build -t nom-de-votre-image . - Si l'image est déjà prête et disponible sur un registre public comme Docker Hub, vous pouvez simplement la tirer avec :
sudo docker pull nom-utilisateur/nom-de-limage
5. Exécuter le conteneur Docker
- Vous pouvez lancer votre conteneur via l'interface graphique de Docker dans DSM (DiskStation Manager) ou via la ligne de commande :
sudo docker run -d -p 80:80 --name mon-projet nom-de-votre-image - Utilisez
docker-composesi vous avez un fichierdocker-compose.yml:sudo docker-compose up -d
6. Vérification et maintenance
- Vérifiez que votre application fonctionne correctement en accédant à l'adresse IP de votre NAS sur le port configuré.
- Mise à jour : pour mettre à jour votre conteneur, vous devrez peut-être reconstruire l'image Docker et redémarrer le conteneur.
7. Sécurisation
- Assurez-vous que les ports utilisés sont sécurisés et que les éventuelles configurations de sécurité nécessaires sont en place.
- Si votre application est accessible depuis Internet, considérez l'utilisation de HTTPS et d'autres mesures de sécurité pertinentes.
En suivant ces étapes, vous devriez pouvoir déployer avec succès votre projet Docker développé en localhost sur un serveur Synology.
Pour vous connecter à un serveur Synology via SSH, vous devez d'abord activer le service SSH dans le DiskStation Manager (DSM), qui est l'interface de gestion de votre NAS Synology. Voici les étapes pour configurer et utiliser SSH sur votre NAS Synology :
1. Activer le service SSH
- Connectez-vous à DSM : Ouvrez un navigateur web et accédez à l'interface de gestion de votre Synology en saisissant l'adresse IP de votre NAS.
- Panneau de configuration : Allez dans le menu principal et sélectionnez « Panneau de configuration ».
- Services de terminal et SNMP : Cliquez sur « Services de terminal et SNMP » sous la section « Connectivité ».
- Activer le service SSH : Cochez la case « Activer le service SSH » pour permettre les connexions SSH. Vous pouvez laisser le port par défaut (22) ou le modifier selon vos besoins de sécurité.
- Appliquer les changements : Cliquez sur « Appliquer » pour enregistrer les paramètres.
- Pour vous connecter par ssh depuis Internet vous devrez configurer votre routeur pour que le port 22 soit rediriger vers le NAS Synology.
Certificat SSL
Il faudra aussi vous aussrez qu'un certificat ssl soi bien activé et valide
DNS
Dans le cas d'une installation standard du serveur Synology, vous aurez un DNS de configuré à travers le domaine synology. Vérifier qu'un autre domaine n'a pas été configuré.
2. Se connecter via SSH
Une fois le service SSH activé, vous pouvez vous connecter à votre Synology à l'aide d'un client SSH. Si vous utilisez un ordinateur sous Windows, vous pouvez utiliser un client tel que PuTTY ou Windows Subsystem for Linux (WSL). Sous macOS ou Linux, vous pouvez utiliser le terminal intégré.
-
Windows avec PuTTY :
- Téléchargez et ouvrez PuTTY.
- Dans le champ « Host Name (or IP address) », saisissez l'adresse IP de votre Synology.
- Assurez-vous que le port est le même que celui configuré sur votre NAS.
- Cliquez sur « Open » pour établir la connexion.
- Lorsque vous y êtes invité, saisissez votre nom d'utilisateur et votre mot de passe. Le nom d'utilisateur par défaut pour l'administration est
admin.
-
macOS ou Linux :
- Ouvrez le terminal.
- Tapez la commande suivante, en remplaçant
adresse_ippar l'adresse IP de votre Synology etusernamepar votre nom d'utilisateur :sudo ssh username@adresse_ip - Si vous avez changé le port par défaut, utilisez la commande avec l'option
-p, comme suit :sudo ssh -p port username@adresse_ip - Saisissez votre mot de passe lorsque vous y êtes invité
Exemple avec un cas concret
Connexion dans un terminal avec :
sudo ssh admin@aphaena.synology.me
sudo vous permet d'avoir les droits root pour avoir toute les autorisations nécessaire à l'éxécution du script
Trouver le répertoire dans lequel vous avez copier votre projet dockers
Dans l'exemple: admin@aphaena:/volume1/docker/TetianaChezGustave$ cd ChezGustave-main/
PS C:\Users\xavie> ssh admin@aphaena.synology.me
admin@aphaena's password:
admin@aphaena:~$ ls
Backup Drive #recycle www
admin@aphaena:~$ cd www
admin@aphaena:~/www$ ls
admin@aphaena:~/www$ cd ..
admin@aphaena:~$ ls
Backup Drive #recycle www
admin@aphaena:~$ cd ..
admin@aphaena:/var/services/homes$ cd ..
admin@aphaena:/var/services$ cd ..
admin@aphaena:/var$ cd ..
admin@aphaena:/$ ls
bin dev etc.defaults lib lib64 mnt proc run sys usr var.defaults
config etc initrd lib32 lost+found opt root sbin tmp var volume1
admin@aphaena:/$ cd volume1
admin@aphaena:/volume1$ ls
@AntiVirus docker photo surveillance @SynologyApplicationService @webdav
@appstore @docker @pkg-SynologyMom.core.gz @surveillance @synologydrive
@autoupdate @eaDir @quarantine @synocalendar @SynologyDriveShareSync
@calendar homes root @SynoDrive @SYNO.SynologyDr.core.gz
@cloudsync moodle_folder @S2S @SynoFinder-etc-volume @tmp
@database @OfficeLog @ssbackup @SynoFinder-log web
admin@aphaena:/volume1$ cd docker
admin@aphaena:/volume1/docker$ ls
@eaDir TetianaChezGustave
admin@aphaena:/volume1/docker$ cd TetianaChezGustave/
admin@aphaena:/volume1/docker/TetianaChezGustave$ ls
ChezGustave-main
admin@aphaena:/volume1/docker/TetianaChezGustave$ cd ChezGustave-main/
admin@aphaena:/volume1/docker/TetianaChezGustave/ChezGustave-main$ ls
api.md client docker-compose.test.yml docker-compose.yml Dockerfile README.md server
admin@aphaena:/volume1/docker/TetianaChezGustave/ChezGustave-main$ sudo docker-compose up -dExécuter la commande sudo docker-compose up -d
pour cela il faut que votre docker-compose soit bien configuré.
version: '3'
services:
server:
build:
context: server
dockerfile: ../Dockerfile
command: npm start
ports:
- ${SERVER_PORT}:${SERVER_PORT}
volumes:
- ./server:/usr/app
- /usr/app/node_modules
depends_on:
database:
condition: service_healthy
environment:
PORT: ${SERVER_PORT}
DATABASE_URL: postgres://${DATABASE_USER}:${DATABASE_PASSWORD}@database/${DATABASE_NAME}
client:
build:
context: client
dockerfile: ../Dockerfile
command: npm run dev
ports:
- 5173:5173
volumes:
- type: bind
source: ./client
target: /usr/app
- /usr/app/node_modules
depends_on:
- server
database:
image: postgres:alpine
environment:
- POSTGRES_USER=${DATABASE_USER}
- POSTGRES_PASSWORD=${DATABASE_PASSWORD}
- POSTGRES_DB=${DATABASE_NAME}
expose:
- 5432
healthcheck:
test: ["CMD-SHELL", "pg_isready -U ${DATABASE_NAME}"]
interval: 5s
timeout: 5s
retries: 5
pgadmin:
image: dpage/pgadmin4
environment:
- PGADMIN_DEFAULT_EMAIL=${PGADMIN_DEFAULT_EMAIL}
- PGADMIN_DEFAULT_PASSWORD=${PGADMIN_DEFAULT_PASSWORD}
ports:
- ${PGADMIN_PORT}:80
le fichier .env
DATABASE_NAME=chez_gustave
DATABASE_USER=chez_gustave
DATABASE_PASSWORD=super_secret
PGADMIN_PORT=5842
PGADMIN_DEFAULT_EMAIL=mail@example.xyz
PGADMIN_DEFAULT_PASSWORD=password
SERVER_PORT=3630Execution de la commande
sudo docker-compose up -d
sudo docker-compose up -d
We trust you have received the usual lecture from the local System
Administrator. It usually boils down to these three things:
#1) Respect the privacy of others.
#2) Think before you type.
#3) With great power comes great responsibility.
Password:
Creating network "chezgustave-main_default" with the default driver
Pulling database (postgres:alpine)...
alpine: Pulling from library/postgres
4abcf2066143: Pull complete
cd08f48e1184: Pull complete
8da4aab65cbf: Pull complete
fad441eb8f4b: Pull complete
3faf0d9bfc34: Pull complete
9e915f763607: Pull complete
f37f636fd5bf: Pull complete
94f3dac500a5: Pull complete
1ead076a6996: Pull complete
Digest: sha256:7f7832dfb7770c7256fe3f8c4cb57617caee45e2494cc0a736594135237ed9bf
Status: Downloaded newer image for postgres:alpine
Building server
Sending build context to Docker daemon 18.41MB
Step 1/5 : FROM node:lts
lts: Pulling from library/node
1468e7ff95fc: Pulling fs layer
2cf9c2b42f41: Pulling fs layer
c4c40c3e3cdf: Pulling fs layer
c05cc1123d7e: Pulling fs layer
04f2356c02d2: Pulling fs layer
77661ed64275: Pulling fs layer
ae3ac357f6ce: Pulling fs layer
af635ab15a80: Pulling fs layer
77661ed64275: Waiting
ae3ac357f6ce: Waiting
c05cc1123d7e: Waiting
af635ab15a80: Waiting
04f2356c02d2: Waiting
2cf9c2b42f41: Verifying Checksum
2cf9c2b42f41: Download complete
c4c40c3e3cdf: Verifying Checksum
c4c40c3e3cdf: Download complete
04f2356c02d2: Verifying Checksum
1468e7ff95fc: Verifying Checksum
1468e7ff95fc: Download complete
1468e7ff95fc: Pull complete
2cf9c2b42f41: Pull complete
ae3ac357f6ce: Verifying Checksum
ae3ac357f6ce: Download complete
af635ab15a80: Verifying Checksum
af635ab15a80: Download complete
c4c40c3e3cdf: Pull complete
77661ed64275: Verifying Checksum
77661ed64275: Download complete
c05cc1123d7e: Verifying Checksum
c05cc1123d7e: Download complete
c05cc1123d7e: Pull complete
04f2356c02d2: Pull complete
77661ed64275: Pull complete
ae3ac357f6ce: Pull complete
af635ab15a80: Pull complete
Digest: sha256:5e362bbb5ef4c6f6e2c86a27b7269b3b3e4bd8dba16be18037ee7ee4caa8afc1
Status: Downloaded newer image for node:lts
---> 1d3adb31a8ca
Step 2/5 : WORKDIR /usr/app
---> Running in 283637ccd659
Removing intermediate container 283637ccd659
---> 0bb6bd060097
Step 3/5 : COPY ./package.json .
---> ba8a07e56a41
Step 4/5 : RUN npm install --quiet
---> Running in 28cdf5fa3f26
npm WARN deprecated superagent@8.1.2: Please upgrade to v9.0.0+ as we have fixed a public vulnerability with formidable dependency. Note that v9.0.0+ requires Node.js v14.18.0+. See https://github.com/ladjs/superagent/pull/1800 for insight. This project is supported and maintained by the team at Forward Email @ https://forwardemail.net
added 537 packages, and audited 538 packages in 2m
69 packages are looking for funding
run `npm fund` for details
found 0 vulnerabilities
npm notice
npm notice New minor version of npm available! 10.5.2 -> 10.7.0
npm notice Changelog: <https://github.com/npm/cli/releases/tag/v10.7.0>;
npm notice Run `npm install -g npm@10.7.0` to update!
npm notice
Removing intermediate container 28cdf5fa3f26
---> bcd0468688e6
Step 5/5 : COPY . .
---> ba70848be6e8
Successfully built ba70848be6e8
Successfully tagged chezgustave-main_server:latest
WARNING: Image for service server was built because it did not already exist. To rebuild this image you must use `docker-compose build` or `docker-compose up --build`.
Building client
Sending build context to Docker daemon 4.184MB
Step 1/5 : FROM node:lts
---> 1d3adb31a8ca
Step 2/5 : WORKDIR /usr/app
---> Using cache
---> 0bb6bd060097
Step 3/5 : COPY ./package.json .
---> 976c2411d67f
Step 4/5 : RUN npm install --quiet
---> Running in d29d64077845
added 446 packages, and audited 447 packages in 5m
131 packages are looking for funding
run `npm fund` for details
found 0 vulnerabilities
npm notice
npm notice New minor version of npm available! 10.5.2 -> 10.7.0
npm notice Changelog: <https://github.com/npm/cli/releases/tag/v10.7.0>;
npm notice Run `npm install -g npm@10.7.0` to update!
npm notice
Removing intermediate container d29d64077845
---> 4ada133a3f59
Step 5/5 : COPY . .
---> c46c936ebae3
Successfully built c46c936ebae3
Successfully tagged chezgustave-main_client:latest
WARNING: Image for service client was built because it did not already exist. To rebuild this image you must use `docker-compose build` or `docker-compose up --build`.
Pulling pgadmin (dpage/pgadmin4:)...
latest: Pulling from dpage/pgadmin4
4abcf2066143: Already exists
6fca87b61968: Pull complete
46712147a894: Pull complete
3bf015b2b4aa: Pull complete
c338222ce5f6: Pull complete
c296b6d7ed3e: Pull complete
4b22717c2693: Pull complete 4edd37ccd8cd: Pull complete
95eb7eda23b4: Pull complete
7011580d83bc: Pull complete
7b6590e68088: Pull complete
83cd4814ba13: Pull complete
ad209e34b1fd: Pull complete
177a34239293: Pull complete
d3469f86250a: Pull complete
bc2954fc5dbe: Pull complete
Digest: sha256:701f221dfc5da1fb3d4095ad4264ebb00ef4f7ecc6573007a49a59740019703d
Status: Downloaded newer image for dpage/pgadmin4:latest
Creating chezgustave-main_database_1 ... done
Creating chezgustave-main_pgadmin_1 ... done
ERROR: for server Container "39b2a68f1987" is unhealthy.
ERROR: Encountered errors while bringing up the project.Pour résoudre l'erreur du à une différence de version de Docker entre le projet original et la version docker du serveur Synology.
Cette commande a fonctionné !
sudo docker-compose up --build
J'ai mi le logs complets de Docker pour vous familiariser avec la longueur des execution des scripts Docker. Selon votre connexion Internet les actions euvent prendre du temps et dès fois on peut penser par erreur que c'est planté
admin@aphaena:/volume1/docker/TetianaChezGustave/ChezGustave-main$ sudo docker-compose up --build
Password:
Building server
Sending build context to Docker daemon 18.41MB
Step 1/5 : FROM node:lts
---> 1d3adb31a8ca
Step 2/5 : WORKDIR /usr/app
---> Using cache
---> 0bb6bd060097
Step 3/5 : COPY ./package.json .
---> Using cache
---> ba8a07e56a41
Step 4/5 : RUN npm install --quiet
---> Using cache
---> bcd0468688e6
Step 5/5 : COPY . .
---> Using cache
---> ba70848be6e8
Successfully built ba70848be6e8
Successfully tagged chezgustave-main_server:latest
Building client
Sending build context to Docker daemon 4.184MB
Step 1/5 : FROM node:lts
---> 1d3adb31a8ca
Step 2/5 : WORKDIR /usr/app
---> Using cache
---> 0bb6bd060097
Step 3/5 : COPY ./package.json .
---> Using cache
---> 976c2411d67f
Step 4/5 : RUN npm install --quiet
---> Using cache
---> 4ada133a3f59
Step 5/5 : COPY . .
---> Using cache
---> c46c936ebae3
Successfully built c46c936ebae3
Successfully tagged chezgustave-main_client:latest
chezgustave-main_database_1 is up-to-date
chezgustave-main_pgadmin_1 is up-to-date
Creating chezgustave-main_server_1 ... done
Creating chezgustave-main_client_1 ... done
Attaching to chezgustave-main_database_1, chezgustave-main_pgadmin_1, chezgustave-main_server_1, chezgustave-main_client_1
database_1 | The files belonging to this database system will be owned by user "postgres".
database_1 | This user must also own the server process.
database_1 |
database_1 | The database cluster will be initialized with locale "en_US.utf8".
database_1 | The default database encoding has accordingly been set to "UTF8".
database_1 | The default text search configuration will be set to "english".
database_1 |
database_1 | Data page checksums are disabled.
database_1 |
database_1 | fixing permissions on existing directory /var/lib/postgresql/data ... ok
database_1 | creating subdirectories ... ok
database_1 | selecting dynamic shared memory implementation ... posix
database_1 | selecting default max_connections ... 100
database_1 | selecting default shared_buffers ... 128MB
database_1 | selecting default time zone ... UTC
database_1 | creating configuration files ... ok
database_1 | running bootstrap script ... ok
database_1 | sh: locale: not found
database_1 | 2024-05-12 16:30:38.432 UTC [31] WARNING: no usable system locales were found
database_1 | performing post-bootstrap initialization ... ok
database_1 | syncing data to disk ... ok
database_1 |
database_1 |
database_1 | Success. You can now start the database server using:
database_1 |
database_1 | pg_ctl -D /var/lib/postgresql/data -l logfile start
database_1 |
database_1 | initdb: warning: enabling "trust" authentication for local connections
database_1 | initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
database_1 | waiting for server to start....2024-05-12 16:31:04.774 UTC [67] LOG: starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit
database_1 | 2024-05-12 16:31:04.864 UTC [67] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
database_1 | 2024-05-12 16:31:05.108 UTC [70] LOG: database system was shut down at 2024-05-12 16:30:39 UTC
database_1 | 2024-05-12 16:31:05.191 UTC [67] LOG: database system is ready to accept connections
database_1 | done
database_1 | server started
database_1 | CREATE DATABASE
database_1 |
database_1 |
database_1 | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
database_1 |
database_1 | waiting for server to shut down....2024-05-12 16:31:05.933 UTC [67] LOG: received fast shutdown request
database_1 | 2024-05-12 16:31:05.997 UTC [67] LOG: aborting any active transactions
database_1 | 2024-05-12 16:31:06.000 UTC [67] LOG: background worker "logical replication launcher" (PID 73) exited with exit code 1
database_1 | 2024-05-12 16:31:06.001 UTC [68] LOG: shutting down
database_1 | 2024-05-12 16:31:06.121 UTC [68] LOG: checkpoint starting: shutdown immediate
database_1 | ..2024-05-12 16:31:08.238 UTC [86] FATAL: the database system is shutting down
database_1 | 2024-05-12 16:31:08.861 UTC [68] LOG: checkpoint complete: wrote 924 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=2.120 s, total=2.860 s; sync files=301, longest=0.138 s, average=0.008 s; distance=4267 kB, estimate=4267 kB; lsn=0/191A9F8, redo lsn=0/191A9F8
database_1 | 2024-05-12 16:31:08.869 UTC [67] LOG: database system is shut down
database_1 | done
database_1 | server stopped
database_1 |
database_1 | PostgreSQL init process complete; ready for start up.
database_1 |
database_1 | 2024-05-12 16:31:09.121 UTC [1] LOG: starting PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20231014) 13.2.1 20231014, 64-bit
database_1 | 2024-05-12 16:31:09.121 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
database_1 | 2024-05-12 16:31:09.121 UTC [1] LOG: listening on IPv6 address "::", port 5432
database_1 | 2024-05-12 16:31:09.312 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
database_1 | 2024-05-12 16:31:09.490 UTC [90] LOG: database system was shut down at 2024-05-12 16:31:08 UTC
database_1 | 2024-05-12 16:31:09.582 UTC [1] LOG: database system is ready to accept connections
database_1 | 2024-05-12 16:36:09.590 UTC [88] LOG: checkpoint starting: time
database_1 | 2024-05-12 16:36:10.019 UTC [88] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.101 s, sync=0.134 s, total=0.430 s; sync files=3, longest=0.056 s, average=0.045 s; distance=0 kB, estimate=0 kB; lsn=0/191AAE0, redo lsn=0/191AAA8
server_1 |
server_1 | > chez-gustave@0.0.0 start
server_1 | > npm i && nodemon -L src/index.ts
server_1 |
pgadmin_1 | NOTE: Configuring authentication for SERVER mode.
pgadmin_1 |
pgadmin_1 | pgAdmin 4 - Application Initialisation
pgadmin_1 | ======================================
pgadmin_1 |
pgadmin_1 | postfix/postlog: starting the Postfix mail system
pgadmin_1 | [2024-05-12 16:32:44 +0000] [1] [INFO] Starting gunicorn 20.1.0
pgadmin_1 | [2024-05-12 16:32:44 +0000] [1] [INFO] Listening at: http://[::]:80 (1)
pgadmin_1 | [2024-05-12 16:32:44 +0000] [1] [INFO] Using worker: gthread
pgadmin_1 | [2024-05-12 16:32:44 +0000] [119] [INFO] Booting worker with pid: 119
client_1 |
client_1 | > chez-gustave@0.0.0 dev
client_1 | > vite --host
client_1 |
client_1 |
client_1 | VITE v5.2.11 ready in 343 ms
client_1 |
client_1 | ➜ Local: http://localhost:5173/
client_1 | ➜ Network: http://172.18.0.5:5173/
server_1 |
server_1 | added 40 packages, removed 11 packages, changed 77 packages, and audited 567 packages in 18s
server_1 |
server_1 | 68 packages are looking for funding
server_1 | run `npm fund` for details
server_1 |
server_1 | 2 moderate severity vulnerabilities
server_1 |
server_1 | To address all issues, run:
server_1 | npm audit fix
server_1 |
server_1 | Run `npm audit` for details.
server_1 | [nodemon] 3.0.3
server_1 | [nodemon] to restart at any time, enter `rs`
server_1 | [nodemon] watching path(s): *.*
server_1 | [nodemon] watching extensions: ts,json
server_1 | [nodemon] starting `ts-node src/index.ts`
server_1 | query: SELECT * FROM current_schema()
server_1 | query: SELECT version();
server_1 | query: START TRANSACTION
server_1 | query: SELECT * FROM current_schema()
server_1 | query: SELECT * FROM current_database()
server_1 | query: SELECT "table_schema", "table_name", obj_description(('"' || "table_schema" || '"."' || "table_name" || '"')::regclass, 'pg_class') AS table_comment FROM "information_schema"."tables" WHERE ("table_schema" = 'public' AND "table_name" = 'equipment') OR ("table_schema" = 'public' AND "table_name" = 'rating') OR ("table_schema" = 'public' AND "table_name" = 'housing') OR ("table_schema" = 'public' AND "table_name" = 'user') OR ("table_schema" = 'public' AND "table_name" = 'booking') OR ("table_schema" = 'public' AND "table_name" = 'cooptation') OR ("table_schema" = 'public' AND "table_name" = 'housing_equipments_equipment')
server_1 | query: SELECT * FROM "information_schema"."tables" WHERE "table_schema" = 'public' AND "table_name" = 'typeorm_metadata'
server_1 | query: CREATE TABLE "equipment" ("id" SERIAL NOT NULL, "name" character varying NOT NULL, CONSTRAINT "UQ_b44a87bec78c8cf13f5bb838577" UNIQUE ("name"), CONSTRAINT "PK_0722e1b9d6eb19f5874c1678740" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "rating" ("id" SERIAL NOT NULL, "rating" bigint NOT NULL, "comment" character varying NOT NULL, "housingId" integer, CONSTRAINT "PK_ecda8ad32645327e4765b43649e" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "housing" ("id" SERIAL NOT NULL, "name" character varying NOT NULL, "images_urls" json NOT NULL, "area" character varying NOT NULL, "description" character varying NOT NULL, "low_price" integer NOT NULL, "medium_price" integer NOT NULL, "high_price" integer NOT NULL, "surface" integer NOT NULL, "bedroom_count" smallint NOT NULL, "bathroom_count" smallint NOT NULL, "chef" character varying NOT NULL, "category" character varying NOT NULL, "type" character varying NOT NULL, CONSTRAINT "UQ_9341e466b856d627710e9131925" UNIQUE ("name"), CONSTRAINT "PK_fac21a104febb2697b71464c579" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "user" ("id" SERIAL NOT NULL, "first_name" character varying NOT NULL, "last_name" character varying NOT NULL, "password_hash" character varying NOT NULL, "email" character varying NOT NULL, "phone_number" character varying NOT NULL, "session_token" character varying, "session_token_expiration" TIMESTAMP, "admin" boolean, CONSTRAINT "UQ_62d3661cf61f7dc9f45b10724a1" UNIQUE ("password_hash"), CONSTRAINT "UQ_e12875dfb3b1d92d7d7c5377e22" UNIQUE ("email"), CONSTRAINT "UQ_01eea41349b6c9275aec646eee0" UNIQUE ("phone_number"), CONSTRAINT "PK_cace4a159ff9f2512dd42373760" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "booking" ("id" SERIAL NOT NULL, "start" TIMESTAMP NOT NULL, "end" TIMESTAMP NOT NULL, "chef_available" boolean NOT NULL, "visit_date" TIMESTAMP, "housingId" integer, "userId" integer, CONSTRAINT "PK_49171efc69702ed84c812f33540" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "cooptation" ("id" SERIAL NOT NULL, "token" character varying NOT NULL, "first_name" character varying NOT NULL, "last_name" character varying NOT NULL, "email" character varying NOT NULL, "phone_number" character varying NOT NULL, CONSTRAINT "UQ_af05dcd5d21c1492f5657a0af0d" UNIQUE ("email"), CONSTRAINT "UQ_3134166a1d4550f221ec8ef5c55" UNIQUE ("phone_number"), CONSTRAINT "PK_b28760b252d682a55e3d68659ae" PRIMARY KEY ("id"))
server_1 | query: CREATE TABLE "housing_equipments_equipment" ("housingId" integer NOT NULL, "equipmentId" integer NOT NULL, CONSTRAINT "PK_9acc014d9e2517d851743b4ad10" PRIMARY KEY ("housingId", "equipmentId"))
server_1 | query: CREATE INDEX "IDX_97d8760666611a4cb71900fcaa" ON "housing_equipments_equipment" ("housingId")
server_1 | query: CREATE INDEX "IDX_41c20d2d4524e1b1678f186cd0" ON "housing_equipments_equipment" ("equipmentId")
server_1 | query: ALTER TABLE "rating" ADD CONSTRAINT "FK_f8add0d91215cc352e135000ab3" FOREIGN KEY ("housingId") REFERENCES "housing"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
server_1 | query: ALTER TABLE "booking" ADD CONSTRAINT "FK_dd24138b1d4eeffe40b6a2a40ad" FOREIGN KEY ("housingId") REFERENCES "housing"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
server_1 | query: ALTER TABLE "booking" ADD CONSTRAINT "FK_336b3f4a235460dc93645fbf222" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE NO ACTION ON UPDATE NO ACTION
server_1 | query: ALTER TABLE "housing_equipments_equipment" ADD CONSTRAINT "FK_97d8760666611a4cb71900fcaa8" FOREIGN KEY ("housingId") REFERENCES "housing"("id") ON DELETE CASCADE ON UPDATE CASCADE
server_1 | query: ALTER TABLE "housing_equipments_equipment" ADD CONSTRAINT "FK_41c20d2d4524e1b1678f186cd0e" FOREIGN KEY ("equipmentId") REFERENCES "equipment"("id") ON DELETE CASCADE ON UPDATE CASCADE
server_1 | query: COMMIT
server_1 | Connected to database
server_1 | query: SELECT COUNT(1) AS "cnt" FROM "user" "User"
server_1 | TRUNCATE "equipment", "rating", "housing", "user", "booking", "cooptation", "housing_equipments_equipment" CASCADE;
server_1 | query: TRUNCATE "equipment", "rating", "housing", "user", "booking", "cooptation", "housing_equipments_equipment" CASCADE;
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Jacuzzi"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Jardin"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Parc de jeux"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Centre équestre"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Golf"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Bateau à voile"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Patinoire"]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: INSERT INTO "equipment"("name") VALUES ($1) RETURNING "id" -- PARAMETERS: ["Piste de Bobsleigh"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Nid de Chouette","[\"nid_de_chouette.jpg\"]","Gap","Se lever à l’aurore, aller chercher le soleil qui se lève sur les sommets",2000,4000,5000,200,8,3,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["La Galibe","[\"la_galibe.jpg\"]","Malestroit","Terre de Chouans!",3000,5000,8000,300,10,5,"Forfait sur mesure","Campagne","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Les Roches","[\"les_roches.jpg\"]","Les Sables d’Olonne","Bercée par les flots, cette villa vous promet des moments enchanteurs.",4000,6000,9000,400,6,2,"Forfait sur mesure","Bord de mer","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Maison des Rives","[\"maison_des_rives.jpg\"]","Sarlat","Au coeur du périgord noir, pour des vacances gastronomiques et sportives! Idéal pour les familles!",2000,4000,5000,190,6,3,"Forfait sur mesure","Campagne","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Les Cimes","[\"les_cimes.jpg\"]","Chambéry","Une vue révee sur les sommets, un spa de luxe caché dans ses murs, des balades équestres en montagne. Un lieu parfait pour se détendre",2000,4000,5000,200,8,4,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Les Landes","[\"les_landes.png\"]","Bazas","Notre chef local excelle dans la préparation du boeuf de Bazas",3000,5000,8000,300,10,5,"Forfait sur mesure","Campagne","Manoir"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Patinoire"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Snowbeach","[\"snowbeach.jpg\"]","Mégève","Pour les fans de glisse!!!",2000,4000,5000,200,8,4,"Forfait sur mesure","Montagne","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Yololoiou","[\"yololoiou.jpg\"]","Alpes suisses","Authentique! AU coeur des Alpes suisses,, avec un contact heureux avec le folklore local!",2000,4000,5000,200,8,4,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Lavande","[\"lavande.jpg\"]","Saint Paul de Vence","Cézanne y a vécu, pour y peindre l’Estaque",2000,4000,5000,190,6,3,"Forfait sur mesure","Campagne","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Les vents d’ouest","[\"les_vents_d_ouest.jpg\"]","Carnac","Une villa pour vous sentir riches...ou juste pour passer un moment délicieux en famille!",4000,6000,9000,400,15,10,"Forfait sur mesure","Bord de mer","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["La maison dans les bois","[\"la_maison_dans_les_bois.jpg\"]","Luz Saint Sauveur","Vous ne vous arrêterez pas ici, vous vous équiperez et partirez à l’assaut des cimes!",1500,2500,3500,110,4,2,"Forfait sur mesure","Ville","Atypique"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piste de Bobsleigh"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Guarrigue","[\"guarrigue.jpg\"]","Saint Maximin","Monter sur la Sainte Victoire et voir la mer, une fois dans sa vie! Savourer le beurre de truffe lors d’apéritifs trainants!",3000,5000,8000,300,10,5,"Forfait sur mesure","Campagne","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Patinoire"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Le Pic","[\"le_pic.jpg\"]","Gavarnie","Qui n’a jamais vu le cirque de Gavarnie n’a pas vécu!",2000,4000,5000,180,6,3,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["L’alpage","[\"l_alpage.jpg\"]","Voiron","La douceur des premières pentes, le repos de l’âme!",2000,4000,5000,200,7,4,"Forfait sur mesure","Montagne","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Berthe","[\"villa_berthe.jpg\"]","Granville","Son bateau à moteur dernier cri pour de superbes balades sur Chausey et Jersey",2000,4000,5000,190,6,3,"Forfait sur mesure","Campagne","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa des Pins","[\"villa_des_pins.jpg\"]","La Roche sur Yon","Cette maison, à deux pas de la plage, a vu passer Jean Rochefort, Lino Ventura, Gérard Depardieu. Tous la conseillent!",2000,4000,5000,200,7,4,"Forfait sur mesure","Bord de mer","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa les Murets","[\"villa_les_murets.jpg\"]","Rocamadour","Rocamadour, terre de miracles!",4000,6000,9000,400,12,8,"Forfait sur mesure","Campagne","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Sémaphore","[\"villa_semaphore.jpg\"]","Oléron","Le charme de l’authentique, l’appel de la mer",2000,4000,5000,180,6,3,"Forfait sur mesure","Bord de mer","Atypique"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Basque","[\"villa_basque.jpg\"]","Mimizan","Pour la Feria, à deux pas de Bayonne!",2000,4000,5000,200,7,4,"Forfait sur mesure","Bord de mer","Maison"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["La Cabane","[\"la_cabane.jpg\"]","Cahors","Un nid parfait pour renouveler votre amour!",1500,2500,3500,110,4,2,"Forfait sur mesure","Campagne","Atypique"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Vue sur Mer","[\"vue_sur_mer.jpg\"]","Dinard","So British!",1000,1500,2000,75,3,2,"Forfait sur mesure","Bord de mer","Appartement"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Trappeur","[\"villa_trappeur.jpeg\"]","Annecy","Vous sentez-vous prêts pour l’aventure? Programme proposé sur mesure",2000,4000,5000,200,7,3,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Patinoire"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piste de Bobsleigh"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["La Malouine","[\"la_malouine.jpg\"]","Saint Malo","Vous sentez-vous une âme d’armateur? Surcouf y est passé!",4000,6000,9000,380,14,8,"Forfait sur mesure","Bord de mer","Manoir"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Spa des Alpes","[\"spa_des_alpes.jpg\"]","Briançon","Se reposer, se détendre, profiter, aimer!!",2000,4000,5000,190,6,3,"Forfait sur mesure","Montagne","Chalet"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à moteur"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Bateau à voile"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de plongée."]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa des Vignes","[\"villa_des_vignes.jpg\"]","Blaye","Un verre de Saint Estèphe 1998, au coin du feu le soir ou sur la terrasse le midi, pendant que dorent les poissons sur la plancha....",2000,4000,5000,210,8,3,"Forfait sur mesure","Bord de mer","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Equipements de sports d'hiver"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Parc de jeux"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Margeride","[\"villa_margeride.jpg\"]","Saint Flour","Saint Flour, cité des grands vents! A visiter absolument! A deux pas des monts du Cantal et du GR400!",3000,5000,8000,300,16,8,"Forfait sur mesure","Montagne","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Buron des Cimes","[\"buron_des_cimes.jpg\"]","Serre-Chevalier","Le luxe au coeur des montagnes!",8000,11000,15000,600,20,20,"Forfait sur mesure","Montagne","Villa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Golf"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jacuzzi"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Piscine"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Belle époque","[\"belle_epoque.jpg\"]","Fontainebleau","Le faste des Rois. Joséphine de Beauharnais y a résidé",3000,5000,8000,270,10,6,"Forfait sur mesure","Ville","Manoir"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Centre équestre"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Jardin"]
server_1 | query: SELECT "Equipment"."id" AS "Equipment_id", "Equipment"."name" AS "Equipment_name" FROM "equipment" "Equipment" WHERE (("Equipment"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Tennis"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa Normande","[\"villa_normande.jpg\"]","Honfleur","Coup de coeur! ma famille y a vécu pendant trois générations, les murs ont une histoire!",3000,5000,8000,280,10,5,"Forfait sur mesure","Campagne","Villa"]
server_1 | query: INSERT INTO "housing"("name", "images_urls", "area", "description", "low_price", "medium_price", "high_price", "surface", "bedroom_count", "bathroom_count", "chef", "category", "type") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id" -- PARAMETERS: ["Villa des Puys","[\"villa_des_puys.jpg\"]","Chamaliéres","Clermont-Ferrand, cité des Volcans. Les puys à deux pas pour des balades enchanteresses! Vous profiterez aussi des thermes de Royat et Chatel Guyon, pour des vacances ressourçantes!",2000,4000,5000,200,7,4,"Forfait sur mesure","Ville","Manoir"]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["admin","admin","$2b$12$4qMp1JiGF0pwqvgOtLBs1e9JuzoZJ5vrev5iLo2z88fblZD5Ceu4S","admin","0123456789",1]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Louis","Le Cam","$2b$12$1x0CtDJe0Cxfs.nRAkd7hOijzazhAsy4qu10yY1VLh7Ir9ERrWgGG","louis.le-cam@institutsolacroup.com","0000000001",1]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Carl","Richard","$2b$12$H/OVZe9bR4kZSe1xZ2bwEeR50lonKMUL68SaAFxV9l75AfNJC3ohG","carl.richard@institutsolacroup.com","0000000002",0]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Tetiana","Kosorukova","$2b$12$r3hLPON23HgfDeaefpR5ueIbqCyqLS7lAUimqDJpotpRGO/HcOxsm","tetiana.kosorukova@institutsolacroup.com","0000000003",1]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Olivier","Evrard","$2b$12$998gZ6hAsS7VxGshS2iM4.r.5ONPk1iRT7M1IsFazuGLmW4rtwV16","olivier.evrard@institutsolacroup.com","0000000004",1]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Olivier","Robert Duboille","$2b$12$XGDY79TvGCVVhqnPdyccQu6/ffSVg2.Vif2MwdTry9Yib77OlzKoe","olivier.robert-duboille@institutsolacroup.com","0000000005",0]
server_1 | query: INSERT INTO "user"("first_name", "last_name", "password_hash", "email", "phone_number", "session_token", "session_token_expiration", "admin") VALUES ($1, $2, $3, $4, $5, DEFAULT, DEFAULT, $6) RETURNING "id" -- PARAMETERS: ["Dorian","Delpeux","$2b$12$RFAJXx3t6HT2YC2F6kR/muZNsm/1IW8SSv49sUaQSRj1Nmmi1lt0q","dorian.delpeux@institutsolacroup.com","0000000006",0]
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Maison des Rives"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2034-10-07T00:00:00.000Z","2034-10-12T00:00:00.000Z",1,"2034-10-02T00:00:00.000Z",4,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2048-07-12T00:00:00.000Z","2048-07-20T00:00:00.000Z",1,"2048-07-03T00:00:00.000Z",25,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Guarrigue"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2023-06-09T00:00:00.000Z","2023-06-13T00:00:00.000Z",0,"2023-06-06T00:00:00.000Z",12,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2025-04-10T00:00:00.000Z","2025-04-14T00:00:00.000Z",0,"2025-04-04T00:00:00.000Z",25,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Galibe"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2035-08-12T00:00:00.000Z","2035-08-18T00:00:00.000Z",1,"2035-08-04T00:00:00.000Z",2,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2025-05-18T00:00:00.000Z","2025-05-20T00:00:00.000Z",0,"2025-05-08T00:00:00.000Z",25,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Vue sur Mer"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2037-01-08T00:00:00.000Z","2037-01-11T00:00:00.000Z",1,"2037-01-04T00:00:00.000Z",21,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Cabane"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2044-03-13T00:00:00.000Z","2044-03-18T00:00:00.000Z",0,"2044-03-04T00:00:00.000Z",20,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Nid de Chouette"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2024-10-04T00:00:00.000Z","2024-10-09T00:00:00.000Z",0,"2024-10-01T00:00:00.000Z",1,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2041-10-09T00:00:00.000Z","2041-10-14T00:00:00.000Z",1,"2041-10-01T00:00:00.000Z",25,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Cabane"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2041-08-12T00:00:00.000Z","2041-08-20T00:00:00.000Z",1,"2041-08-06T00:00:00.000Z",20,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La maison dans les bois"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2038-09-14T00:00:00.000Z","2038-09-19T00:00:00.000Z",0,"2038-09-08T00:00:00.000Z",11,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Lavande"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2047-02-07T00:00:00.000Z","2047-02-15T00:00:00.000Z",0,"2047-02-04T00:00:00.000Z",9,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Cabane"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2040-05-07T00:00:00.000Z","2040-05-15T00:00:00.000Z",1,"2040-05-03T00:00:00.000Z",20,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Cabane"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2035-05-11T00:00:00.000Z","2035-05-15T00:00:00.000Z",1,"2035-05-02T00:00:00.000Z",20,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2044-12-17T00:00:00.000Z","2044-12-19T00:00:00.000Z",1,"2044-12-09T00:00:00.000Z",5,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Belle époque"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2025-02-15T00:00:00.000Z","2025-02-20T00:00:00.000Z",1,"2025-02-05T00:00:00.000Z",28,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Nid de Chouette"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2047-11-09T00:00:00.000Z","2047-11-17T00:00:00.000Z",0,"2047-11-01T00:00:00.000Z",1,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Landes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2027-03-19T00:00:00.000Z","2027-03-21T00:00:00.000Z",0,"2027-03-09T00:00:00.000Z",6,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Snowbeach"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2042-12-03T00:00:00.000Z","2042-12-10T00:00:00.000Z",1,"2042-12-02T00:00:00.000Z",7,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Pins"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2040-06-10T00:00:00.000Z","2040-06-13T00:00:00.000Z",0,"2040-06-07T00:00:00.000Z",16,2]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Landes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2027-08-09T00:00:00.000Z","2027-08-15T00:00:00.000Z",1,"2027-08-04T00:00:00.000Z",6,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Basque"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2043-07-05T00:00:00.000Z","2043-07-12T00:00:00.000Z",1,"2043-07-02T00:00:00.000Z",19,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2047-12-05T00:00:00.000Z","2047-12-07T00:00:00.000Z",0,"2047-12-04T00:00:00.000Z",5,2]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Puys"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2026-08-08T00:00:00.000Z","2026-08-16T00:00:00.000Z",0,"2026-08-07T00:00:00.000Z",30,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2046-10-09T00:00:00.000Z","2046-10-15T00:00:00.000Z",0,"2046-10-06T00:00:00.000Z",25,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Buron des Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2028-10-08T00:00:00.000Z","2028-10-11T00:00:00.000Z",0,"2028-10-05T00:00:00.000Z",27,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Normande"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2036-06-16T00:00:00.000Z","2036-06-23T00:00:00.000Z",0,"2036-06-07T00:00:00.000Z",29,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Margeride"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2037-09-07T00:00:00.000Z","2037-09-11T00:00:00.000Z",0,"2037-09-06T00:00:00.000Z",26,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Normande"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2045-09-14T00:00:00.000Z","2045-09-17T00:00:00.000Z",0,"2045-09-10T00:00:00.000Z",29,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Vue sur Mer"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2032-04-09T00:00:00.000Z","2032-04-12T00:00:00.000Z",0,"2032-04-04T00:00:00.000Z",21,2]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Berthe"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2025-04-10T00:00:00.000Z","2025-04-14T00:00:00.000Z",0,"2025-04-02T00:00:00.000Z",15,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Galibe"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2026-05-10T00:00:00.000Z","2026-05-14T00:00:00.000Z",1,"2026-05-03T00:00:00.000Z",2,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2035-09-06T00:00:00.000Z","2035-09-14T00:00:00.000Z",1,"2035-09-04T00:00:00.000Z",5,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa les Murets"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2045-04-15T00:00:00.000Z","2045-04-18T00:00:00.000Z",0,"2045-04-06T00:00:00.000Z",17,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Normande"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2044-02-11T00:00:00.000Z","2044-02-18T00:00:00.000Z",0,"2044-02-04T00:00:00.000Z",29,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Buron des Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2044-08-14T00:00:00.000Z","2044-08-20T00:00:00.000Z",1,"2044-08-08T00:00:00.000Z",27,2]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Landes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2026-02-03T00:00:00.000Z","2026-02-11T00:00:00.000Z",0,"2026-02-02T00:00:00.000Z",6,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa les Murets"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2036-11-08T00:00:00.000Z","2036-11-13T00:00:00.000Z",1,"2036-11-03T00:00:00.000Z",17,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Puys"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2041-01-11T00:00:00.000Z","2041-01-14T00:00:00.000Z",0,"2041-01-09T00:00:00.000Z",30,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa Berthe"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.evrard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2039-06-15T00:00:00.000Z","2039-06-19T00:00:00.000Z",0,"2039-06-08T00:00:00.000Z",15,5]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Buron des Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["carl.richard@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2023-04-16T00:00:00.000Z","2023-04-19T00:00:00.000Z",0,"2023-04-10T00:00:00.000Z",27,3]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Spa des Alpes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["admin"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2032-07-14T00:00:00.000Z","2032-07-22T00:00:00.000Z",0,"2032-07-05T00:00:00.000Z",24,1]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Vignes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2023-01-18T00:00:00.000Z","2023-01-20T00:00:00.000Z",0,"2023-01-09T00:00:00.000Z",25,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Buron des Cimes"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["dorian.delpeux@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2041-06-09T00:00:00.000Z","2041-06-13T00:00:00.000Z",0,"2041-06-04T00:00:00.000Z",27,7]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Yololoiou"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2036-11-05T00:00:00.000Z","2036-11-07T00:00:00.000Z",1,"2036-11-04T00:00:00.000Z",8,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Les Roches"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["tetiana.kosorukova@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2037-02-04T00:00:00.000Z","2037-02-07T00:00:00.000Z",1,"2037-02-03T00:00:00.000Z",3,4]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["La Malouine"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["olivier.robert-duboille@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2044-02-11T00:00:00.000Z","2044-02-15T00:00:00.000Z",0,"2044-02-02T00:00:00.000Z",23,6]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Villa des Puys"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2028-04-09T00:00:00.000Z","2028-04-16T00:00:00.000Z",1,"2028-04-06T00:00:00.000Z",30,2]
server_1 | query: COMMIT
server_1 | query: SELECT "Housing"."id" AS "Housing_id", "Housing"."name" AS "Housing_name", "Housing"."images_urls" AS "Housing_images_urls", "Housing"."area" AS "Housing_area", "Housing"."description" AS "Housing_description", "Housing"."low_price" AS "Housing_low_price", "Housing"."medium_price" AS "Housing_medium_price", "Housing"."high_price" AS "Housing_high_price", "Housing"."surface" AS "Housing_surface", "Housing"."bedroom_count" AS "Housing_bedroom_count", "Housing"."bathroom_count" AS "Housing_bathroom_count", "Housing"."chef" AS "Housing_chef", "Housing"."category" AS "Housing_category", "Housing"."type" AS "Housing_type" FROM "housing" "Housing" WHERE (("Housing"."name" = $1)) LIMIT 1 -- PARAMETERS: ["Maison des Rives"]
server_1 | query: SELECT "User"."id" AS "User_id", "User"."first_name" AS "User_first_name", "User"."last_name" AS "User_last_name", "User"."password_hash" AS "User_password_hash", "User"."email" AS "User_email", "User"."phone_number" AS "User_phone_number", "User"."session_token" AS "User_session_token", "User"."session_token_expiration" AS "User_session_token_expiration", "User"."admin" AS "User_admin" FROM "user" "User" WHERE (("User"."email" = $1)) LIMIT 1 -- PARAMETERS: ["louis.le-cam@institutsolacroup.com"]
server_1 | query: START TRANSACTION
server_1 | query: INSERT INTO "booking"("start", "end", "chef_available", "visit_date", "housingId", "userId") VALUES ($1, $2, $3, $4, $5, $6) RETURNING "id" -- PARAMETERS: ["2035-08-05T00:00:00.000Z","2035-08-07T00:00:00.000Z",1,"2035-08-01T00:00:00.000Z",4,2]
server_1 | query: COMMIT
server_1 | Server listening on 3630
database_1 | 2024-05-12 16:51:09.286 UTC [88] LOG: checkpoint starting: time
database_1 | 2024-05-12 16:51:20.988 UTC [88] LOG: checkpoint complete: wrote 111 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.049 s, sync=0.313 s, total=11.702 s; sync files=114, longest=0.088 s, average=0.003 s; distance=437 kB, estimate=437 kB; lsn=0/1988298, redo lsn=0/1988260
client_loop: send disconnect: Connection reset
Dans l'interface Docker du Synology vous devriez voir ceci
Récapitutlatif du du container du client de l'application.
On peut voir que le client est accessible sur le port 5173 du serveur Synology.
Ce n'est encore terminé !
Pour accéder depuis Internet il reste à configurer le routeur d'accès à Internet pour que le port 5173 soit routé vers l'adresse IP du serveur Synology.
Pour l'instant votre application n'est accessible que sur votre réseau local.
Dans le cas de ma configuration le routeur est une Freebox qu'il va falloir configurer.
Dans le cas d'une Freebox ona ccède au panneau de configuation de la Freebox sur un réseau local par cette adresse
http://mafreebox.freebox.fr/
Sur cette capture d'écran vous pouvez voir que les ports 22 et 5173 ont été ajoutés pour être rediriger. Vous pourriez tout à fait changer la configuration pour redirigé le port 80 vers le port 5173 pour avoir un accès direct par le port standard de http.
Le port 22 est utile pour que ssh soit accéssible sur le serveur Synology depuis n'importe où sur Internet. (En règle générale , je préfère ne pas exposé ce port pour éviter les tentatives d'intrusions
En principe, si tout est bien configuré vous pouvez maintenant accéder à votre application Docker.
Sit par le nom de domaine de la freebox. Danas ce cas http:aphaena.freeboxos.fr:5173
Soit par l'adresse ip de la Freebox, ici 82.66.123.165:5173
Et voilà (enfin...) !
Modifié le: lundi 13 mai 2024, 08:53