Spaces:
Sleeping
Sleeping
File size: 1,450 Bytes
525d39f | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | import { DataSource } from 'typeorm';
import { config } from 'dotenv';
// Load environment variables
config();
const dbType = process.env.DATABASE_TYPE || 'sqlite';
// SQLite configuration
const sqliteDataSource = new DataSource({
type: 'sqlite',
database: process.env.DATABASE_NAME || './data/openwa.sqlite',
entities: [__dirname + '/../**/*.entity{.ts,.js}'],
migrations: [__dirname + '/migrations/*{.ts,.js}'],
synchronize: false,
logging: process.env.DATABASE_LOGGING === 'true',
});
// PostgreSQL configuration
const postgresDataSource = new DataSource({
type: 'postgres',
host: process.env.DATABASE_HOST || 'localhost',
port: parseInt(process.env.DATABASE_PORT || '5432', 10),
username: process.env.DATABASE_USERNAME,
password: process.env.DATABASE_PASSWORD,
database: process.env.DATABASE_NAME || 'openwa',
entities: [__dirname + '/../**/*.entity{.ts,.js}'],
migrations: [__dirname + '/migrations/*{.ts,.js}'],
synchronize: false, // Never auto-sync in production
logging: process.env.DATABASE_LOGGING === 'true',
ssl:
process.env.DATABASE_SSL === 'true'
? {
rejectUnauthorized: process.env.DATABASE_SSL_REJECT_UNAUTHORIZED !== 'false',
}
: false,
extra: {
max: parseInt(process.env.DATABASE_POOL_SIZE || '10', 10),
},
});
// Export the appropriate data source based on DATABASE_TYPE
export default dbType === 'postgres' ? postgresDataSource : sqliteDataSource;
|