From ca677900b028ac92e5b37fa611a8ad3bea80cfeb Mon Sep 17 00:00:00 2001 From: Chris H Date: Tue, 24 Feb 2026 10:13:59 +0100 Subject: [PATCH] chore: move project under Wallette root folder --- .gitignore | 4 ++ ...-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md | 0 .../Doc/sh\303\251maGIT.png" | Bin {server => Wallette}/config/db.js | 0 {server => Wallette/server}/.env.example | 0 {server => Wallette/server}/.gitignore | 0 .../server}/EXAMPLE-other-project.js | 0 {server => Wallette/server}/app.js | 0 Wallette/server/config/db.js | 62 ++++++++++++++++++ .../modules/alerts/adapters/mysql.adapter.js | 0 .../modules/alerts/alerts.controller.js | 0 .../server}/modules/alerts/alerts.repo.js | 0 .../server}/modules/alerts/alerts.router.js | 0 .../server}/modules/alerts/alerts.service.js | 0 .../modules/alerts/channels/console.js | 0 .../modules/alerts/channels/discord.js | 0 .../server}/modules/alerts/channels/mailer.js | 0 .../modules/alerts/channels/telegram.js | 0 .../server}/modules/alerts/channels/web.js | 0 .../server}/modules/alerts/index.js | 0 .../server}/modules/alerts/socketManager.js | 0 .../server}/modules/alerts/test-alerts.js | 0 .../server}/modules/init-alerts.js | 0 .../server/modules/price}/app.js | 0 .../server/modules/price}/db.js | 0 .../server/modules/price}/public/index.html | 0 .../price}/repositories/pair.repository.js | 0 .../price}/repositories/price.repository.js | 0 .../server/modules/price}/server.js | 0 .../price}/services/binance.service.js | 0 .../price}/services/coingecko.service.js | 0 .../modules/price}/services/price.service.js | 0 .../server/modules/price}/test-db.js | 0 {server => Wallette/server}/package-lock.json | 0 {server => Wallette/server}/package.json | 0 {server => Wallette/server}/test-alerts.js | 0 .../server}/test-module-complet.js | 0 .../server}/test-server-socket.js | 0 {server => Wallette/server}/test-server.js | 0 39 files changed, 66 insertions(+) create mode 100644 .gitignore rename {server => Wallette/Doc}/DOC-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md (100%) rename "sh\303\251maGIT.png" => "Wallette/Doc/sh\303\251maGIT.png" (100%) rename {server => Wallette}/config/db.js (100%) rename {server => Wallette/server}/.env.example (100%) rename {server => Wallette/server}/.gitignore (100%) rename {server => Wallette/server}/EXAMPLE-other-project.js (100%) rename {server => Wallette/server}/app.js (100%) create mode 100644 Wallette/server/config/db.js rename {server => Wallette/server}/modules/alerts/adapters/mysql.adapter.js (100%) rename {server => Wallette/server}/modules/alerts/alerts.controller.js (100%) rename {server => Wallette/server}/modules/alerts/alerts.repo.js (100%) rename {server => Wallette/server}/modules/alerts/alerts.router.js (100%) rename {server => Wallette/server}/modules/alerts/alerts.service.js (100%) rename {server => Wallette/server}/modules/alerts/channels/console.js (100%) rename {server => Wallette/server}/modules/alerts/channels/discord.js (100%) rename {server => Wallette/server}/modules/alerts/channels/mailer.js (100%) rename {server => Wallette/server}/modules/alerts/channels/telegram.js (100%) rename {server => Wallette/server}/modules/alerts/channels/web.js (100%) rename {server => Wallette/server}/modules/alerts/index.js (100%) rename {server => Wallette/server}/modules/alerts/socketManager.js (100%) rename {server => Wallette/server}/modules/alerts/test-alerts.js (100%) rename {server => Wallette/server}/modules/init-alerts.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/app.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/db.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/public/index.html (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/repositories/pair.repository.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/repositories/price.repository.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/server.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/services/binance.service.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/services/coingecko.service.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/services/price.service.js (100%) rename {server/Val_Crypto => Wallette/server/modules/price}/test-db.js (100%) rename {server => Wallette/server}/package-lock.json (100%) rename {server => Wallette/server}/package.json (100%) rename {server => Wallette/server}/test-alerts.js (100%) rename {server => Wallette/server}/test-module-complet.js (100%) rename {server => Wallette/server}/test-server-socket.js (100%) rename {server => Wallette/server}/test-server.js (100%) diff --git a/.gitignore b/.gitignore new file mode 100644 index 0000000..41cc999 --- /dev/null +++ b/.gitignore @@ -0,0 +1,4 @@ +_Old/ +_Old/ +node_modules/ +.env diff --git a/server/DOC-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md b/Wallette/Doc/DOC-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md similarity index 100% rename from server/DOC-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md rename to Wallette/Doc/DOC-FRONTEND-SOCKET_POUR_OCEANE_ET_THIBAUD.md diff --git "a/sh\303\251maGIT.png" "b/Wallette/Doc/sh\303\251maGIT.png" similarity index 100% rename from "sh\303\251maGIT.png" rename to "Wallette/Doc/sh\303\251maGIT.png" diff --git a/server/config/db.js b/Wallette/config/db.js similarity index 100% rename from server/config/db.js rename to Wallette/config/db.js diff --git a/server/.env.example b/Wallette/server/.env.example similarity index 100% rename from server/.env.example rename to Wallette/server/.env.example diff --git a/server/.gitignore b/Wallette/server/.gitignore similarity index 100% rename from server/.gitignore rename to Wallette/server/.gitignore diff --git a/server/EXAMPLE-other-project.js b/Wallette/server/EXAMPLE-other-project.js similarity index 100% rename from server/EXAMPLE-other-project.js rename to Wallette/server/EXAMPLE-other-project.js diff --git a/server/app.js b/Wallette/server/app.js similarity index 100% rename from server/app.js rename to Wallette/server/app.js diff --git a/Wallette/server/config/db.js b/Wallette/server/config/db.js new file mode 100644 index 0000000..a9bbc9f --- /dev/null +++ b/Wallette/server/config/db.js @@ -0,0 +1,62 @@ +// ========================================================= +// CONFIGURATION DE LA BASE DE DONNÉES +// ========================================================= +// crée une connexion réutilisable à MySQL/MariaDB +// utilise un "pool" de connexions +// ========================================================= + +import dotenv from 'dotenv'; +import mysql from 'mysql2/promise'; +import path from 'path'; +import { fileURLToPath } from 'url'; + +// ========================================================= +// CONFIGURATION DU CHEMIN +// ========================================================= +// créer le filename avec fileURLToPath +const __filename = fileURLToPath(import.meta.url); +const __dirname = path.dirname(__filename); + +// ========================================================= +// CHARGEMENT DES VARIABLES D'ENVIRONNEMENT +// ========================================================= +// charge .env qui contient les credits DB +// .env doit être à la racine du dossier server/ +dotenv.config({ path: path.resolve(__dirname, '../.env') }); + +// ========================================================= +// CRÉATION DU POOL DE CONNEXIONS +// ========================================================= +// Un pool = plusieurs connexions réutilisables +const db = mysql.createPool({ + host: process.env.DB_HOST || 'localhost', + port: process.env.DB_PORT || 33020, + user: process.env.DB_USER, + password: process.env.DB_PASS, + database: process.env.DB_NAME || 'wallete', + + // Paramètres du pool + waitForConnections: true, // Attend si toutes les connexions sont occupées + connectionLimit: 10, // Max 10 connexions simultanées + queueLimit: 0 // Pas de limite de file d'attente +}); + +// ========================================================= +// TEST DE CONNEXION +// ========================================================= +// Vérifie au démarrage que la DB est accessible +db.getConnection() + .then(connection => { + console.log('Connexion à la base de données réussie'); + connection.release(); // Libère la connexion dans le pool + }) + .catch(err => { + console.error('Erreur de connexion à la base de données:', err.message); + console.error('Vérifie ton fichier .env !'); + }); + +// ========================================================= +// EXPORT +// ========================================================= +// On exporte le pool pour l'utiliser dans les repositories +export default db; diff --git a/server/modules/alerts/adapters/mysql.adapter.js b/Wallette/server/modules/alerts/adapters/mysql.adapter.js similarity index 100% rename from server/modules/alerts/adapters/mysql.adapter.js rename to Wallette/server/modules/alerts/adapters/mysql.adapter.js diff --git a/server/modules/alerts/alerts.controller.js b/Wallette/server/modules/alerts/alerts.controller.js similarity index 100% rename from server/modules/alerts/alerts.controller.js rename to Wallette/server/modules/alerts/alerts.controller.js diff --git a/server/modules/alerts/alerts.repo.js b/Wallette/server/modules/alerts/alerts.repo.js similarity index 100% rename from server/modules/alerts/alerts.repo.js rename to Wallette/server/modules/alerts/alerts.repo.js diff --git a/server/modules/alerts/alerts.router.js b/Wallette/server/modules/alerts/alerts.router.js similarity index 100% rename from server/modules/alerts/alerts.router.js rename to Wallette/server/modules/alerts/alerts.router.js diff --git a/server/modules/alerts/alerts.service.js b/Wallette/server/modules/alerts/alerts.service.js similarity index 100% rename from server/modules/alerts/alerts.service.js rename to Wallette/server/modules/alerts/alerts.service.js diff --git a/server/modules/alerts/channels/console.js b/Wallette/server/modules/alerts/channels/console.js similarity index 100% rename from server/modules/alerts/channels/console.js rename to Wallette/server/modules/alerts/channels/console.js diff --git a/server/modules/alerts/channels/discord.js b/Wallette/server/modules/alerts/channels/discord.js similarity index 100% rename from server/modules/alerts/channels/discord.js rename to Wallette/server/modules/alerts/channels/discord.js diff --git a/server/modules/alerts/channels/mailer.js b/Wallette/server/modules/alerts/channels/mailer.js similarity index 100% rename from server/modules/alerts/channels/mailer.js rename to Wallette/server/modules/alerts/channels/mailer.js diff --git a/server/modules/alerts/channels/telegram.js b/Wallette/server/modules/alerts/channels/telegram.js similarity index 100% rename from server/modules/alerts/channels/telegram.js rename to Wallette/server/modules/alerts/channels/telegram.js diff --git a/server/modules/alerts/channels/web.js b/Wallette/server/modules/alerts/channels/web.js similarity index 100% rename from server/modules/alerts/channels/web.js rename to Wallette/server/modules/alerts/channels/web.js diff --git a/server/modules/alerts/index.js b/Wallette/server/modules/alerts/index.js similarity index 100% rename from server/modules/alerts/index.js rename to Wallette/server/modules/alerts/index.js diff --git a/server/modules/alerts/socketManager.js b/Wallette/server/modules/alerts/socketManager.js similarity index 100% rename from server/modules/alerts/socketManager.js rename to Wallette/server/modules/alerts/socketManager.js diff --git a/server/modules/alerts/test-alerts.js b/Wallette/server/modules/alerts/test-alerts.js similarity index 100% rename from server/modules/alerts/test-alerts.js rename to Wallette/server/modules/alerts/test-alerts.js diff --git a/server/modules/init-alerts.js b/Wallette/server/modules/init-alerts.js similarity index 100% rename from server/modules/init-alerts.js rename to Wallette/server/modules/init-alerts.js diff --git a/server/Val_Crypto/app.js b/Wallette/server/modules/price/app.js similarity index 100% rename from server/Val_Crypto/app.js rename to Wallette/server/modules/price/app.js diff --git a/server/Val_Crypto/db.js b/Wallette/server/modules/price/db.js similarity index 100% rename from server/Val_Crypto/db.js rename to Wallette/server/modules/price/db.js diff --git a/server/Val_Crypto/public/index.html b/Wallette/server/modules/price/public/index.html similarity index 100% rename from server/Val_Crypto/public/index.html rename to Wallette/server/modules/price/public/index.html diff --git a/server/Val_Crypto/repositories/pair.repository.js b/Wallette/server/modules/price/repositories/pair.repository.js similarity index 100% rename from server/Val_Crypto/repositories/pair.repository.js rename to Wallette/server/modules/price/repositories/pair.repository.js diff --git a/server/Val_Crypto/repositories/price.repository.js b/Wallette/server/modules/price/repositories/price.repository.js similarity index 100% rename from server/Val_Crypto/repositories/price.repository.js rename to Wallette/server/modules/price/repositories/price.repository.js diff --git a/server/Val_Crypto/server.js b/Wallette/server/modules/price/server.js similarity index 100% rename from server/Val_Crypto/server.js rename to Wallette/server/modules/price/server.js diff --git a/server/Val_Crypto/services/binance.service.js b/Wallette/server/modules/price/services/binance.service.js similarity index 100% rename from server/Val_Crypto/services/binance.service.js rename to Wallette/server/modules/price/services/binance.service.js diff --git a/server/Val_Crypto/services/coingecko.service.js b/Wallette/server/modules/price/services/coingecko.service.js similarity index 100% rename from server/Val_Crypto/services/coingecko.service.js rename to Wallette/server/modules/price/services/coingecko.service.js diff --git a/server/Val_Crypto/services/price.service.js b/Wallette/server/modules/price/services/price.service.js similarity index 100% rename from server/Val_Crypto/services/price.service.js rename to Wallette/server/modules/price/services/price.service.js diff --git a/server/Val_Crypto/test-db.js b/Wallette/server/modules/price/test-db.js similarity index 100% rename from server/Val_Crypto/test-db.js rename to Wallette/server/modules/price/test-db.js diff --git a/server/package-lock.json b/Wallette/server/package-lock.json similarity index 100% rename from server/package-lock.json rename to Wallette/server/package-lock.json diff --git a/server/package.json b/Wallette/server/package.json similarity index 100% rename from server/package.json rename to Wallette/server/package.json diff --git a/server/test-alerts.js b/Wallette/server/test-alerts.js similarity index 100% rename from server/test-alerts.js rename to Wallette/server/test-alerts.js diff --git a/server/test-module-complet.js b/Wallette/server/test-module-complet.js similarity index 100% rename from server/test-module-complet.js rename to Wallette/server/test-module-complet.js diff --git a/server/test-server-socket.js b/Wallette/server/test-server-socket.js similarity index 100% rename from server/test-server-socket.js rename to Wallette/server/test-server-socket.js diff --git a/server/test-server.js b/Wallette/server/test-server.js similarity index 100% rename from server/test-server.js rename to Wallette/server/test-server.js -- 2.50.1