import 'dotenv/config';
import { DataSource } from 'typeorm';
import { Word } from './words/entities/word.entity';
import { Definition } from './words/entities/definition.entity';
import { User } from './auth/entities/user.entity';

export const AppDataSource = new DataSource({
  type: 'mysql',
  host: process.env.DB_HOST ?? 'localhost',
  port: Number(process.env.DB_PORT ?? 3306),
  username: process.env.DB_USER ?? 'lexibrain',
  password: process.env.DB_PASSWORD ?? 'lexibrain',
  database: process.env.DB_NAME ?? 'lexibrain',
  entities: [Word, Definition, User],
  synchronize: false,
  migrations: ['src/migrations/*.ts'],
  migrationsTableName: 'migrations',
});