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.

See link: http://codeigniter.com/user_guide/database/

Author: EllisLab Dev Team

Inheritance: extends CI_DB_pdo_driver

Mostra file Open project: tastyigniter/tastyigniter

Public Properties

Property	Type	Description
$schema	string	Database schema
$subdriver	string	Sub-driver

Protected Properties

Property	Type	Description
$_random_keyword	array	ORDER BY random keyword

Public Methods

Method	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

Protected Methods

Method	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 method

Builds the DSN if not already set.

public __construct ( array $params ) : void
$params	array
return	void

_delete() protected method

Generates a platform-specific delete string from the supplied data

protected _delete ( string $table ) : string
$table	string
return	string

_limit() protected method

Generates a platform-specific LIMIT clause

protected _limit ( string $sql ) : string
$sql	string	SQL Query
return	string

_list_columns() protected method

Generates a platform-specific query string so that the column names can be fetched

protected _list_columns ( string $table = '' ) : string
$table	string
return	string

_list_tables() protected method

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
return	string

_update() protected method

Generates a platform-specific update string from the supplied data

protected _update ( string $table, array $values ) : string
$table	string
$values	array
return	string

_update_batch() protected method

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
return	string

db_connect() public method

Database connection

public db_connect ( boolean $persistent = FALSE ) : object
$persistent	boolean
return	object

escape() public method

Escapes data based on type

public escape ( string $str ) : mixed
$str	string
return	mixed

field_data() public method

Returns an object with field data

public field_data ( string $table ) : array
$table	string
return	array

insert_id() public method

Insert ID

public insert_id ( string $name = NULL ) : integer
$name	string
return	integer

is_write_type() public method

Determines if a query is a "write" type.

public is_write_type ( $sql ) : boolean
return	boolean

order_by() public method

ORDER BY

public order_by ( string $orderby, string $direction = '', boolean $escape = NULL ) : object
$orderby	string
$direction	string	ASC, DESC or RANDOM
$escape	boolean
return	object

Property Details

$_random_keyword protected_oe property

ORDER BY random keyword

protected array $_random_keyword
return	array

$schema public_oe property

Database schema

public string $schema
return	string

$subdriver public_oe property

Sub-driver

public string $subdriver
return	string