Namespaces

• ICanBoogie
  • ActiveRecord
    • Driver

Classes

• ICanBoogie\ActiveRecord
• ICanBoogie\ActiveRecord\ActiveRecordCacheBase
• ICanBoogie\ActiveRecord\BelongsToRelation
• ICanBoogie\ActiveRecord\Connection
• ICanBoogie\ActiveRecord\ConnectionCollection
• ICanBoogie\ActiveRecord\ConnectionOptions
• ICanBoogie\ActiveRecord\DateTimePropertySupport
• ICanBoogie\ActiveRecord\Driver\BasicDriver
• ICanBoogie\ActiveRecord\Driver\MySQLDriver
• ICanBoogie\ActiveRecord\Driver\SQLiteDriver
• ICanBoogie\ActiveRecord\HasManyRelation
• ICanBoogie\ActiveRecord\Helpers
• ICanBoogie\ActiveRecord\Model
• ICanBoogie\ActiveRecord\ModelCollection
• ICanBoogie\ActiveRecord\Query
• ICanBoogie\ActiveRecord\Relation
• ICanBoogie\ActiveRecord\RelationCollection
• ICanBoogie\ActiveRecord\RelationNotDefined
• ICanBoogie\ActiveRecord\RuntimeActiveRecordCache
• ICanBoogie\ActiveRecord\Schema
• ICanBoogie\ActiveRecord\SchemaColumn
• ICanBoogie\ActiveRecord\Statement
• ICanBoogie\ActiveRecord\Table

Interfaces

• ICanBoogie\ActiveRecord\ActiveRecordCache
• ICanBoogie\ActiveRecord\Driver
• ICanBoogie\ActiveRecord\Exception

Traits

• ICanBoogie\ActiveRecord\CreatedAtProperty
• ICanBoogie\ActiveRecord\DateProperty
• ICanBoogie\ActiveRecord\DateTimeProperty
• ICanBoogie\ActiveRecord\FinishAtProperty
• ICanBoogie\ActiveRecord\FinishedAtProperty
• ICanBoogie\ActiveRecord\StartAtProperty
• ICanBoogie\ActiveRecord\StartedAtProperty
• ICanBoogie\ActiveRecord\UpdatedAtProperty

Exceptions

• ICanBoogie\ActiveRecord\ActiveRecordClassNotValid
• ICanBoogie\ActiveRecord\ConnectionAlreadyEstablished
• ICanBoogie\ActiveRecord\ConnectionNotDefined
• ICanBoogie\ActiveRecord\ConnectionNotEstablished
• ICanBoogie\ActiveRecord\DriverNotDefined
• ICanBoogie\ActiveRecord\ModelAlreadyInstantiated
• ICanBoogie\ActiveRecord\ModelNotDefined
• ICanBoogie\ActiveRecord\RecordNotFound
• ICanBoogie\ActiveRecord\ScopeNotDefined
• ICanBoogie\ActiveRecord\StatementInvocationFailed
• ICanBoogie\ActiveRecord\StatementNotValid
• ICanBoogie\ActiveRecord\UnableToSetFetchMode

Functions

• ICanBoogie\ActiveRecord\extract_charset_and_collate
• ICanBoogie\ActiveRecord\get_model

 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);
    }
}