<?php 
/** 
 * * 
 *  * please don't remove this comment block 
 *  * 
 *  * @author phptricks Team - Mohammad Anzawi 
 *  * @author_uri https://phptricks.org 
 *  * @uri https://github.com/anzawi/php-database-class 
 *  * @version 5.0.0 
 *  * @licence MIT -> https://opensource.org/licenses/MIT 
 *  * @package PHPtricks\Orm 
 * 
 */ 
 
return [ 
 
    /* 
    |-------------------------------------------------------------------------- 
    | PDO Fetch Style 
    |-------------------------------------------------------------------------- 
    | 
    | By default, database results will be returned as instances of the PHP 
    | stdClass object; however, you may desire to retrieve records in an 
    | array format for simplicity. Here you can tweak the fetch style. 
    | 
    */ 
 
    'fetch' => PDO::FETCH_OBJ, // for array -> PDO::FETCH_ASSOC, 
 
    /* 
    |-------------------------------------------------------------------------- 
    | Default Database Connection Name 
    |-------------------------------------------------------------------------- 
    | 
    | Here you may specify which of the database connections below you wish. 
    */ 
 
    'default' => 'mysql', 
 
 
    /* 
    |-------------------------------------------------------------------------- 
    | Database Connections 
    |-------------------------------------------------------------------------- 
    | 
    | Here are each of the database connections setup for your application. 
    | Of course, examples of configuring each database platform that is 
    | supported by PHPtricks/database class is shown below to make development simple. 
    | 
    | 
    | All database work in HPtricks/database is done through the PHP PDO facilities 
    | so make sure you have the driver for your particular database of 
    | choice installed on your machine before you begin development. 
    | 
    */ 
 
    'connections' => [ 
        // MySQL 3.x/4.x/5.x 
        'mysql'  => [ 
            'driver'      => 'mysql', 
            'host_name'   => '192.168.10.10', 
            'db_name'     => 'test', 
            'db_user'     => 'homestead', 
            'db_password' => 'secret', 
        ], 
 
        // PostgreSQL 
        'pgsql'  => [ 
            'driver'      => 'pgsql', 
            'host_name'   => 'localhost', 
            'db_name'     => 'database_name', 
            'db_user'     => 'database_username', 
            'db_password' => 'database_user_password', 
        ], 
 
        // SQLite 
        'sqlite' => [ 
            'db_path' => 'my/database/path/database.db', 
        ], 
 
        //    MS SQL Server 
        'mssql'  => [ 
            'driver'      => 'mssql', 
            'host_name'   => 'localhost', 
            'db_name'     => 'database_name', 
            'db_user'     => 'database_username', 
            'db_password' => 'database_user_password', 
        ], 
 
        //    MS SQL Server 
        'sybase' => [ 
            'driver'      => 'sybase', 
            'host_name'   => 'localhost', 
            'db_name'     => 'database_name', 
            'db_user'     => 'database_username', 
            'db_password' => 'database_user_password', 
        ], 
 
        // Oracle Call Interface 
        'oci'    => [ 
            'tns' => ' 
                    DESCRIPTION = 
                        (ADDRESS_LIST = 
                          (ADDRESS = (PROTOCOL = TCP)(HOST = yourip)(PORT = 1521)) 
                        ) 
                        (CONNECT_DATA = 
                          (SERVICE_NAME = orcl) 
                        ) 
                      )', 
 
            'db_user'     => 'database_username', 
            'db_password' => 'database_user_password', 
        ], 
    ], 
 
 
    "pagination" => [ 
        "no_data_found_message" => "Oops, No Data Found to show ..", 
        "records_per_page"      => 10, 
        "link_query_key"        => "page", 
    ], 
 
    // Directories for Commands 
    'directories' => [ 
        'create' => __DIR__.'/../Migrations/create/', 
        'alter'  => __DIR__.'/../Migrations/alter/', 
        'drop'   => __DIR__.'/../Migrations/drop/', 
        'migrated-file' =>  __DIR__.'/../Migrations/temp/', 
        'models' =>  __DIR__.'/../Models/' 
    ], 
]; 
 
 |