ios-api/src/config/database.ts

import { DataSource } from 'typeorm'
import { FastifyInstance } from 'fastify'

export const createDataSource = (app: FastifyInstance) => {
  return new DataSource({
    type: 'mysql',
    host: app.config.DB_HOST,
    port: parseInt((app.config.DB_PORT as string) || '3306'),
    username: app.config.DB_USERNAME,
    password: app.config.DB_PASSWORD,
    database: app.config.DB_DATABASE,
    synchronize: true,
    logging: false,
    entities: ['src/entities/*.entity.{ts,js}', 'entities/*.entity.{ts,js}'],
    migrations: ['src/migrations/**/*.js'],
    subscribers: ['src/subscribers/**/*.js']
  })
}