mirror of
https://github.com/opensourcepos/opensourcepos.git
synced 2026-10-28 19:18:58 -04:00
- Extend composer.json and composer.lock PHP requirement to include PHP 8.5 - Add PHP 8.5 to test matrix in phpunit.yml and main.yml workflows - Modernize php-linter.yml to use setup-php@v2 with parallel matrix for PHP 8.2–8.5 - Propagate PHP 8.2 lint failures via shell loop in find -exec + while retaining batching for 8.3–8.5 - Add permissions: contents: read and cancel-in-progress concurrency to php-linter.yml - Remove obsolete Node.js and npm install steps from phpunit.yml - Update phpunit.yml runner to ubuntu-latest and composer cache action to v4 - Address PHP 8.5 deprecations and syntax: - Replace deprecated switch-case semicolon with standard colon in app/Config/Database.php - Replace non-standard (double) cast with (float) in app/Libraries/Token_lib.php - Remove obsolete curl_close() calls in app/Config/Validation/OSPOSRules.php and app/Libraries/Mailchimp_lib.php - Update INSTALL.md, workflows README, and bug report issue template to include PHP 8.5
143 lines
4.4 KiB
PHP
143 lines
4.4 KiB
PHP
<?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>
|
|
*/
|
|
public array $default = [
|
|
'DSN' => '',
|
|
'hostname' => 'localhost',
|
|
'username' => 'admin',
|
|
'password' => 'pointofsale',
|
|
'database' => 'ospos',
|
|
'DBDriver' => 'MySQLi',
|
|
'DBPrefix' => 'ospos_',
|
|
'pConnect' => false,
|
|
'DBDebug' => (ENVIRONMENT !== 'production'),
|
|
'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',
|
|
],
|
|
];
|
|
|
|
/**
|
|
* This database connection is used when running PHPUnit database tests.
|
|
*
|
|
* @var array<string, mixed>
|
|
*/
|
|
public array $tests = [
|
|
'DSN' => '',
|
|
'hostname' => 'localhost',
|
|
'username' => 'admin',
|
|
'password' => 'pointofsale',
|
|
'database' => 'ospos',
|
|
'DBDriver' => 'MySQLi',
|
|
'DBPrefix' => 'ospos_',
|
|
'pConnect' => false,
|
|
'DBDebug' => (ENVIRONMENT !== 'production'),
|
|
'charset' => 'utf8mb4',
|
|
'DBCollat' => 'utf8mb4_general_ci',
|
|
'swapPre' => '',
|
|
'encrypt' => false,
|
|
'compress' => false,
|
|
'strictOn' => false,
|
|
'failover' => [],
|
|
'port' => 3306,
|
|
'foreignKeys' => true,
|
|
'busyTimeout' => 1000,
|
|
'synchronous' => null,
|
|
'dateFormat' => [
|
|
'date' => 'Y-m-d',
|
|
'datetime' => 'Y-m-d H:i:s',
|
|
'time' => 'H:i:s',
|
|
],
|
|
];
|
|
|
|
/**
|
|
* This database connection is used when developing against non-production data.
|
|
*
|
|
* @var array
|
|
*/
|
|
public $development = [
|
|
'DSN' => '',
|
|
'hostname' => 'localhost',
|
|
'username' => 'admin',
|
|
'password' => 'pointofsale',
|
|
'database' => 'ospos',
|
|
'DBDriver' => 'MySQLi',
|
|
'DBPrefix' => 'ospos_',
|
|
'pConnect' => false,
|
|
'DBDebug' => (ENVIRONMENT !== 'production'),
|
|
'charset' => 'utf8mb4',
|
|
'DBCollat' => 'utf8mb4_general_ci',
|
|
'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 __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.
|
|
switch (ENVIRONMENT) {
|
|
case 'testing':
|
|
$this->defaultGroup = 'tests';
|
|
break;
|
|
case 'development':
|
|
$this->defaultGroup = 'development';
|
|
break;
|
|
}
|
|
|
|
foreach ([&$this->development, &$this->tests, &$this->default] as &$config) {
|
|
$config['hostname'] = !getenv('MYSQL_HOST_NAME') ? $config['hostname'] : getenv('MYSQL_HOST_NAME');
|
|
$config['username'] = !getenv('MYSQL_USERNAME') ? $config['username'] : getenv('MYSQL_USERNAME');
|
|
$config['password'] = !getenv('MYSQL_PASSWORD') ? $config['password'] : getenv('MYSQL_PASSWORD');
|
|
$config['database'] = !getenv('MYSQL_DB_NAME') ? $config['database'] : getenv('MYSQL_DB_NAME');
|
|
}
|
|
}
|
|
}
|