\CodeIgniter\Database\PostgreBuilder

Builder for Postgre

Summary

Methods

Properties

Constants

orderBy()
increment()
decrement()
_like_statement()

No public properties found

No constants found

_limit()
_updateBatch()
_delete()
_truncate()

$randomKeyword

N/A

No private methods found

No private properties found

N/A

File: src/System/Database/Postgre/Builder.php
Package: CodeIgniter
Class hierarchy: \CodeIgniter\Database\BaseBuilder

\CodeIgniter\Database\Postgre\Builder

Properties

$randomKeyword

$randomKeyword : array

ORDER BY random keyword

Type

array

Methods

orderBy()

orderBy(string  $orderBy, string  $direction = '', boolean  $escape = null) : \CodeIgniter\Database\BaseBuilder

ORDER BY

Parameters

string	$orderBy
string	$direction	ASC, DESC or RANDOM
boolean	$escape

Returns

\CodeIgniter\Database\BaseBuilder

increment()

increment(string  $column, integer  $value = 1) : mixed

Increments a numeric column by the specified value.

Parameters

string	$column
integer	$value

Returns

mixed

decrement()

decrement(string  $column, integer  $value = 1) : mixed

Decrements a numeric column by the specified value.

Parameters

string	$column
integer	$value

Returns

mixed

_like_statement()

_like_statement(string  $prefix = null, string  $column, string  $not = null, string  $bind, boolean  $insensitiveSearch = false) : string

Platform independent LIKE statement builder.

In PostgreSQL, the ILIKE operator will perform case insensitive searches according to the current locale.

Parameters

string	$prefix
string	$column
string	$not
string	$bind
boolean	$insensitiveSearch

Returns

string —

$like_statement

_limit()

_limit(string  $sql) : string

LIMIT string

Generates a platform-specific LIMIT clause.

Parameters

string

$sql

SQL Query

Returns

string

_updateBatch()

_updateBatch(string  $table, array  $values, string  $index) : string

Update_Batch statement

Generates a platform-specific batch update string from the supplied data

Parameters

string	$table	Table name
array	$values	Update data
string	$index	WHERE key

Returns

string

_delete()

_delete(string  $table) : string

Delete statement

Generates a platform-specific delete string from the supplied data

Parameters

string

$table

The table name

Returns

string

_truncate()

_truncate(string  $table) : string

Truncate statement

Generates a platform-specific truncate string from the supplied data

If the database does not support the truncate() command, then this method maps to 'DELETE FROM table'

Parameters

string

$table

The table name

Returns

string