AutoJobTask/config/autoload/databases.php

<?php

declare(strict_types=1);

/**
 * This file is part of Hyperf.
 *
 * @link     https://www.hyperf.io
 * @document https://hyperf.wiki
 * @contact  group@hyperf.io
 * @license  https://github.com/hyperf/hyperf/blob/master/LICENSE
 */

use function Hyperf\Support\env;


$pool = [
    'min_connections' => 1,
    'max_connections' => 10,
    'connect_timeout' => 10.0,
    'wait_timeout' => 3.0,
    'heartbeat' => -1,
    'max_idle_time' => (float)env('DB_MAX_IDLE_TIME', 60),
];
$cache = [
    'handler' => Hyperf\ModelCache\Handler\RedisHandler::class,
    'cache_key' => '{mc:%s:m:%s}:%s:%s',
    'prefix' => 'default',
    'ttl' => 3600 * 24,
    'empty_model_ttl' => 600,
    'load_script' => true,
];
$commands = [
    'gen:model' => [
        'path' => 'app/Model',
        'force_casts' => true,
        'inheritance' => 'Model',
        'uses' => '',
        'table_mapping' => [],
    ],
];


return [
    'default' => [
        'driver' => env('DB_DRIVER', 'mysql'),
        'host' => env('DB_HOST', 'localhost'),
        'database' => env('DB_DATABASE', 'hyperf'),
        'port' => env('DB_PORT', 3306),
        'username' => env('DB_USERNAME', 'root'),
        'password' => env('DB_PASSWORD', ''),
        'charset' => env('DB_CHARSET', 'utf8'),
        'collation' => env('DB_COLLATION', 'utf8_unicode_ci'),
        'prefix' => env('DB_PREFIX', ''),
        'pool' => $pool,
        'cache' => $cache,
        'commands' => $commands,
    ],
    'robot' => [
        'driver' => env('DB_DRIVER2', 'mysql'),
        'host' => env('DB_HOST2', 'localhost'),
        'database' => env('DB_DATABASE2', 'hyperf'),
        'username' => env('DB_USERNAME2', 'root'),
        'password' => env('DB_PASSWORD2', ''),
        'charset' => env('DB_CHARSET', 'utf8'),
        'collation' => env('DB_COLLATION', 'utf8_unicode_ci'),
        'prefix' => env('DB_PREFIX2', ''),
        'pool' => $pool,
        'cache' => $cache,
        'commands' => $commands,
    ],
];