PHP Class CI_DB_pdo_pgsql_driver, TastyIgniter

Note: _DB is an extender class that the app controller creates dynamically based on whether the query builder class is being used or not.
Author: EllisLab Dev Team
Inheritance: extends CI_DB_pdo_driver
Afficher le fichier Open project: tastyigniter/tastyigniter

Méthodes publiques

Свойство Type Description
$schema string Database schema
$subdriver string Sub-driver

Protected Properties

Свойство Type Description
$_random_keyword array ORDER BY random keyword

Méthodes publiques

Méthode Description
__construct ( array $params ) : void Class constructor
db_connect ( boolean $persistent = FALSE ) : object Database connection
escape ( string $str ) : mixed "Smart" Escape String
field_data ( string $table ) : array Returns an object with field data
insert_id ( string $name = NULL ) : integer Insert ID
is_write_type ( $sql ) : boolean Determines if a query is a "write" type.
order_by ( string $orderby, string $direction = '', boolean $escape = NULL ) : object ORDER BY

Méthodes protégées

Méthode Description
_delete ( string $table ) : string Delete statement
_limit ( string $sql ) : string LIMIT
_list_columns ( string $table = '' ) : string List column query
_list_tables ( boolean $prefix_limit = FALSE ) : string Show table query
_update ( string $table, array $values ) : string Update statement
_update_batch ( string $table, array $values, string $index ) : string Update_Batch statement

Method Details

__construct() public méthode

Builds the DSN if not already set.
public __construct ( array $params ) : void
$params array
Résultat void

_delete() protected méthode

Generates a platform-specific delete string from the supplied data
protected _delete ( string $table ) : string
$table string
Résultat string

_limit() protected méthode

Generates a platform-specific LIMIT clause
protected _limit ( string $sql ) : string
$sql string SQL Query
Résultat string

_list_columns() protected méthode

Generates a platform-specific query string so that the column names can be fetched
protected _list_columns ( string $table = '' ) : string
$table string
Résultat string

_list_tables() protected méthode

Generates a platform-specific query string so that the table names can be fetched
protected _list_tables ( boolean $prefix_limit = FALSE ) : string
$prefix_limit boolean
Résultat string

_update() protected méthode

Generates a platform-specific update string from the supplied data
protected _update ( string $table, array $values ) : string
$table string
$values array
Résultat string

_update_batch() protected méthode

Generates a platform-specific batch update string from the supplied data
protected _update_batch ( string $table, array $values, string $index ) : string
$table string Table name
$values array Update data
$index string WHERE key
Résultat string

db_connect() public méthode

Database connection
public db_connect ( boolean $persistent = FALSE ) : object
$persistent boolean
Résultat object

escape() public méthode

Escapes data based on type
public escape ( string $str ) : mixed
$str string
Résultat mixed

field_data() public méthode

Returns an object with field data
public field_data ( string $table ) : array
$table string
Résultat array

insert_id() public méthode

Insert ID
public insert_id ( string $name = NULL ) : integer
$name string
Résultat integer

is_write_type() public méthode

Determines if a query is a "write" type.
public is_write_type ( $sql ) : boolean
Résultat boolean

order_by() public méthode

ORDER BY
public order_by ( string $orderby, string $direction = '', boolean $escape = NULL ) : object
$orderby string
$direction string ASC, DESC or RANDOM
$escape boolean
Résultat object

Property Details

$_random_keyword protected_oe property

ORDER BY random keyword
protected array $_random_keyword
Résultat array

$schema public_oe property

Database schema
public string $schema
Résultat string

$subdriver public_oe property

Sub-driver
public string $subdriver
Résultat string