Process 使用Db后無法啟動(dòng)

qq7467466 2023-06-25

問題描述

需求是需要?jiǎng)討B(tài)的讀取數(shù)據(jù)庫的配置,然后啟動(dòng)多個(gè)process, 目前使用DB查詢方法導(dǎo)致報(bào)錯(cuò), 如果無法用DB方法查詢的話, 那這些參數(shù)應(yīng)該如何動(dòng)態(tài)讀取呢?

程序代碼

use support\Db;

$group_ids = Db::table('apps')->limit('10')->pluck('app_uid')->toArray();
var_dump($group_ids);

$group_ids = [
    "tw_phonecollect" => 3,
    "t15_login"       => 3,
    "data-report"     => 3,
    "program_login"   => 3,
    "qa_platform"     => 3,
    "192.168.33.250"  => 3,
];

foreach ($group_ids as $group_id => $count) {
    $process[$group_id] = [
        'handler' => \app\queue\kafka\Events::class,
        'count'   => $count, // 進(jìn)程數(shù)
        'user'    => $group_id,
        'group'   => $group_id,
    ];
}

return $process;

報(bào)錯(cuò)信息

Fatal error: Uncaught Error: Call to a member function connection() on null in D:\phpstudy_pro\WWW\cloudEvent\vendor\illuminate\database\Capsule\Manager.php:87
Stack trace:
#0 D:\phpstudy_pro\WWW\cloudEvent\config\plugin\ycgame\cloud-event\process.php(13): Illuminate\Database\Capsule\Manager::table('apps')
#1 D:\phpstudy_pro\WWW\cloudEvent\vendor\workerman\webman-framework\src\Config.php(207): include('D:\\phpstudy_pro...')
#2 D:\phpstudy_pro\WWW\cloudEvent\vendor\workerman\webman-framework\src\Config.php(63): Webman\Config::loadFromDir('D:\\phpstudy_pro...', Array)
#3 D:\phpstudy_pro\WWW\cloudEvent\vendor\workerman\webman-framework\src\support\App.php(141): Webman\Config::load('D:\\phpstudy_pro...', Array)
#4 D:\phpstudy_pro\WWW\cloudEvent\vendor\workerman\webman-framework\src\support\App.php(37): support\App::loadAllConfig(Array)
#5 D:\phpstudy_pro\WWW\cloudEvent\start.php(4): support\App::run()
#6 {main}
  thrown in D:\phpstudy_pro\WWW\cloudEvent\vendor\illuminate\database\Capsule\Manager.php on line 87

截圖報(bào)錯(cuò)信息里報(bào)錯(cuò)文件相關(guān)代碼

操作系統(tǒng)及workerman/webman等框架組件具體版本

workerman/webman-framework: 1.5.6
illuminate/database: 8.83.27

 946  2 0

2個(gè)回答

tanhongbin 2023-06-25

Db 沒有 toArray() 方法你應(yīng)該在前面使用（array）Db::table('')->...

暫無評(píng)論

walkor 2023-06-25

打賞

無法在配置里使用框架自帶的數(shù)據(jù)庫組件，因?yàn)樽x取配置的這個(gè)時(shí)候進(jìn)程還沒開始創(chuàng)建，很多配置還沒有載入，大部分組件都沒有初始化包括數(shù)據(jù)庫。
要做到你說的效果需要自己手動(dòng)初始化數(shù)據(jù)庫，建議用原生pdo去連，用完釋放pdo對(duì)象。切記不要在配置里提前初始化數(shù)據(jù)組件，會(huì)導(dǎo)致所有業(yè)務(wù)進(jìn)程共享數(shù)據(jù)庫連接，導(dǎo)致一些問題。