File Driver/SQLiteDriver.php | ICanBoogie/ActiveRecord 2.3.x

 1  2  3  4  5  6  7  8  9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86

<?php

/*
 * This file is part of the ICanBoogie package.
 *
 * (c) Olivier Laviale <olivier.laviale@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace ICanBoogie\ActiveRecord\Driver;

use ICanBoogie\ActiveRecord\Schema;
use ICanBoogie\ActiveRecord\SchemaColumn;

/**
 * Connection driver for SQLite.
 */
class SQLiteDriver extends MySQLDriver
{
    /**
     * @inheritdoc
     */
    public function render_column(SchemaColumn $column)
    {
        if ($column->primary && $column->type == SchemaColumn::TYPE_INTEGER)
        {
            return "INTEGER NOT NULL";
        }

        return implode(' ', array_filter([

            $column->formatted_type,
            $column->formatted_attributes,
            $column->formatted_null,
            $column->formatted_auto_increment,
            $column->formatted_default,
            $column->formatted_comment

        ]));
    }

    /**
     * @inheritdoc
     */
    protected function render_create_table($unprefixed_table_name, Schema $schema)
    {
        $quoted_table_name = $this->resolve_quoted_table_name($unprefixed_table_name);
        $lines = $this->render_create_table_lines($schema);
        $lines[] = $this->render_create_table_primary_key($schema);

        return "CREATE TABLE $quoted_table_name\n(\n\t" . implode(",\n\t", array_filter($lines)) . "\n)";
    }

    /**
     * @inheritdoc
     */
    public function table_exists($unprefixed_name)
    {
        $name = $this->resolve_table_name($unprefixed_name);

        $tables = $this->connection
            ->query('SELECT name FROM sqlite_master WHERE type = "table" AND name = ?', [ $name ])
            ->all(\PDO::FETCH_COLUMN);

        return !!$tables;
    }

    /**
     * @inheritdoc
     */
    public function optimize()
    {
        $this->connection->exec('VACUUM');
    }

    /**
     * @inheritdoc
     */
    protected function resolve_index_name($unprefixed_table_name, $index_id)
    {
        return $index_id . '_' . substr(sha1($unprefixed_table_name), 0 , 8);
    }
}

Namespaces

Classes