Documentation

Core_QueryBuilder_Optimize extends Core_QueryBuilder_Statement

OPTIMIZE Database Abstraction Layer (DBAL)

http://dev.mysql.com/doc/refman/5.5/en/optimize-table.html

$oCore_QueryBuilder_Optimize = Core_QueryBuilder::optimize('TableName') ->execute();
Tags
subpackage

Core\Querybuilder

version
7.x
author

Hostmake LLC

copyright

© 2005-2024 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru

Table of Contents

Properties

$_dataBase  : mixed
DataBase
$_queryType  : mixed
DataBase Query Type 8 - OPTIMIZE
$_table  : string
Table name
$_unbuffered  : mixed
Query without fetching and buffering the result rows

Methods

__call()  : mixed
Triggered when invoking inaccessible methods in an object context
__construct()  : mixed
Constructor.
__set()  : self
Run when writing data to inaccessible properties
build()  : string
Build the SQL query
clearLimit()  : self
Clear LIMIT
clearOffset()  : self
Clear OFFSET
execute()  : Core_DataBase
Execute query
getDataBase()  : Core_DataBase
Get DataBase
setDataBase()  : Core_QueryBuilder_Statement
Set DataBase
table()  : Core_QueryBuilder_Optimize
Set table name
unbuffered()  : self
Query without fetching and buffering the result rows
_isObjectSelect()  : bool
Is $object Core_QueryBuilder_Select
_quoteColumns()  : array<string|int, mixed>
Quote columns
_quoteValues()  : array<string|int, mixed>
Quote arary of values

Properties

$_dataBase

DataBase

protected mixed $_dataBase = \NULL

$_queryType

DataBase Query Type 8 - OPTIMIZE

protected mixed $_queryType = 8

$_table

Table name

protected string $_table = \NULL

$_unbuffered

Query without fetching and buffering the result rows

protected mixed $_unbuffered = \FALSE

Methods

__call()

Triggered when invoking inaccessible methods in an object context

public __call(string $name, array<string|int, mixed> $arguments) : mixed
Parameters
$name : string

method name

$arguments : array<string|int, mixed>

arguments

__construct()

Constructor.

public __construct([array<string|int, mixed> $args = array() ]) : mixed
Parameters
$args : array<string|int, mixed> = array()

list of arguments $oCore_QueryBuilder_Optimize = Core_QueryBuilder::optimize('TableName') ->execute();

Tags
see
table()

__set()

Run when writing data to inaccessible properties

public __set(string $property, string $value) : self
Parameters
$property : string

property name

$value : string

property value

Return values
self

build()

Build the SQL query

public build() : string
Return values
string

The SQL query

clearLimit()

Clear LIMIT

public clearLimit() : self
Return values
self

clearOffset()

Clear OFFSET

public clearOffset() : self
Return values
self

unbuffered()

Query without fetching and buffering the result rows

public unbuffered(bool $unbuffered) : self
Parameters
$unbuffered : bool
Return values
self

_isObjectSelect()

Is $object Core_QueryBuilder_Select

protected _isObjectSelect( $object) : bool
Parameters
$object :
Return values
bool

_quoteColumns()

Quote columns

protected _quoteColumns(array<string|int, mixed> $array) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
Return values
array<string|int, mixed>

_quoteValues()

Quote arary of values

protected _quoteValues(array<string|int, mixed> $array) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
Return values
array<string|int, mixed>

        
On this page

Search results