3 namespace App\Console\Commands;
5 use App\Models\ChatLib;
6 use App\Models\ChatLog;
7 use Illuminate\Console\Command;
9 class ChatlibDatabase extends Command {
12 * The name and signature of the console command.
16 protected $signature = 'chatlib:database';
19 * The console command description.
23 protected $description = 'Updates the ChatLib database';
26 * Execute the console command.
30 public function handle() {
34 ChatLog::where('type', '=', 'chat')
35 ->where('banned', '=', false)
36 ->whereNotNull('evaluated_at')
37 ->chunk(5000, function ($msgs) use ($de, $en) {
38 foreach ($msgs as $msg) {
39 if ($msg->detected_language === 'de') {
40 $de->addMessage($msg);
41 } else if ($msg->detected_language === 'en') {
42 $en->addMessage($msg);
43 } else if (is_null($msg->detected_language)) {
44 $de->addMessage($msg);
45 $en->addMessage($msg);
54 for ($i = 0; $i < 50; ++$i) {
55 $this->line($de->generate());
58 for ($i = 0; $i < 50; ++$i) {
59 $this->line($en->generate());