data-source.ts

import { DataSource } from 'typeorm';
import * as dotenv from 'dotenv';
import * as path from 'path';

dotenv.config({
    path: path.resolve(__dirname, '../../.env'),
});

export const AppDataSource = new DataSource({
    type: 'postgres',
    host: process.env.DB_HOST || 'localhost',
    port: parseInt(process.env.DB_PORT || '5432', 10),
    username: process.env.DB_USERNAME || 'postgres',
    password: process.env.DB_PASSWORD || 'postgres',
    database: process.env.DB_NAME || 'stellarsplit_dev',
    entities: [path.join(__dirname, '../**/*.entity{.ts,.js}')],
    migrations: [
        path.join(__dirname, 'migrations/*{.ts,.js}'),
        path.join(__dirname, '../migrations/*{.ts,.js}'),
    ],
    synchronize: false, // Should be false for migrations
    logging: true,
});