mindplay\sql\mysql\MySQLDatabase

Complexity

Total Complexity

9

Size/Duplication

Total Lines	83
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Test Coverage

Coverage

100%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	bootstrap()	0	12	1
A	createConnection()	0	4	1
A	quoteName()	0	4	1
A	quoteTableName()	0	6	2
A	select()	0	4	1
A	insert()	0	4	1
A	update()	0	4	1
A	delete()	0	4	1

<?php

namespace mindplay\sql\mysql;

use mindplay\sql\model\Database;
use mindplay\sql\model\DatabaseContainer;
use mindplay\sql\model\DatabaseContainerFactory;
use mindplay\sql\model\Driver;
use mindplay\sql\model\query\DeleteQuery;
use mindplay\sql\model\query\InsertQuery;
use mindplay\sql\model\query\UpdateQuery;
use mindplay\sql\model\schema\Table;
use mindplay\sql\model\types\BoolType;
use mindplay\sql\model\types\FloatType;
use PDO;

class MySQLDatabase extends Database implements Driver
{
    protected function bootstrap(DatabaseContainerFactory $factory)
    {
        $factory->set(Driver::class, $this);

        $factory->register(BoolType::class, function () {
            return BoolType::get(1, 0);
        });

        $factory->alias("scalar.boolean", BoolType::class);

        $factory->register("scalar.double", FloatType::class);
    }
    
    /**
     * @param PDO $pdo
     * 
     * @return MySQLConnection
     */
    public function createConnection(PDO $pdo)
    {
        return $this->container->create(MySQLConnection::class, ['pdo' => $pdo]);
    }

    /**
     * @inheritdoc
     */
    public function quoteName($name)
    {
        return '`' . $name . '`';
    }

    /**
     * @inheritdoc
     */
    public function quoteTableName($schema, $table)
    {
        return $schema
            ? "`{$schema}_{$table}`"
            : "`{$table}`";
    }

    /**
     * @param Table $from
     *
     * @return MySQLSelectQuery
     */
    public function select(Table $from)
    {
        return $this->container->create(MySQLSelectQuery::class, ['root' => $from]);
    }

    /**
     * @param Table $into
     *
     * @return InsertQuery
     */
    public function insert(Table $into)
    {
        return $this->container->create(InsertQuery::class, ['table' => $into]);
    }

    /**
     * @param Table $table
     *
     * @return UpdateQuery
     */
    public function update(Table $table)
    {
        return $this->container->create(UpdateQuery::class, ['root' => $table]);
    }

    /**
     * @param Table $table
     *
     * @return DeleteQuery
     */
    public function delete(Table $table)
    {
        return $this->container->create(DeleteQuery::class, ['root' => $table]);
    }
}