<?php

return [

    'default' => env('DB_CONNECTION', 'pgsql'),
    'connections' => [
        'pgsql' => [
            'driver' => 'pgsql',
            'host' => env('DB_HOST', '20.212.164.54'),
            'port' => env('DB_PORT', '5432'),
            'database' => env('DB_DATABASE', 'masterservicedb'),
            'username' => env('DB_USERNAME', 'postgres'),
            'password' => env('DB_PASSWORD', 'waycoolmaster@123'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB2_HOST', '13.76.221.197'),
            'port' => env('DB2_PORT', '3306'),
            'database' => env('DB2_DATABASE', 'uat_waycool_sap'),
            'username' => env('DB2_USERNAME', 'tolkien'),
            'password' => env('DB2_PASSWORD', 'Waycool@Pragati2019'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => false
        ],

        'rapid_mysql' => [
            'driver' => 'mysql',
            'host' => env('DB4_HOST', '52.163.82.168'),
            'port' => env('DB4_PORT', '3306'),
            'database' => env('DB4_DATABASE', 'onewaycool_rapid_db_live'),
            'username' => env('DB4_USERNAME', 'owc_uat_user'),
            'password' => env('DB4_PASSWORD', 'TR!PiRgc(PB1'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'rapid_sqlsrv' => [
            'driver' => 'sqlsrv',
            'host' => env('DB5_HOST', '210.18.152.28'),
            'port' => env('DB5_PORT', '1433'),
            'database' => env('DB5_DATABASE', 'WayCool_SAP_RAPID_DB_UAT'),
            'username' => env('DB5_USERNAME', 'sa'),
            'password' => env('DB5_PASSWORD', 'sa123'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'Traveldb' => [
            'driver' => 'mysql',
            'host' => env('DB17_HOST', '137.116.142.225'),
            'port' => env('DB17_PORT', '3306'),
            'database' => env('DB17_DATABASE', 'SAC_DMS'),
            'username' => env('DB17_USERNAME', 'traveluser'),
            'password' => env('DB17_PASSWORD', 'Traveldb@123'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => false
        ],

        'Traveldb_SAC_Myprice' => [
            'driver' => 'mysql',
            'host' => env('DB18_HOST', '137.116.142.225'),
            'port' => env('DB18_PORT', '3306'),
            'database' => env('DB18_DATABASE', 'SAC_Myprice'),
            'username' => env('DB18_USERNAME', 'traveluser'),
            'password' => env('DB18_PASSWORD', 'Traveldb@123'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => false
        ],

        'mongodb' => [
            'driver' => 'mongodb',
            'host' => env('DB3_HOST', '207.46.236.69'),
            'port' => env('DB3_PORT', '27017'),
            'database' => env('DB3_DATABASE', 'dms'),
            'username' => env('DB3_USERNAME', 'AdminSammy'),
            'password' => env('DB3_PASSWORD', 'wxFQ^mqlE4Wz'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'picker_mongodb' => [ //production
            'driver' => 'mongodb',
            'host' => env('DB6_HOST', '52.253.95.202'),
            'port' => env('DB6_PORT', '27017'),
            'database' => env('DB6_DATABASE', 'dms-picker'),
            'username' => env('DB6_USERNAME', 'AdminSammy'),
            'password' => env('DB6_PASSWORD', 'wxFQ^mqlE4Wz'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'picker_mongodbp' => [ //for qua
            'driver' => 'mongodb',
            'host' => env('DB11_HOST', '40.65.152.232'),
            'port' => env('DB11_PORT', '27017'),
            'database' => env('DB11_DATABASE', 'dms-picker'),
            'username' => env('DB11_USERNAME', 'pickeruser'),
            'password' => env('DB11_PASSWORD', 'wxFQ^mqlE4Wz'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'options' => [
                'database' => env('DB11_DATABASE'), // required with Mongo 3+
            ],
        ],


        'mongodbb' => [
            'driver' => 'mongodb',
            'host' => env('DB7_HOST', '13.67.71.193'),
            'port' => env('DB7_PORT', '27017'),
            'database' => env('DB7_DATABASE', 'testdb'),
            'username' => env('DB7_USERNAME', 'AdminSammy'),
            'password' => env('DB7_PASSWORD', 'wxFQ^mqlE4Wz'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'mongodb_uat' => [
            'driver' => 'mongodb',
            'host' => env('DB8_HOST', '104.215.147.54'),
            'port' => env('DB8_PORT', '27017'),
            'database' => env('DB8_DATABASE', 'dms-new'),
            'username' => env('DB8_USERNAME', 'waycooluser'),
            'password' => env('DB8_PASSWORD', '4J0qWFVUCZURkRDg'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],

        'mongodb_finance' => [
            'driver' => 'mongodb',
            'host' => env('DB10_HOST', 'dev.finance.waycool.in'),
            'port' => env('DB10_PORT', '27017'),
            'database' => env('DB10_DATABASE', 'receivables'),
            'username' => env('DB10_USERNAME', ''),
            'password' => env('DB10_PASSWORD', ''),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'options' => [
                'database' => env('DB10_DATABASE'), // required with Mongo 3+
            ],
        ],

        // hybrid uat
        // 'hybrid_mongodb_uat' => [
        //     'driver' => 'mongodb',
        //     'dsn' => 'mongodb://hybrid-user:wxFQ%255EmqlE%2410Wz@20.212.52.185:27017/hybrid-dms?authSource=admin',
        //     'database' => 'hybrid-dms',
        // ],

        // Local prod
        // 'hybrid_mongodb_uat' => [
        //     'driver' => 'mongodb',
        //     'dsn' => 'mongodb://hybridAppUser:hybrZd_9dMs7491_1@10.16.0.4:27017,10.16.0.6:27017,10.16.0.7:27017/hybrid_rktest?replicaSet=garuda',
        //     // 'database' => 'hybrid-dms',
        //     'database' => 'hybrid_rktest',
        // ],

        // live prod hybrid
        // 'hybrid_mongodb_prod' => [
        //     'driver' => 'mongodb',
        //     'dsn' => 'mongodb://hybridprod:waYc0Z_9Hy7r4i9d@10.16.0.4:27017,10.16.0.6:27017,10.16.0.7:27017/dmsHybrid?replicaSet=garuda&readPreference=secondary',
        //     // 'dsn' => 'mongodb://hybridprod:waYc0Z_9Hy7r4i9d@10.16.0.4:27017,10.16.0.6:27017,10.16.0.7:27017/dmsHybrid?replicaSet=garuda',
        //     // 'database' => 'hybrid-dms',
        //     'database' => 'dmsHybrid',
        // ],


        // Mongo Atlas 
        'hybrid_mongodb_prod' => [
            'driver' => 'mongodb',
            // 'dsn' => 'mongodb+srv://mongomirror:w3AM2szFOMYeAdjZ@dms-staging.crmxb.mongodb.net/dmsHybrid?authSource=admin&replicaset=atlas-xqe42a-shard-0',
            'dsn' => 'mongodb+srv://mongomirror:oKzUE9qsHjWN4lD1@dms-hybrid-prod.xxc0g.mongodb.net/dmsHybrid?retryWrites=true&w=majority',
            // 'dsn' => 'mongodb+srv://mongomirror:oKzUE9qsHjWN4lD1@dms-hybrid-prod-pri.xxc0g.mongodb.net/dmsHybrid?authSource=admin&replicaset=atlas-wqvfs9-shard-0',
            // 'dsn' => 'mongodb+srv://mongomirror:oKzUE9qsHjWN4lD1@dms-hybrid-prod-pri.xxc0g.mongodb.net/dmsHybrid?authSource=admin&replicaSet=atlas-wqvfs9-shard-0',
            // 'dsn' => 'mongodb://mongomirror:oKzUE9qsHjWN4lD1@dms-hybrid-prod-shard-00-00-pri.xxc0g.mongodb.net:27017,dms-hybrid-prod-shard-00-01-pri.xxc0g.mongodb.net:27017,dms-hybrid-prod-shard-00-02-pri.xxc0g.mongodb.net:27017/dmsHybrid?authSource=admin&replicaSet=atlas-wqvfs9-shard-0',
            // 'dsn' => 'mongodb://hybridprod:waYc0Z_9Hy7r4i9d@10.16.0.4:27017,10.16.0.6:27017,10.16.0.7:27017/dmsHybrid?replicaSet=garuda&readPreference=secondary',

            'database' => 'dmsHybrid',
        ],

        'pgsqlconnect' => [
            'driver' => 'pgsql',
            'host' => env('DB9_HOST', '20.198.248.223'),
            'port' => env('DB9_PORT', '5432'),
            'database' => env('DB9_DATABASE', 'testdb'),
            'username' => env('DB9_USERNAME', 'postgres'),
            'password' => env('DB9_PASSWORD', 'waycoolmaster@123'),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
        ],


        'mongodb_uat_test' => [
            'driver' => 'mongodb',
            'host' => env('DB13_HOST', '20.205.212.188'),
            'port' => env('DB13_PORT', '27017'),
            'database' => env('DB13_DATABASE', 'dms'),
            'username' => env('DB13_USERNAME', 'dmsuser'),
            'password' => env('DB13_PASSWORD', "wxFQ^mqlE4Wz"),
            'charset' => 'utf8',
            'prefix' => '',
            'prefix_indexes' => true,
            'options' => [
                'database' => env('DB13_DATABASE'), // required with Mongo 3+
            ],
        ],

         // BenchMarker uat connection 
        'benchmarker_mongodb_uat' => [
            'driver' => 'mongodb',
            'dsn' => 'mongodb+srv://uatuser:WnQ9wz4ccWLpjqXB@cluster0.hotvf.mongodb.net/benchmarkeruat',
        ],

        // BenchMarker prod connection 
        'benchmarker_mongodb_prod' => [
            'driver' => 'mongodb',
            'dsn' => 'mongodb+srv://bmuser:LwHjPgslHCA6Bdw6@benchmarkerprod.bvqga.mongodb.net/benchmarker?retryWrites=true&w=majority',
        ],


    ],
];