/** * Compile a rename column command. * * @param \Nova\Database\Schema\Blueprint $blueprint * @param \Nova\Support\Fluent $command * @param \Nova\Database\Connection $connection * @return array */ public function compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection) { $schema = $connection->getDoctrineSchemaManager(); $table = $this->getTablePrefix() . $blueprint->getTable(); $column = $connection->getDoctrineColumn($table, $command->from); $tableDiff = $this->getRenamedDiff($blueprint, $command, $column, $schema); return (array) $schema->getDatabasePlatform()->getAlterTableSQL($tableDiff); }
/** * Append the character set specifications to a command. * * @param string $sql * @param \Nova\Database\Connection $connection * @return string */ protected function compileCreateEncoding($sql, Connection $connection) { if (!is_null($charset = $connection->getConfig('charset'))) { $sql .= ' default character set ' . $charset; } if (!is_null($collation = $connection->getConfig('collation'))) { $sql .= ' collate ' . $collation; } return $sql; }
/** * Execute a Closure within a transaction. * * @param \Closure $callback * @return mixed * * @throws \Exception */ public function transaction(Closure $callback) { if ($this->getDriverName() == 'sqlsrv') { return parent::transaction($callback); } $this->pdo->exec('BEGIN TRAN'); try { $result = $callback($this); $this->pdo->exec('COMMIT TRAN'); } catch (\Exception $e) { $this->pdo->exec('ROLLBACK TRAN'); throw $e; } return $result; }
/** * Execute a Closure within a transaction. * * @param \Closure $callback * @return mixed * * @throws \Exception */ public function transaction(Closure $callback) { if ($this->getDriverName() == 'sqlsrv') { return parent::transaction($callback); } $this->pdo->exec('BEGIN TRAN'); // We'll simply execute the given callback within a try / catch block // and if we catch any exception we can rollback the transaction // so that none of the changes are persisted to the database. try { $result = $callback($this); $this->pdo->exec('COMMIT TRAN'); } catch (\Exception $e) { $this->pdo->exec('ROLLBACK TRAN'); throw $e; } return $result; }
/** * Retrieve a user by the given credentials. * * @param array $credentials * @return \Nova\Auth\UserInterface|null */ public function retrieveByCredentials(array $credentials) { // First we will add each credential element to the query as a where clause. // Then we can execute the query and, if we found a user, return it in a // generic "user" object that will be utilized by the Guard instances. $query = $this->conn->table($this->table); foreach ($credentials as $key => $value) { if (!str_contains($key, 'password')) { $query->where($key, $value); } } // Now we are ready to execute the query to see if we have an user matching // the given credentials. If not, we will just return nulls and indicate // that there are no matching users for these given credential arrays. $user = $query->first(); if (!is_null($user)) { return new GenericUser((array) $user); } }
/** * Get a query builder for the cache table. * * @return \Nova\Database\Query\Builder */ protected function table() { return $this->connection->table($this->table); }
/** * Compile a drop column command. * * @param \Nova\Database\Schema\Blueprint $blueprint * @param \Nova\Support\Fluent $command * @param \Nova\Database\Connection $connection * @return array */ public function compileDropColumn(Blueprint $blueprint, Fluent $command, Connection $connection) { $schema = $connection->getDoctrineSchemaManager(); $tableDiff = $this->getDoctrineTableDiff($blueprint, $schema); foreach ($command->columns as $name) { $column = $connection->getDoctrineColumn($blueprint->getTable(), $name); $tableDiff->removedColumns[$name] = $column; } return (array) $schema->getDatabasePlatform()->getAlterTableSQL($tableDiff); }
/** * Prepare the read write mode for database connection instance. * * @param \Nova\Database\Connection $connection * @param string $type * @return \Nova\Database\Connection */ protected function setPdoForType(Connection $connection, $type = null) { if ($type == 'read') { $connection->setPdo($connection->getReadPdo()); } else { if ($type == 'write') { $connection->setReadPdo($connection->getPdo()); } } return $connection; }
/** * Get the column listing for a given table. * * @param string $table * @return array */ public function getColumnListing($table) { $table = $this->connection->getTablePrefix() . $table; $results = $this->connection->select($this->grammar->compileColumnExists($table)); return $this->connection->getPostProcessor()->processColumnListing($results); }
/** * Create a raw database expression. * * @param mixed $value * @return \Nova\Database\Query\Expression */ public function raw($value) { return $this->connection->raw($value); }
/** * Create a new database query * * @return \Database\Query */ public function newQuery() { return $this->connection->table($this->table); }
/** * Get a fresh query builder instance for the table. * * @return \Nova\Database\Query\Builder */ protected function getQuery() { return $this->connection->table($this->table); }