Documentation

SQL
in package

Table of Contents

Constants

DELETE_TYPE  = 2
INSERT_TYPE  = 3
SELECT_TYPE  = 0
UPDATE_TYPE  = 1

Properties

$delete_reason  : string
$entity  : mixed
$extra_fields_for_select_security  : mixed
$fetch_all  : bool
$fields  : string|null
$fields_array  : array<string|int, mixed>
$fields_values  : array<string|int, mixed>
$from_as  : string|null
$group_by  : string
$join_stmt  : string
$join_values  : array<string|int, mixed>
$limit_stmt  : string
$order_by  : string
$query_type  : int
$select_for_insert  : string|null
$table  : mixed
$table_pk  : mixed
$tracking  : mixed
$where  : string|null
$where_array  : array<string|int, mixed>|null
$where_values  : array<string|int, mixed>|null

Methods

__construct()  : mixed
delete()  : mixed
from_as()  : mixed
getDeleteReason()  : mixed
getEntity()  : mixed
getExtraFieldsForSelectSecurity()  : mixed
getFetchAll()  : mixed
getFieldsInArrayFormat()  : array<string|int, mixed>
getJoinInStringFormat()  : array<string|int, mixed>
getQueryType()  : mixed
getSQLString()  : mixed
getTable()  : mixed
getTablePk()  : mixed
getTracking()  : mixed
getWhereFieldsInArrayFormat()  : array<string|int, mixed>|null
getWhereInStringFormat()  : array<string|int, mixed>
group_by()  : mixed
insert()  : mixed
join()  : mixed
limit()  : mixed
order_by()  : mixed
select()  : mixed
setExclusionFieldsForSelectSecurity()  : mixed
setExtraFieldsForSelectSecurity()  : mixed
setFetchAll()  : mixed
setSelectForInsert()  : mixed
update()  : mixed
where()  : mixed
whereFieldsArrayToString()  : mixed
getDeleteSQLString()  : mixed
getInsertSQLString()  : mixed
getSelectSQLString()  : mixed
getUpdateSQLString()  : mixed

Constants

DELETE_TYPE

public mixed DELETE_TYPE = 2

INSERT_TYPE

public mixed INSERT_TYPE = 3

SELECT_TYPE

public mixed SELECT_TYPE = 0

UPDATE_TYPE

public mixed UPDATE_TYPE = 1

Properties

$delete_reason

private string $delete_reason = ''

$entity

private mixed $entity

$extra_fields_for_select_security

private mixed $extra_fields_for_select_security = []

$fetch_all

private bool $fetch_all = false

$fields

private string|null $fields = null

$fields_array

private array<string|int, mixed> $fields_array = []

$fields_values

private array<string|int, mixed> $fields_values = []

$from_as

private string|null $from_as = null

$group_by

private string $group_by = ''

$join_stmt

private string $join_stmt = ''

$join_values

private array<string|int, mixed> $join_values = []

$limit_stmt

private string $limit_stmt = ''

$order_by

private string $order_by = ''

$query_type

private int $query_type = -1

$select_for_insert

private string|null $select_for_insert = null

$table

private mixed $table

$table_pk

private mixed $table_pk

$tracking

private mixed $tracking

$where

private string|null $where = null

$where_array

private array<string|int, mixed>|null $where_array = null

$where_values

private array<string|int, mixed>|null $where_values = null

Methods

__construct()

public __construct(mixed $entity) : mixed
Parameters
$entity : mixed

delete()

public delete(mixed $reason) : mixed
Parameters
$reason : mixed

from_as()

public from_as(string $alias) : mixed
Parameters
$alias : string

getDeleteReason()

public getDeleteReason() : mixed

getEntity()

public getEntity() : mixed

getExtraFieldsForSelectSecurity()

public getExtraFieldsForSelectSecurity() : mixed

getFetchAll()

public getFetchAll() : mixed

getFieldsInArrayFormat()

public getFieldsInArrayFormat() : array<string|int, mixed>
Return values
array<string|int, mixed>

getJoinInStringFormat()

public getJoinInStringFormat() : array<string|int, mixed>
Return values
array<string|int, mixed>

getQueryType()

public getQueryType() : mixed

getSQLString()

public getSQLString() : mixed

getTable()

public getTable() : mixed

getTablePk()

public getTablePk() : mixed

getTracking()

public getTracking() : mixed

getWhereFieldsInArrayFormat()

public getWhereFieldsInArrayFormat() : array<string|int, mixed>|null
Return values
array<string|int, mixed>|null

getWhereInStringFormat()

public getWhereInStringFormat() : array<string|int, mixed>
Return values
array<string|int, mixed>

group_by()

public group_by(mixed $stmt) : mixed
Parameters
$stmt : mixed

insert()

public insert(mixed $fields) : mixed
Parameters
$fields : mixed

join()

public join(mixed $stmt[, mixed $values = [] ]) : mixed
Parameters
$stmt : mixed
$values : mixed = []

limit()

public limit(mixed $stmt) : mixed
Parameters
$stmt : mixed

order_by()

public order_by(mixed $stmt) : mixed
Parameters
$stmt : mixed

select()

public select(mixed $fields) : mixed
Parameters
$fields : mixed

setExclusionFieldsForSelectSecurity()

public setExclusionFieldsForSelectSecurity(array<string|int, mixed> $fields) : mixed
Parameters
$fields : array<string|int, mixed>

setExtraFieldsForSelectSecurity()

public setExtraFieldsForSelectSecurity(array<string|int, mixed> $fields) : mixed
Parameters
$fields : array<string|int, mixed>

setFetchAll()

public setFetchAll([mixed $state = true ]) : mixed
Parameters
$state : mixed = true

setSelectForInsert()

public setSelectForInsert(mixed $select_for_insert) : mixed
Parameters
$select_for_insert : mixed

update()

public update(mixed $fields) : mixed
Parameters
$fields : mixed

where()

public where(mixed $fields[, mixed $values = [] ]) : mixed
Parameters
$fields : mixed
$values : mixed = []

whereFieldsArrayToString()

public static whereFieldsArrayToString(array<string|int, mixed> $where_array) : mixed
Parameters
$where_array : array<string|int, mixed>

getDeleteSQLString()

private getDeleteSQLString() : mixed

getInsertSQLString()

private getInsertSQLString() : mixed

getSelectSQLString()

private getSelectSQLString() : mixed

getUpdateSQLString()

private getUpdateSQLString() : mixed 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results