<?php

namespace App\Console\Commands;

use App\Models\ChatLib;
use App\Models\ChatLog;
use Illuminate\Console\Command;

class ChatlibDatabase extends Command {

	/**
	 * The name and signature of the console command.
	 *
	 * @var string
	 */
	protected $signature = 'chatlib:database {which=de} {size=7}';

	/**
	 * The console command description.
	 *
	 * @var string
	 */
	protected $description = 'Update a ChatLib database';

	/**
	 * Execute the console command.
	 *
	 * @return int
	 */
	public function handle() {
		$count = 0;
		$start = time();

		$size = $this->argument('size');
		$lang = $this->argument('which');
		$db = new ChatLib($size);

		ChatLog::where('type', '=', 'chat')
			->where('banned', '=', false)
			->whereNotNull('evaluated_at')
			->where('created_at', '<', now()->sub(7, 'day'))
			->whereNotIn('classification', ['gg', 'gl', 'number', 'o7'])
			->where(function ($query) use ($lang) {
				$query->whereNull('detected_language');
				$query->orWhere('detected_language', '=', $lang);
			})
			->whereRaw('LENGTH(`text_content`) > 10')
			->chunk(5000, function ($msgs) use (&$count, $db) {
				foreach ($msgs as $msg) {
					$db->addMessage($msg);
					++$count;
				}
				$this->line($count);
			});

		$db->compile();
		$db->saveAs($lang);

		$this->line(
			number_format(time() - $start, 0).'s '.
			number_format(memory_get_usage() / 1024 / 1024, 3).'MB now '.
			number_format(memory_get_peak_usage() / 1024 / 1024, 3).'MB peak');

		return 0;
	}

}

?>