<?php

namespace Config;

use CodeIgniter\Database\Config;

/**
 * Database Configuration
 */
class Database extends Config 
{
    /**
     * The directory that holds the Migrations and Seeds directories.
     */
    public string $filesPath = APPPATH . 'Database' . DIRECTORY_SEPARATOR;

    /**
     * Lets you choose which connection group to use if no other is specified.
     */
    public string $defaultGroup = 'default';

    /**
     * The default database connection.
     *
     * @var array<string, mixed>
     */

    private array $dbCommon = [
        'DSN'          => '',
        'DBDriver'     => 'MySQLi',
        'DBPrefix'     => '',
        'pConnect'     => false,
        'DBDebug'      => true,
        'charset'      => 'utf8mb4',
        'DBCollat'     => 'utf8mb4_general_ci',
        'swapPre'      => '',
        'encrypt'      => false,
        'compress'     => false,
        'strictOn'     => false,
        'failover'     => [],
        'port'         => 3306,
        'numberNative' => false,
        'foundRows'    => false,
        'dateFormat'   => [
            'date'     => 'Y-m-d',
            'datetime' => 'Y-m-d H:i:s',
            'time'     => 'H:i:s',
        ],
    ];

    public array $default = [
        'hostname'     => 'localhost',
        'username'     => '',
        'password'     => '',
        'database'     => '',
    ];

