<?php

namespace Battles\Models;

use Battles\Database\Db;

class Model
{
    protected static string $tableName = '';
    protected static string $primaryKey = '';
    protected array $columns = [];

    protected function getColumnValue($column)
    {
        return $this->columns[$column];
    }

    protected function setColumnValue($column, $value)
    {
        $this->columns[$column] = $value;
    }

    /**
     * Полная перезапись. Отсутствующие параметры превратятся в default|null.
     * @return void
     */
    protected function save()
    {
        $q = 'replace into ' . self::$tableName . ' (' . implode(', ', array_keys($this->columns)) . ') values(';
        $keys = [];
        foreach ($this->columns as $key => $value) {
            $keys[':' . $key] = $value;
        }
        $q .= implode(', ', array_keys($keys)) . ')';
        Db::getInstance()->execute($q, $keys);
    }

    protected function updateByPrimaryKey()
    {
        $q = 'update ' . self::$tableName . ' set ';
        $keys = [];
        foreach ($this->columns as $key => $value) {
            $keys[':' . $key] = $value;
            $q .= $key . ' = :' . $key . ', ';
        }
        $q = rtrim($q, ',');
        $q .= 'where ' . self::$primaryKey . ' = :' . self::$primaryKey;
        Db::getInstance()->execute($q, $keys);
    }
}