Index

  1. \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

Query Class Query

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

Helper class to create a query

Class hierarchy

Summary

Static Methods

Constants

Constants

PART_COLUMNS

public const Query::PART_COLUMNS = 'columns'

PART_DISTINCT

public const Query::PART_DISTINCT = 'distinct'

PART_FROM

public const Query::PART_FROM = 'from'

PART_GROUP_BY

public const Query::PART_GROUP_BY = 'groupBy'

PART_HAVING

public const Query::PART_HAVING = 'having'

PART_JOIN

public const Query::PART_JOIN = 'join'

PART_LIMIT

public const Query::PART_LIMIT = 'limit'

PART_LOCK

public const Query::PART_LOCK = 'lock'

PART_OFFSET

public const Query::PART_OFFSET = 'offset'

PART_ORDER_BY

public const Query::PART_ORDER_BY = 'orderBy'

PART_TABLE_NAME

public const Query::PART_TABLE_NAME = 'tableName'

PART_VALUES

public const Query::PART_VALUES = 'values'

PART_WHERE

public const Query::PART_WHERE = 'where'

PART_WITH

public const Query::PART_WITH = 'with'

PART_WITH_RECURSIVE

public const Query::PART_WITH_RECURSIVE = 'withRecursive'

Static Methods

delete()

public static Query::delete (
string|string[]|null $table = null
): Delete
Parameters
$table : string|string[]|null
 
See

evaluateSelectClosure()

public static Query::evaluateSelectClosure (): string

Executes a closure with the params (Query\Select $select, Database $quoteInterface) and after this the method returns the select-statement as subquery

Parameters
$closure : \Closure
 
$quoteInterface : \com\setasign\SetaFramework\Database\QuoteInterface
 
Return Values

Subquery

insert()

public static Query::insert (
?string $table = null
): Insert
Parameters
$table : ?string
 
See

select()

public static Query::select (): Select
Parameters
$columns : string|\com\setasign\SetaFramework\Database\ExpressionInterface|array
 
See

update()

public static Query::update (
?string $table = null
): Update
Parameters
$table : ?string
 
See

© 2025 Setasign GmbH & Co. KG · Contact / Imprint · Data Privacy Statement (German)