<?php

namespace Mosaico\Database;

class DB
{
    private object $adaptor;

    /**
     * Constructor
     */
    public function __construct(
        string $driver,
        string $hostname,
        string $username,
        string $password,
        string $database,
        int $port = 3306
    ) {
        $class = 'Mosaico\Database\Drivers\\' . $driver;

        if (class_exists($class)) {
            $this->adaptor = new $class($hostname, $username, $password, $database, $port);
        } else {
            throw new \Exception('Error: Could not load database adaptor ' . $driver . '!');
        }
    }

    /**
     * Query
     */
    public function query(string $sql): bool|object
    {
        return $this->adaptor->query($sql);
    }

    /**
     * Escape
     * @return	string	returns escaped value
     */
    public function escape(string $value): string
    {
        return $this->adaptor->escape($value);
    }

    /**
     * Count Affected
     *
     * Gets the total number of affected rows from the last query
     *
     * @return	int	returns the total number of affected rows.
     */
    public function countAffected(): int
    {
        return $this->adaptor->countAffected();
    }

    /**
     * Get Last ID
     *
     * Get the last ID gets the primary key that was returned after creating a row in a table.
     *
     * @return	int returns last ID
     */
    public function getLastId(): int
    {
        return $this->adaptor->getLastId();
    }

    /**
     * Is Connected
     *
     * Checks if a DB connection is active.
     */
    public function isConnected(): bool
    {
        return $this->adaptor->isConnected();
    }
}