mindplay\sql\postgres\PostgresDatabase

Complexity

Total Complexity

9

Size/Duplication

Total Lines	76
Duplicated Lines	0 %

Test Coverage

Coverage

91.3%

Importance

Changes	1
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	insert()	0	3	1
A	delete()	0	3	1
A	createConnection()	0	3	1
A	update()	0	3	1
A	quoteTableName()	0	5	2
A	select()	0	3	1
A	quoteName()	0	3	1
A	bootstrap()	0	11	1

<?php

namespace mindplay\sql\postgres;

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

class PostgresDatabase extends Database implements Driver
{
    protected function bootstrap(DatabaseContainerFactory $factory): void
    {
        $factory->set(Driver::class, $this);
        
        $factory->register(BoolType::class, function () {
            return BoolType::get(true, false);
        });
        
        $factory->alias("scalar.boolean", BoolType::class);

        $factory->register("scalar.double", FloatType::class);
    }

    public function createConnection(PDO $pdo): PostgresConnection
    {
        return $this->container->create(PostgresConnection::class, ['pdo' => $pdo]);
    }

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

    /**
     * @inheritdoc
     */
    public function quoteTableName(string|null $schema, string $table): string
    {
        return $schema
            ? '"' . $schema . '"."' . $table . '"'
            : '"' . $table . '"';
    }

    /**
     * @param Table $from
     *
     * @return PostgresSelectQuery
     */
    public function select(Table $from)
    {
        return $this->container->create(PostgresSelectQuery::class, [Table::class => $from]);
    }
    
    /**
     * @param Table $into
     *
     * @return PostgresInsertQuery
     */
    public function insert(Table $into)
    {
        return $this->container->create(PostgresInsertQuery::class, [Table::class => $into]);
    }

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

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