Class Insert in namespace com\setasign\SetaFramework\Database\Query in SetaFramework API Reference

Index

\com\setasign\SetaFramework
1. Database
  1. Query
    1. AbstractQuery
    2. Delete
    3. Insert
    4. Query
    5. Select
    6. Union
    7. Update

com\setasign\SetaFramework\Database\Query

Insert Class Query Insert

File: /SetaFramework/src/Database/Query/Insert.php

Class hierarchy

Insert

Implements

\com\setasign\SetaFramework\Database\SqlInterface

Summary

Constants

PART_SUBSELECT

private const Insert::PART_SUBSELECT = 'subselect'

Properties

$parts

protected array Insert::$parts = array()

Contains the single parts of the statement

Methods

__construct()

public Insert::__construct (

?string $tableName = null

)

Constructor

Parameters

$tableName : ?string

columns()

public Insert::columns (

array $columns

): static

Sets the columns-block

This will replace all existing columns

Parameters

$columns : array

getSql()

public Insert::getSql (

\com\setasign\SetaFramework\Database\QuoteInterface $quoteInterface

): string

Returns the query as string

Parameters

$quoteInterface : \com\setasign\SetaFramework\Database\QuoteInterface

getSqlColumns()

protected Insert::getSqlColumns (

\com\setasign\SetaFramework\Database\QuoteInterface $quoteInterface

): string

Parses the columns-block to string

Parameters

$quoteInterface : \com\setasign\SetaFramework\Database\QuoteInterface

getSqlValues()

protected Insert::getSqlValues (

\com\setasign\SetaFramework\Database\QuoteInterface $quoteInterface

): string

Parses the values-block to string

Parameters

$quoteInterface : \com\setasign\SetaFramework\Database\QuoteInterface

into()

public Insert::into (

string $tableName

): static

Set a table in into-block

Parameters

$tableName : string

reset()

public Insert::reset (

?string $part = null

): static

Resets a single part or all parts of the statement

Parameters

$part : ?string

Exceptions

Throws \InvalidArgumentException

select()

public Insert::select (

\Closure $select

): static

Parameters

$select : \Closure

set()

public Insert::set (

array $data

): static

Sets the columns and values

This method is for mysql-like syntax but dont create a set-syntax query. With this method is it only possible to insert one row.

Parameters

$data : array

values()

public Insert::values (

array $values

): static

Add a value

Parameters

$values : array