    /**DISTRIBUIDORA KARINA*/
    public array $ms1_distribuidorakarina = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_distkarinauser',
        'password' => 'D15tK@rina2o2E',
        'database' => 'codigofa_distkarina_db',
    ];
 
    /**CODIGO FASHION - APOPA*/
    public array $ms1_codigoFaApopa = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_uapopa',
	    'password' => 'miracle_inv_papopa',
	    'database' => 'codigofa_miracle_inv_apopa',
    ];
    /**CODIGO FASHION - EL ENCUENTRO*/
    public array $ms1_codigoFaElEncuentro = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_uelencuentro',
        'password' => 'miracle_inv_pelencuentro',
        'database' => 'codigofa_miracle_inv_elencuentro',
    ];
    /**CODIGO FASHION - GARDEN MALL*/
    public array $ms1_codigoFaGarden = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_ugarden',
        'password' => 'Codigo2023',
        'database' => 'codigofa_miracle_inv_garden',
    ];
    /**CODIGO FASHION - LOURDES*/
    public array $ms1_codigoFaLourdes = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_ulourdes',
        'password' => 'miracle_inv_plourdes',
        'database' => 'codigofa_miracle_inv_lourdes',
    ];
    /**CODIGO FASHION - SAN MIGUEL*/
    public array $ms1_codigoFaSanMiguel = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_usanmiguel',
        'password' => 'miracle_inv_psanmiguel',
        'database' => 'codigofa_miracle_inv_sanmiguel',
    ];
    /**CODIGO FASHION - SANTA ANA*/
    public array $ms1_codigoFaSantaAna = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_usantaana',
        'password' => 'miracle_inv_psantaana',
        'database' => 'codigofa_miracle_inv_santaana',
    ];
    /**CODIGO FASHION - SANTA ROSA*/
    public array $ms1_codigoFaSantaRosa = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_usantarosa',
        'password' => 'miracle_inv_psantarosa',
        'database' => 'codigofa_miracle_inv_santarosa',
    ];
    /**CODIGO FASHION - SOYAPANGO*/
    public array $ms1_codigoFaSoyapango = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_usoyapango',
        'password' => 'miracle_inv_psoyapango',
        'database' => 'codigofa_miracle_inv_soyapango',
    ];
    /**CODIGO FASHION - USULUTAN*/
    public array $ms1_codigoFaUsulutan = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_miracle_inv_usulutan_user',
        'password' => 'C0d1goFa5#ioNUsult@N',
        'database' => 'codigofa_miracle_inv_usulutan',
    ];
    /**PAPARAZZI SAN MIGUEL*/
    public array $ms1_paparazziSanMiguel = [
        'hostname' => '151.106.103.28',
        'username' => 'codigofa_paparazzi_sanmiguel_us',
        'password' => 'PaparazziSM',
        'database' => 'codigofa_paparazzi_sanmiguel',
    ];
    /**TIENDA HERMANOS GOMEZ*/
    public array $ms1_thgomez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_thgomez_db',
    ];
    /** INAGRO */
    public array $ms1_inagro = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_inagro_db',
    ];
    /** LACTEOS EL TRIUNFO */
    public array $ms1_lacteoseltriunfo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteoseltriunfo_db',
    ];
    /** HS IMPORT */
    public array $ms1_hsimport = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_hsimport_db',
    ];
    /** MULTISERVICIOS DEVINS SUC TRIANGULO SM */
    public array $ms1_multiserviciosdevinssuc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_multiserviciosdevins_suc1_db',
    ];
    /** MULTISERVICIOS DEVINS KM18 MOR*/
    public array $ms1_multiserviciosdevinssuc2 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_multiserviciosdevins_suc2_db',
    ];
    /**VERDUGLASA*/
    public array $ms1_verduglasa = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_verduglasa_db',
    ];
    /**BATERIAS POWER STAR*/
    public array $ms1_bateriaspowerstar = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_bateriaspowerstar_db',
    ];
    /**DEVINS FAST FOOD*/
    public array $ms1_devinsfastfood = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_devinsfastfood_db',
    ];/**CORPORACION LINE */
    public array $ms1_corporacionline = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_corporacionline_db',
    ];
    /**BAZAR PATRICIA */
    public array $ms1_bazarpatricia = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_bazarpatricia_db',
    ];
    /**BAZAR PATRICIA */
    public array $ms1_distribuidorahercules = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_distribuidorahercules_db',
    ];
    /**DLC MORAZAN */
    public array $ms1_dlcmorazan = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dlcmorazan_db',
    ];
    /**LACTEOS EL BUEN PASTOR */
    public array $ms1_lacteoselbuenpastor = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteoselbuenpastor_db',
    ];
    /**LACTEOS EL BUEN PASTOR -  SUC */
    public array $ms1_lacteoselbuenpastorsuc2 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteoselbuenpastor_suc2_db',
    ];
    /**DEMO */
    public array $ms1_demo = [
        'hostname' => '172.93.51.194',//'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_demo_db',
    ];

    /**EquiS */
    public array $ms1_equis = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_equis_db',
    ];
    /**Negocios Sandoval */
    public array $ms1_negociossandoval = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_negociossandoval_db',
    ];
    /**Lacteos Diaz Diaz - Flor Maristela Reyez De Diaz*/
    public array $ms1_lacteosdiazdiaz_fmrd = [
        'hostname' => 'localhost:3311',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosdiazdiaz_fmrd_db',
    ];
    /**Lacteos Diaz Diaz - Matriz*/
    public array $ms1_lacteosdiazdiaz_matriz = [
        'hostname' => 'localhost:3311',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosdiazdiaz_matriz_db',
    ];
    /**Lacteos Diaz Diaz - Sucursal 1 */
    public array $ms1_lacteosdiazdiaz_suc1_db = [
        'hostname' => 'localhost:3311',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosdiazdiaz_suc1_db',
    ];
    /**Lacteos Diaz Diaz - Sucursal 2 */
    public array $ms1_lacteosdiazdiaz_suc2_db = [
        'hostname' => 'localhost:3311',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosdiazdiaz_suc2_db',
    ];
    /**Distribuidora Sandi */
    public array $ms1_distribuidorasandi = [
        'hostname' => 'localhost:3312',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_distsandi_db',
    ];
    /**La Tortuga Verde */
    public array $ufood_ltv_db= [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_verduglasa2_db',
    ];
    /**Tienda Las Brisas */
    public array $ms1_tiendalasbrisas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendalasbrisas_db',
    ];
    /** */
    public array $ms1_agrovetblanco = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agrovetblanco_db',
    ];
    public array $ms1_ravimar = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ravimar_db',
    ];
    /** */
    public array $ms1_naturessunshine = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_naturessunshine_db',
    ];
    public array $ms1_libreriapinel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_libreriapinel_db',
    ];
    public array $ms1_sayonara = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_sayonara_db',
    ];
    public array $ms1_sanjose = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_sanjose_db',
    ];
    public array $ms1_cclamarqueza = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_cclamarqueza_db',
    ];
    public array $ms1_agroequiposdeoriente = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agroequiposdeoriente_db',
    ];
    public array $ms1_comercialsantarosa = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_comercialsantarosa_db',
    ];
    public array $ms1_lacteosalex = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosalex_db',
    ];
    public array $ms1_tiendacarlitos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendacarlitos_db',
    ];
    public array $ms1_agrovetellilisqueno = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agrovetellilisqueno_db',
    ];
    public array $ms1_santateresita = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_santateresita_db',
    ];
    public array $ms1_agroinsumosanfrancisco = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agroinsumosanfrancisco_db',
    ];
     public array $ms1_publimate = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_publimate_db',
    ];
    public array $ms1_transporteoliva = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_transporteoliva_db',
    ];
    public array $ms1_comercialwendy = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_comercialwendy_db',
    ];
    public array $ms1_lacteosdaneth = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosdaneth_db',
    ];
    public array $ms1_ferreteriaelconacaste = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreteriaelconacaste_db',
    ];
    public array $ms1_agrovetmata = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agrovetmata_db',
    ];
    public array $ms1_lacteosjenny_pollos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosjenny_pollos_db',
    ];
    public array $ms1_negociosquintanilla =[
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_negociosquintanilla_db',
    ];
    public array $ms1_talleresindustrialesdeoriente = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_talleresindustrialesdeoriente_db',
    ];
    public array $ms1_lacteosclaribel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosclaribel_db',
    ];
    public array $ms1_losdoshermanos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_losdoshermanos_db',
    ];
    public array $ms1_tiendagerson = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendagerson_db',
    ];
    public array $ms1_millenniumsupermarket_mercedes = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_millenniumsupermarket_mercedes_db',
    ];
    public array $ms1_millenniumsupermarket_sm = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_millenniumsupermarket_sm_db',
    ];
    public array $ms1_millenniumsupermarket_jucuaran = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_millenniumsupermarket_jucuaran_db',
    ];
    public array $ms1_millenniumsupermarket_chirilagua = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_millenniumsupermarket_chirilagua_db',
    ];
    public array $ms1_tallercs = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tallercs_db',
    ];
    public array $ms1_lacteoscanaan = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteoscanaan_db',
    ];
    public array $ms1_tiendablanco = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendablanco_db',
    ];
    public array $ms1_tiendakarlita = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendakarlita_db'
    ];
    public array $ms1_negocioslaamistad = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_negocioslaamistad_db'
    ];
    public array $maspos_telemas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_telemas_db'
    ];
    public array $ms1_credipronto = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_credipronto_db'
    ];
    public array $ms1_lic_mariosanchez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_mariosanchez_db'
    ];
    public array $ms1_dr_agustinrodriguez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dr_agustinrodriguez_db'
    ];
    public array $ms1_aguapiedraazul = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_aguapiedraazul_db'
    ];
    public array $ms1_fogatapublicidad = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_fogatapublicidad_db'
    ];
    public array $ms1_superdonmarte = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_superdonmarte_db'
    ];
    public array $ms1_tiendalabendicion = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendalabendicion_db'
    ];
    public array $ms1_lic_jaimechavez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_jaimechavez_db'
    ];

    public array $ufood_guapolloneltico = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_guapolloneltico_db'
    ];

    public array $ufood_tipicoslahirleman = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_tipicoslahirleman_db'
    ];

    public array $ms1_solucionesinformaticas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_solucionesinformaticas_db'
    ];

    public array $ms1_ecmautomotriz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ecmautomotriz_db'
    ];

    public array $ms1_lic_carlosurbina = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_carlosurbina_db'
    ];

    public array $ms1_sayonara_boutique = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_sayonara_butique_db'
    ];

    public array $ms1_tiendanueva = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendanueva_db'
    ];

    public array $ms1_farmacialanueva = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_farmacialanueva_db'
    ];

    public array $ms1_suministros = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_suministros_db'
    ];

    public array $ms1_ferreteriaelrodeo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreteriaelrodeo_db'
    ];

    public array $ms1_autovidriojr_matriz = [
        //'hostname' => 'localhost',
        'hostname' => '172.93.51.194',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_autovidriojr_matriz_db'
    ];

    public array $ms1_autovidriojr_elpalmar = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_autovidriojr_elpalmar_db'
    ];

    public array $ms1_autovidriojr_usulutan = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_autovidriojr_usulutan_db'
    ];

    public array $ms1_autovidriojr_sansalvador29 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_autovidriojr_sansalvador29_db'
    ];

    public array $ufood_tingos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_tingos_db'
    ];

    public array $ufood_amanecermarino = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_amanecermarino_db'
    ];

    public array $ms1_aqaenvasadora = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_aqaenvasadora_db'
    ];

    public array $ms1_tiendaolivia = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendaolivia_db'
    ];
    public array $ms1_marinmo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_marinmo_db'
    ];
    public array $ms1_almacendiazdiaz= [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_almacendiazdiaz_db'
    ];
    public array $ufood_perkinlenca = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_perkinlenca_db'
    ];
    public array $ms1_mundonatural_matriz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_mundonatural_matriz_db'
    ];
    public array $ms1_mundonatural_suc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_mundonatural_suc1_db'
    ];
    public array $ms1_mundonatural_suc2 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_mundonatural_suc2_db'
    ];
    public array $ms1_myprincesstour = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_myprincesstour_db'
    ];
    public array $ms1_pasteleriaflori = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_pasteleriaflori_db'
    ];
    public array $ms1_lacteosjenny = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosjenny_db'
    ];
    public array $ms1_laurent = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_laurent_db'
    ];
    public array $ms1_ventanasmario = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ventanasmario_db'
    ];
    public array $ms1_cvm_suc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_cvm_suc1_db'
    ];
    public array $ms1_rentacarjn = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_rentacarjn_db'
    ];
    public array $ms1_agroserviciosanjose = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agroserviciosanjose_db'
    ];
    public array $ms1_casadelagricultor = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_casadelagricultor_db'
    ];
    public array $ms1_topfitnessclub = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_topfitnessclub_db'
    ];
    public array $ms1_parqueolasdelicias = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_parqueolasdelicias_db'
    ];
    public array $ms1_autohotelsp = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_autohotelsp_db'
    ];
    public array $ms1_labclinelporvenir = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_labclinelporvenir_db'
    ];
    public array $ms1_lacteosryr = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosryr_db'
    ];
    public array $ms1_servielecmartinez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_servielecmartinez_db'
    ];
    public array $ms1_agroferreteriaargueta = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agroferreteriaargueta_db'
    ];
    public array $ms1_carlosvelazquez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_carlosvelazquez_db'
    ];
    public array $ms1_hde = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_hde_db'
    ];
    public array $ms1_elvagon = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_elvagon_db'
    ];
    public array $ms1_modeliz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_modeliz_db'
    ];
    public array $ms1_distribuidoraaraute = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_distribuidoraaraute_db'
    ];
    public array $ms1_maskilates = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_maskilates_db'
    ];
    public array $ms1_joyerianoel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_joyerianoel_db'
    ];
    public array $ms1_casaahues = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_casaahues_db'
    ];
    public array $ms1_cliviachavez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_cliviachavez_db'
    ];
    public array $ms1_paparazzi_ss = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miraclepapa_parazzi_ss_db'
    ];
    public array $ms1_manasol = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_manasol_db'
    ];
    public array $ms1_economax = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_economax_db'
    ];
     public array $ufood_cesarpizza = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'ufood_cesarpizza_db'
    ];
    public array $ms1_peof = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_peof_db'
    ];
    public array $ms1_almacendiazdiaz_suc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_almacendiazdiaz_suc1_db'
    ];
    public array $ms1_almacendiazdiaz_suc2 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_almacendiazdiaz_suc2_db'
    ];
    public array $ms1_almacendiazdiaz_suc3 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_almacendiazdiaz_suc3_db'
    ];
    public array $ms1_almacendiazdiaz_suc4 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_almacendiazdiaz_suc4_db'
    ];
    public array $ms1_anovedadesyvmartinez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_novedadesyvmartinez_db'
    ];
    public array $ms1_servicioscalderon = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_servicioscalderon_db'
    ];
    public array $ms1_supergerardo = [
        'hostname' => 'localhost:3313',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_supergerardo_db'
    ];
    public array $ms1_variedadesyamileth = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_variedadesyamileth_db'
    ];
    public array $ms1_aracu = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_aracu_db'
    ];
    public array $ms1_lacteossorto = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteossorto_db'
    ];
    public array $ms1_plasticosrivas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_plasticosrivas_db'
    ];
    public array $ms1_solarsit = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_solarsit_db'
    ];
    public array $ms1_bazargarcia = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_bazargarcia_db'
    ];
    public array $comedorjenny = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'comedorjenny_db'
    ];
    public array $ms1_lacteosvasquez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosvasquez_db'
    ];
    public array $ms1_tiendacamila_matriz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendacamila_matriz_db'
    ];
    public array $ms1_tiendacamila_lolotiquillo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendacamila_lolotiquillo_db'
    ];
    public array $ms1_tiendacamila_cacaopera = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendacamila_cacaopera_db'
    ];
    public array $ms1_tiachefy = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiachefy_db'
    ];
    public array $ms1_lacteoselbuenpastorsuc3 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteoselbuenpastor_suc3_db'
    ];
    public array $ms1_distribuidoracerna = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_distribuidoracerna_db'
    ];
    public array $ms1_juanangelbonilla = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_juanangelbonilla_db'
    ];
    public array $ms1_elhenequenylajarcia = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_elhenequenylajarcia_db'
    ];
    public array $ms1_transportescortez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_transportescortez_db'
    ];
    public array $ms1_cp_dr_hernandez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_cp_dr_hernandez_db'
    ];
    public array $ms1_lic_torruella = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_torruella_db'
    ];
    public array $ms1_arevalomdc = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_arevalomdc_db'
    ];
    public array $ms1_lacteosvillatoro = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosvillatoro_db'
    ];
    public array $ms1_comercialyanira = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_comercialyanira_db'
    ];
    public array $ms1_perforacionesdeoriente = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_perforacionesdeoriente_db'
    ];
    public array $ms1_festudioalvarez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_festudioalvarez_db'
    ];
    public array $ms1_libreriadaniel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_libreriadaniel_db'
    ];
    public array $ms1_tecnoanalisis = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tecnoanalisis_db'
    ];
    public array $ms1_tecnoanalisis_suc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tecnoanalisis_suc1_db'
    ];
    public array $ms1_tfsanlucas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tfsanlucas_db'
    ];
    public array $ms1_lic_edrasvelasquez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_edrasvelasquez_db'
    ];
    public array $ms1_medicasa = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_medicasa_db'
    ];
    public array $ms1_tiendaedenilson = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_servicompres_db'
    ];
    public array $ms1_variedadesfrancisca = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_variedadesfrancisca_db'
    ];
    public array $ms1_liculisesvillatoro = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_ulisesvillatoro_db'
    ];
    public array $ms1_clinicadental_integral = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_clinicadental_integral_db'
    ];
    public array $ms1_lic_robertomiranda = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_robertomiranda_db'
    ];
    public array $ms1_transportesescobar = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_transportesescobar_db'
    ];
    public array $ms1_automotelpicacho = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_automotelpicacho_db'
    ];
    public array $ms1_ferreteriaeltriunfo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreteriaeltriunfo_db'
    ];
    public array $ms1_ferreteriagomez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreteriagomez_db'
    ];
    public array $ms1_tiendawichos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendawichos_db'
    ];
    public array $ms1_distribuidoraaparicio = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_distribuidoraaparicio_db'
    ];
    public array $ms1_grupocastro = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_grupocastro_db'
    ];
    public array $ms1_dra_carolinaavelar = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dra_carolinaavelar_db'
    ];
    public array $ms1_farmaciasanfrancisco = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_farmaciasanfrancisco_db'
    ];
    public array $ms1_modadeportiva = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_modadeportiva_db'
    ];
    public array $ms1_herbertharevalo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_herbertharevalo_db'
    ];
    public array $ms1_dra_yeseniaavila = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dra_yeseniaavila_db'
    ];
    public array $ms1_dr_salvadoravila = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dr_salvadoravila_db'
    ];
    public array $ms1_calzadocentral = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_calzadocentral_db'
    ];
    public array $ms1_servillantastorres = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_servillantastorres_db'
    ];
    public array $ms1_activacionesnathaly_matriz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_activacionesnathaly_matriz_db'
    ];
    public array $ms1_activacionesnathaly_suc1 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_activacionesnathaly_suc1_db'
    ]; 
    public array $ms1_activacionesnathaly_suc2 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_activacionesnathaly_suc2_db'
    ]; 
    public array $ms1_activacionesnathaly_suc3 = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_activacionesnathaly_suc3_db'
    ];
    public array $ms1_agroserviciosanantonio = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agroserviciosanantonio_db'
    ];
    public array $ms1_juliayaneth = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_juliayaneth_db'
    ];
    public array $ms1_minisuperclarita = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_minisuperclarita_db'
    ];
    public array $ms1_variedadesbrooklyn = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_variedadesbrooklyn_db'
    ];
    public array $ms1_lacteosjenny_tienda = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosjenny_tienda_db'
    ];
    public array $ms1_dra_normagomez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_dra_normagomez_db'
    ];
    public array $ms1_patriciaturcios = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_patriciaturcios_db'
    ];
    public array $ms1_reinalazo = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_reinalazo_db'
    ];
    public array $ms1_lic_fredyosorio = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lic_fredyosorio_db'
    ];
    public array $ms1_selvinolivares = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_selvinolivares_db'
    ];
    public array $ms1_closetscielosymas = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_closetscielosymas_db'
    ];
    public array $ms1_clinicadentalsancarlos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_clinicadentalsancarlos_db'
    ];
    public array $ms1_salvadormelendez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_salvadormelendez_db'
    ];
    public array $ms1_farmaciajared = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_farmaciajared_db'
    ];
    public array $ms1_lacteosjose = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteosjose_db'
    ];
    public array $ferreteriaelmolino = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreteriaelmolino_db'
    ];
    public array $ms1_yaniragaleano = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_yaniragaleano_db'
    ];
    public array $ms1_teixeira = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_teixeira_db'
    ];
    public array $ms1_comercialvillatoro = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_comercialvillatoro_db'
    ];
    public array $ms1_rdmlaplaza = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_rdmlaplaza_db'
    ];
    public array $ms1_multiserviciosrodriguez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_multiserviciosreodriguez_db'
    ];
    public array $ms1_jfagronegocios = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_jfagronegocios_db'
    ];
    public array $ms1_grupolegal = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_grupolegal_db'
    ];
    public array $ms1_lolotiquesc = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lolotiquesc_db'
    ];
    public array $ms1_pavmatriz = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_pav_matriz_db'
    ];
    public array $ms1_pavosicala = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_pav_osicala_db'
    ];
    public array $ms1_bakerysupplies = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_bakerysupplies_db'
    ];
    public array $ms1_labebenezer = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_labebenezer_db'
    ];
    public array $ms1_eclipseautohotel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_eclipseautohotel_db'
    ];
    public array $ms1_xypnos = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_xypnos_db'
    ];
    public array $ms1_labsamaria = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_labsamaria_db'
    ];
    public array $ms1_lacteospleitez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lacteospleitez_db'
    ];
    public array $ms1_variedadesemely = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_variedadesemely_db'
    ];
    public array $ms1_ferreterialaceiba = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_ferreterialaceiba_db'
    ];
    public array $ms1_celularesjefferson = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_celularesjefferson_db'
    ];
    public array $ms1_libreriajosue = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_libreriajosue_db'
    ];
    public array $ms1_jc = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_jc_db'
    ];
    public array $ms1_fisioterapiasanmiguel = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_clinicafisioterapiasabmiguel_db'
    ];
    public array $ms1_homecare = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_homecare_db'
    ];
    public array $ms1_carpinteriaaranda = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_carpinteriaaranda_db'
    ];
    public array $ms1_agropork = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_agropork_db'
    ];
    public array $ms1_geektech = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_geektech_db'
    ];
    public array $ms1_llanteriaberrios = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_llanteriaberrios_db'
    ];
    public array $ms1_tiendahored = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_tiendahored_db'
    ];
    public array $ms1_kidari = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_kidari_db'
    ];
    public array $ms1_omarbeautysalon = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_omarbeautysalon_db'
    ];
    public array $ms1_lafamiliamarket = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_lafamiliamarket_db'
    ];
    public array $ms1_grupoguevararodriguez = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_grupoguevararodriguez_db'
    ];
    public array $ms1_nilsonnolasco = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_nilsonnolasco_db'
    ];
    public array $ms1_jh = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_jh_db'
    ];
    public array $ms1_licdabeatrizmerino = [
        'hostname' => 'localhost',
        'username' => 'miracleadmin',
        'password' => 'MDbAdmin2024!',
        'database' => 'miracle_licda_beatrizmerino_db'
    ];


    public array $adminDb = [
        'DSN'          => '',
        'hostname'     => 'localhost',
        'username'     => 'miracleadmin'/*/'root'*/,
        'password'     => 'MDbAdmin2024!'/*/'Xyp542!2o14'*/,
        'database'     => 'syssv_dashboard_db',
        'DBDriver'     => 'MySQLi',
        'DBPrefix'     => '',
        'pConnect'     => false,
        'DBDebug'      => true,
        'charset'      => 'utf8mb4',
        'DBCollat'     => 'utf8mb4_general_ci',
        'swapPre'      => '',
        'encrypt'      => false,
        'compress'     => false,
        'strictOn'     => false,
        'failover'     => [],
        'port'         => 3306,
        'numberNative' => false,
        'foundRows'    => false,
        'dateFormat'   => [
            'date'     => 'Y-m-d',
            'datetime' => 'Y-m-d H:i:s',
            'time'     => 'H:i:s',
        ],
    ];

    public array $tests = [
        'DSN'         => '',
        'hostname'    => '127.0.0.1',
        'username'    => '',
        'password'    => '',
        'database'    => ':memory:',
        'DBDriver'    => 'MySQLi',
        'DBPrefix'    => 'db_',  // Needed to ensure we're working correctly with prefixes live. DO NOT REMOVE FOR CI DEVS
        'pConnect'    => false,
        'DBDebug'     => true,
        'charset'     => 'utf8',
        'DBCollat'    => '',
        'swapPre'     => '',
        'encrypt'     => false,
        'compress'    => false,
        'strictOn'    => false,
        'failover'    => [],
        'port'        => 3306,
        'foreignKeys' => true,
        'busyTimeout' => 1000,
        'dateFormat'  => [
            'date'     => 'Y-m-d',
            'datetime' => 'Y-m-d H:i:s',
            'time'     => 'H:i:s',
        ],
    ];

    public function getDatabaseConfig($group)
    {
        $config = $this->$group;
        return array_merge($this->dbCommon, $config);
    }

    /*public function __construct()
    {
        parent::__construct();

        // Ensure that we always set the database group to 'tests' if
        // we are currently running an automated test suite, so that
        // we don't overwrite live data on accident.
        if (ENVIRONMENT === 'testing') {
            $this->defaultGroup = 'tests';
        }
    }*/
}
