| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141 |
- <?php
- namespace Illuminate\Database;
- use Exception;
- use Illuminate\Database\Query\Grammars\SQLiteGrammar as QueryGrammar;
- use Illuminate\Database\Query\Processors\SQLiteProcessor;
- use Illuminate\Database\Schema\Grammars\SQLiteGrammar as SchemaGrammar;
- use Illuminate\Database\Schema\SQLiteBuilder;
- use Illuminate\Database\Schema\SqliteSchemaState;
- use Illuminate\Filesystem\Filesystem;
- class SQLiteConnection extends Connection
- {
- /**
- * Create a new database connection instance.
- *
- * @param \PDO|\Closure $pdo
- * @param string $database
- * @param string $tablePrefix
- * @param array $config
- * @return void
- */
- public function __construct($pdo, $database = '', $tablePrefix = '', array $config = [])
- {
- parent::__construct($pdo, $database, $tablePrefix, $config);
- $enableForeignKeyConstraints = $this->getForeignKeyConstraintsConfigurationValue();
- if ($enableForeignKeyConstraints === null) {
- return;
- }
- $schemaBuilder = $this->getSchemaBuilder();
- try {
- $enableForeignKeyConstraints
- ? $schemaBuilder->enableForeignKeyConstraints()
- : $schemaBuilder->disableForeignKeyConstraints();
- } catch (QueryException $e) {
- if (! $e->getPrevious() instanceof SQLiteDatabaseDoesNotExistException) {
- throw $e;
- }
- }
- }
- /**
- * Escape a binary value for safe SQL embedding.
- *
- * @param string $value
- * @return string
- */
- protected function escapeBinary($value)
- {
- $hex = bin2hex($value);
- return "x'{$hex}'";
- }
- /**
- * Determine if the given database exception was caused by a unique constraint violation.
- *
- * @param \Exception $exception
- * @return bool
- */
- protected function isUniqueConstraintError(Exception $exception)
- {
- return boolval(preg_match('#(column(s)? .* (is|are) not unique|UNIQUE constraint failed: .*)#i', $exception->getMessage()));
- }
- /**
- * Get the default query grammar instance.
- *
- * @return \Illuminate\Database\Query\Grammars\SQLiteGrammar
- */
- protected function getDefaultQueryGrammar()
- {
- ($grammar = new QueryGrammar)->setConnection($this);
- return $this->withTablePrefix($grammar);
- }
- /**
- * Get a schema builder instance for the connection.
- *
- * @return \Illuminate\Database\Schema\SQLiteBuilder
- */
- public function getSchemaBuilder()
- {
- if (is_null($this->schemaGrammar)) {
- $this->useDefaultSchemaGrammar();
- }
- return new SQLiteBuilder($this);
- }
- /**
- * Get the default schema grammar instance.
- *
- * @return \Illuminate\Database\Schema\Grammars\SQLiteGrammar
- */
- protected function getDefaultSchemaGrammar()
- {
- ($grammar = new SchemaGrammar)->setConnection($this);
- return $this->withTablePrefix($grammar);
- }
- /**
- * Get the schema state for the connection.
- *
- * @param \Illuminate\Filesystem\Filesystem|null $files
- * @param callable|null $processFactory
- *
- * @throws \RuntimeException
- */
- public function getSchemaState(?Filesystem $files = null, ?callable $processFactory = null)
- {
- return new SqliteSchemaState($this, $files, $processFactory);
- }
- /**
- * Get the default post processor instance.
- *
- * @return \Illuminate\Database\Query\Processors\SQLiteProcessor
- */
- protected function getDefaultPostProcessor()
- {
- return new SQLiteProcessor;
- }
- /**
- * Get the database connection foreign key constraints configuration option.
- *
- * @return bool|null
- */
- protected function getForeignKeyConstraintsConfigurationValue()
- {
- return $this->getConfig('foreign_key_constraints');
- }
- }
|