class Insert

Same name in this branch

SQLite specific implementation of InsertQuery.

We ignore all the default fields and use the clever SQLite syntax: INSERT INTO table DEFAULT VALUES for degenerated "default only" queries.

Hierarchy

class \Drupal\Core\Database\Query\Query implements PlaceholderInterface
- class \Drupal\Core\Database\Query\Insert
  - class \Drupal\Core\Database\Driver\sqlite\Insert

Expanded class hierarchy of Insert

1 string reference to 'Insert'

File

drupal/core/lib/Drupal/Core/Database/Driver/sqlite/Insert.php, line 19: Definition of Drupal\Core\Database\Driver\sqlite\Insert

Namespace

Drupal\Core\Database\Driver\sqlite

View source

class Insert extends QueryInsert {
  public function execute() {
    if (!$this
      ->preExecute()) {
      return NULL;
    }
    if (count($this->insertFields)) {
      return parent::execute();
    }
    else {
      return $this->connection
        ->query('INSERT INTO {' . $this->table . '} DEFAULT VALUES', array(), $this->queryOptions);
    }
  }
  public function __toString() {

    // Create a sanitized comment string to prepend to the query.
    $comments = $this->connection
      ->makeComment($this->comments);

    // Produce as many generic placeholders as necessary.
    $placeholders = array_fill(0, count($this->insertFields), '?');

    // If we're selecting from a SelectQuery, finish building the query and
    // pass it back, as any remaining options are irrelevant.
    if (!empty($this->fromQuery)) {
      return $comments . 'INSERT INTO {' . $this->table . '} (' . implode(', ', $this->insertFields) . ') ' . $this->fromQuery;
    }
    return $comments . 'INSERT INTO {' . $this->table . '} (' . implode(', ', $this->insertFields) . ') VALUES (' . implode(', ', $placeholders) . ')';
  }

}

Members

Name	Modifiers	Type	Description	Overrides
Insert::$defaultFields	protected	property	An array of fields that should be set to their database-defined defaults.
Insert::$fromQuery	protected	property	A SelectQuery object to fetch the rows that should be inserted.
Insert::$insertFields	protected	property	An array of fields on which to insert.
Insert::$insertValues	protected	property	A nested array of values to insert.
Insert::$table	protected	property	The table on which to insert.
Insert::execute	public	function	Executes the insert query. Overrides Insert::execute
Insert::fields	public	function	Adds a set of field->value pairs to be inserted.
Insert::from	public	function	Sets the fromQuery on this InsertQuery object.
Insert::preExecute	public	function	Preprocesses and validates the query.
Insert::useDefaults	public	function	Specifies fields for which the database defaults should be used.
Insert::values	public	function	Adds another set of values to the query to be inserted.
Insert::__construct	public	function	Constructs an Insert object. Overrides Query::__construct
Insert::__toString	public	function	Implements PHP magic __toString method to convert the query to a string. Overrides Insert::__toString
Query::$comments	protected	property	An array of comments that can be prepended to a query.
Query::$connection	protected	property	The connection object on which to run this query.
Query::$connectionKey	protected	property	The key of the connection object.
Query::$connectionTarget	protected	property	The target of the connection object.
Query::$nextPlaceholder	protected	property	The placeholder counter.
Query::$queryOptions	protected	property	The query options to pass on to the connection object.
Query::$uniqueIdentifier	protected	property	A unique identifier for this query object.
Query::comment	public	function	Adds a comment to the query.
Query::getComments	public	function	Returns a reference to the comments array for the query.
Query::nextPlaceholder	public	function	Gets the next placeholder value for this query object. Overrides PlaceholderInterface::nextPlaceholder
Query::uniqueIdentifier	public	function	Returns a unique identifier for this object. Overrides PlaceholderInterface::uniqueIdentifier
Query::__clone	public	function	Implements the magic __clone function.	1
Query::__sleep	public	function	Implements the magic __sleep function to disconnect from the database.
Query::__wakeup	public	function	Implements the magic __wakeup function to reconnect to the database.

Main menu

Search Drupal 8.x

API Navigation

class Insert

Hierarchy

File

Namespace

Members

Main menu

You are here

Search Drupal 8.x

API Navigation

class Insert

Hierarchy

File

Namespace

Members