fix(backend:database): ensure MySQL connection uses UTC timezone

johaven · johaven · commit e7d2ed9d2a09 · 2026-02-26T00:04:23.000+01:00
diff --git a/backend/src/infrastructure/database/database.module.ts b/backend/src/infrastructure/database/database.module.ts
@@ -1,6 +1,7 @@
 import { DrizzleMySqlConfig, DrizzleMySqlModule } from '@knaadh/nestjs-drizzle-mysql2'
-import { BeforeApplicationShutdown, Global, Inject, Module } from '@nestjs/common'
+import { BeforeApplicationShutdown, Global, Inject, Module, OnModuleInit } from '@nestjs/common'
 import { MySql2Client } from 'drizzle-orm/mysql2'
+import { Connection, Pool } from 'mysql2'
 import { configuration } from '../../configuration/config.environment'
 import { DB_TOKEN_PROVIDER } from './constants'
 import { DatabaseLogger } from './database.logger'
@@ -26,9 +27,17 @@ import * as schema from './schema'
     })
   ]
 })
-export class DatabaseModule implements BeforeApplicationShutdown {
+export class DatabaseModule implements OnModuleInit, BeforeApplicationShutdown {
   constructor(@Inject(DB_TOKEN_PROVIDER) private readonly db: DBSchema & { session: { client: MySql2Client } }) {}
 
+  onModuleInit() {
+    const pool: Pool = (this.db as any).$client
+    pool.on('connection', (conn: Connection) => {
+      // Force UTC timezone for every new MySQL connection.
+      conn.query(`SET time_zone = '+00:00'`)
+    })
+  }
+
   async beforeApplicationShutdown() {
     await this.db.session.client.end()
   }
