MaaBackend/src/database/config/config.ts

require('dotenv').config();

// module.exports = {
//     development: {
//         port: Number(process.env.DB_PORT),
//         database: process.env.DB_DATABASE,
//         username: process.env.DB_USERNAME,
//         password: process.env.DB_PASSWORD,
//         host: process.env.DB_HOST,
//         dialect: 'mariadb',
//     }
// };

// module.exports = {
//     development: {
//         port: Number(process.env.DB_PORT),
//         database: process.env.DB_DATABASE,
//         username: process.env.DB_USERNAME,
//         password: process.env.DB_PASSWORD,
//         host: process.env.DB_HOST,
//         dialect: 'mssql',
//     }
// };

module.exports = {
    development: {
        server: process.env.DB_HOST,
        authentication: {
            type: 'default',
            options: {
                userName: process.env.DB_USERNAME, // update me
                password: process.env.DB_PASSWORD // update me
            }
        },
        options: {
            database: process.env.DB_DATABASE
        },
        dialect: 'mssql',
    }
};

// module.exports = {
//     development: {
//         "dialect": "mssql",
//         "dialectModulePath": "sequelize-msnodesqlv8",
//         "dialectOptions": {
//             "driver": "SQL Server Native Client 11.0",
//             "trustedConnection": "true"
//         },
//         "username": process.env.DB_USERNAME,
//         "password": process.env.DB_PASSWORD,
//         "database": "ILert",
//         "host": process.env.DB_HOST,
//         "port": 1433,
//         "logging": "true"
//       }
// };