<?php

declare(strict_types=1);

namespace Mosaico\Model;

use Mosaico\Model\BaseModel;

class UtilitiesModel extends BaseModel
{
    public function alterAutoIncrement(string $table, string $id = 'id'): void
    {
        $query = $this->connect()->multi_query("
			SET @m = (SELECT MAX(" . $id . ") + 1 FROM " . $table . ");
			SET @s = CONCAT('ALTER TABLE " . $table . " AUTO_INCREMENT=', @m);
			PREPARE stmt1 FROM @s;
			EXECUTE stmt1;
			DEALLOCATE PREPARE stmt1;
		");
    }

    public function showWarnings(): bool|object
    {
        $query = $this->connect()->query("
			SHOW WARNINGS
		");

        return $query;
    }
}