SimpleCrud\Database

Complexity

Total Complexity

36

Size/Duplication

Total Lines	258
Duplicated Lines	0 %

Coupling/Cohesion

Components	3
Dependencies	20

Importance

Changes

0

23 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	24	5
A	setTablesClasses()	0	6	1
A	getConfig()	0	4	1
A	setConfig()	0	6	1
A	getScheme()	0	4	1
A	getConnection()	0	4	1
A	select()	0	4	1
A	update()	0	4	1
A	delete()	0	4	1
A	insert()	0	4	1
A	setFieldFactory()	0	6	1
A	getFieldFactory()	0	4	1
A	getFieldFactories()	0	4	1
A	__get()	0	16	3
A	__isset()	0	4	1
A	execute()	0	7	1
A	executeTransaction()	0	20	4
A	lastInsertId()	0	4	1
A	beginTransaction()	0	10	2
A	commit()	0	7	2
A	rollBack()	0	7	2
A	inTransaction()	0	4	2
A	createDefaultFieldFactories()	0	15	1

<?php
declare(strict_types = 1);

namespace SimpleCrud;

use Atlas\Pdo\Connection;
use Atlas\Query\Bind;
use Atlas\Query\Delete;
use Atlas\Query\Insert;
use Atlas\Query\Select;
use Atlas\Query\Update;
use Exception;
use InvalidArgumentException;
use PDO;
use PDOStatement;
use SimpleCrud\Fields\Boolean;
use SimpleCrud\Fields\Date;
use SimpleCrud\Fields\Datetime;
use SimpleCrud\Fields\Decimal;
use SimpleCrud\Fields\Field;
use SimpleCrud\Fields\FieldFactory;
use SimpleCrud\Fields\Integer;
use SimpleCrud\Fields\Json;
use SimpleCrud\Fields\Point;
use SimpleCrud\Fields\Serializable;
use SimpleCrud\Fields\Set;
use SimpleCrud\Scheme\Mysql;
use SimpleCrud\Scheme\SchemeInterface;
use SimpleCrud\Scheme\Sqlite;

final class Database
{
    const CONFIG_LOCALE = 'locale';

    private $connection;
    private $scheme;
    private $tables = [];
    private $tablesClasses = [];
    private $inTransaction = false;
    private $onExecute;
    private $config = [];
    private $fieldFactories = [];

    public function __construct(PDO $pdo, SchemeInterface $scheme = null, array $fieldFactories = null)
    {
        $this->connection = new Connection($pdo);
        $this->scheme = $scheme;

        if ($scheme) {
            return;
        }

        $engine = $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);

        switch ($engine) {
            case 'mysql':
                $this->scheme = new Mysql($pdo);
                break;
            case 'sqlite':
                $this->scheme = new Sqlite($pdo);
                break;
            default:
                throw new RuntimeException(sprintf('Invalid engine type: %s', $engine));
        }

        $this->fieldFactories = $fieldFactories ?: self::createDefaultFieldFactories();
    }

    /**
     * Configure custom classes for some tables
     * [table => classname]
     */
    public function setTablesClasses(array $classes): self
    {
        $this->tablesClasses = $classes;

        return $this;
    }

    /**
     * Returns a config value
     */
    public function getConfig(string $name)
    {
        return $this->config[$name] ?? null;
    }

    /**
     * Set a config value
     * @param mixed $value
     */
    public function setConfig(string $name, $value): self
    {
        $this->config[$name] = $value;

        return $this;
    }

    /**
     * Return the scheme class
     */
    public function getScheme(): SchemeInterface
    {
        return $this->scheme;
    }

    /**
     * Returns the connection instance.
     */
    public function getConnection(): Connection
    {
        return $this->connection;
    }

    public function select(): Select
    {
        return new Select($this->connection, new Bind());
    }

    public function update(): Update
    {
        return new Update($this->connection, new Bind());
    }

    public function delete(): Delete
    {
        return new Delete($this->connection, new Bind());
    }

    public function insert(): Insert
    {
        return new Insert($this->connection, new Bind());
    }

    public function setFieldFactory(FieldFactory $fieldFactory): self
    {
        $this->fieldFactories[$fieldFactory->getClassName()] = $fieldFactory;

        return $this;
    }

    public function getFieldFactory(string $className): FieldFactory
    {
        return $this->fieldFactories[$className];
    }

    public function getFieldFactories(): array
    {
        return $this->fieldFactories;
    }

    /**
     * Magic method to initialize the tables in lazy mode.
     *
     * @throws SimpleCrudException If the table cannot be instantiated
     */
    public function __get(string $name): Table
    {
        if (isset($this->tables[$name])) {
            return $this->tables[$name];
        }

        if (!$this->__isset($name)) {
            throw new InvalidArgumentException(
                sprintf('The table "%s" does not exist', $name)
            );
        }

        $class = $this->tablesClasses[$name] ?? Table::class;

        return $this->tables[$name] = new $class($this, $name);
    }

    /**
     * Magic method to check if a table exists or not.
     */
    public function __isset(string $name): bool
    {
        return in_array($name, $this->getScheme()->getTables());
    }

    /**
     * Execute a query and returns the statement object with the result.
     *
     * @throws Exception
     */
    public function execute(string $query, array $marks = null): PDOStatement
    {
        $statement = $this->connection->prepare($query);
        $statement->execute($marks);

        return $statement;
    }

    /**
     * Execute a callable inside a transaction.
     *
     * @return mixed The callable returned value
     */
    public function executeTransaction(callable $callable)
    {
        try {
            $transaction = $this->beginTransaction();

            $return = $callable($this);

            if ($transaction) {
                $this->commit();
            }
        } catch (Exception $exception) {
            if ($transaction) {
                $this->rollBack();
            }

            throw $exception;
        }

        return $return;
    }

    /**
     * Returns the last insert id.
     */
    public function lastInsertId(): string
    {
        return $this->connection->lastInsertId();
    }

    /**
     * Starts a transaction if it's not started yet.
     */
    public function beginTransaction(): bool
    {
        if (!$this->inTransaction()) {
            $this->connection->beginTransaction();

            return $this->inTransaction = true;
        }

        return false;
    }

    /**
     * Commits the changes of the transaction to the database.
     */
    public function commit()
    {
        if ($this->inTransaction()) {
            $this->connection->commit();
            $this->inTransaction = false;
        }
    }

    /**
     * RollBack a transaction.
     */
    public function rollBack()
    {
        if ($this->inTransaction()) {
            $this->connection->rollBack();
            $this->inTransaction = false;
        }
    }

    /**
     * Check if there is a transaction opened currently in this adapter.
     */
    public function inTransaction()
    {
        return ($this->inTransaction === true) && ($this->connection->inTransaction() === true);
    }

    private static function createDefaultFieldFactories(): array
    {
        return [
            Boolean::class => Boolean::getFactory(),
            Date::class => Date::getFactory(),
            Datetime::class => Datetime::getFactory(),
            Decimal::class => Decimal::getFactory(),
            Field::class => Field::getFactory(),
            Integer::class => Integer::getFactory(),
            Json::class => Json::getFactory(),
            Point::class => Point::getFactory(),
            Set::class => Set::getFactory(),
            Serializable::class => Serializable::getFactory(),
        ];
    }
}