libraries/drivers/Database/Pdosqlite – Kohana API 2.3 Documentation

system/libraries/drivers/Database/Pdosqlite.php

Class: Database_Pdosqlite_Driver

class Database_Pdosqlite_Driver extends Database_Driver

Methods

Database_Pdosqlite_Driver -> __construct

public function __construct

Parameters:

config

Database_Pdosqlite_Driver -> connect

public function connect

Database_Pdosqlite_Driver -> query

public function query

Parameters:

sql

Database_Pdosqlite_Driver -> set_charset

public function set_charset

Parameters:

charset

Database_Pdosqlite_Driver -> escape_table

public function escape_table

Parameters:

table

Database_Pdosqlite_Driver -> escape_column

public function escape_column

Parameters:

column

Database_Pdosqlite_Driver -> limit

public function limit

Parameters:

limit
offset
(int 0)

Database_Pdosqlite_Driver -> compile_select

public function compile_select

Parameters:

database

Database_Pdosqlite_Driver -> escape_str

public function escape_str

Parameters:

str

Database_Pdosqlite_Driver -> list_tables

public function list_tables

Database_Pdosqlite_Driver -> show_error

public function show_error

Database_Pdosqlite_Driver -> list_fields

public function list_fields

Parameters:

table
query
(FALSE)

Database_Pdosqlite_Driver -> field_data

public function field_data

Parameters:

table

Database_Pdosqlite_Driver -> version

public function version

Version number query string

Access: public

Return: string

Database_Pdosqlite_Driver -> delete

public function delete

Builds a DELETE query.

Parameters:

string table
table name
array where
where clause

Return: string

Database_Pdosqlite_Driver -> update

public function update

Builds an UPDATE query.

Parameters:

string table
table name
array values
key => value pairs
array where
where clause

Return: string

Database_Pdosqlite_Driver -> where

public function where

Builds a WHERE portion of a query.

Parameters:

mixed key
key
string value
value
string type
type
int num_wheres
number of where clauses
boolean quote
escape the value

Return: string

Database_Pdosqlite_Driver -> like

public function like

Builds a LIKE portion of a query.

Parameters:

mixed field
field name
string match
value to match with field
boolean auto
add wildcards before and after the match
string type
clause type (AND or OR)
int num_likes
number of likes

Return: string

Database_Pdosqlite_Driver -> notlike

public function notlike

Builds a NOT LIKE portion of a query.

Parameters:

mixed field
field name
string match
value to match with field
string auto
clause type (AND or OR)
int type
number of likes
num_likes

Return: string

Database_Pdosqlite_Driver -> regex

public function regex

Builds a REGEX portion of a query.

Parameters:

string field
field name
string match
value to match with field
string type
clause type (AND or OR)
integer num_regexs
number of regexes

Return: string

Database_Pdosqlite_Driver -> notregex

public function notregex

Builds a NOT REGEX portion of a query.

Parameters:

string field
field name
string match
value to match with field
string type
clause type (AND or OR)
integer num_regexs
number of regexes

Return: string

Database_Pdosqlite_Driver -> insert

public function insert

Builds an INSERT query.

Parameters:

string table
table name
array keys
keys
array values
values

Return: string

Database_Pdosqlite_Driver -> merge

public function merge

Builds a MERGE portion of a query.

Parameters:

string table
table name
array keys
keys
array values
values

Return: string

Database_Pdosqlite_Driver -> stmt_prepare

public function stmt_prepare

Creates a prepared statement.

Parameters:

string sql
(string ) SQL query

Return: Database_Stmt

Database_Pdosqlite_Driver -> has_operator

public function has_operator

Determines if the string has an arithmetic operator in it.

Parameters:

string str
string to check

Return: boolean

Database_Pdosqlite_Driver -> escape

public function escape

Escapes any input value.

Parameters:

mixed value
value to escape

Return: string

Database_Pdosqlite_Driver -> sql_type

protected function sql_type

Fetches SQL type information about a field, in a generic format.

Parameters:

string str
field datatype

Return: array

Database_Pdosqlite_Driver -> clear_cache

public function clear_cache

Clears the internal query cache.

Parameters:

string sql
(NULL) SQL query

Database_Pdosqlite_Driver -> query_hash

protected function query_hash

Creates a hash for an SQL query string. Replaces newlines with spaces, trims, and hashes.

Parameters:

string sql
SQL query

Return: string

Class: Pdosqlite_Result

class Pdosqlite_Result extends Database_Result implements Countable, Traversable, Iterator, ArrayAccess

Methods

Pdosqlite_Result -> __construct

public function __construct

Sets up the result variables.

Parameters:

resource result
query result
resource link
database link
boolean object
return objects or arrays
string sql
SQL query that was run

Pdosqlite_Result -> sqlite_row_count

private function sqlite_row_count

Pdosqlite_Result -> __destruct

public function __destruct

Pdosqlite_Result -> result

public function result

Parameters:

object
(TRUE)
type
(int 4)

Pdosqlite_Result -> as_array

public function as_array

Parameters:

object
(NULL)
type
(int 2)

Pdosqlite_Result -> result_array

public function result_array

Parameters:

object
(NULL)
type
(int 2)

Pdosqlite_Result -> list_fields

public function list_fields

Pdosqlite_Result -> seek

public function seek

Parameters:

offset

Pdosqlite_Result -> offsetGet

public function offsetGet

Parameters:

offset

Pdosqlite_Result -> rewind

public function rewind

Pdosqlite_Result -> sql

public function sql

Returns the SQL used to fetch the result.

Return: string

Pdosqlite_Result -> insert_id

public function insert_id

Returns the insert id from the result.

Return: mixed

Pdosqlite_Result -> count

public function count

Countable: count

Pdosqlite_Result -> offsetExists

public function offsetExists

ArrayAccess: offsetExists

Parameters:

offset

Pdosqlite_Result -> offsetSet

final public function offsetSet

ArrayAccess: offsetSet

Parameters:

offset
value

Throws: Kohana_Database_Exception

Pdosqlite_Result -> offsetUnset

final public function offsetUnset

ArrayAccess: offsetUnset

Parameters:

offset

Throws: Kohana_Database_Exception

Pdosqlite_Result -> current

public function current

Iterator: current

Pdosqlite_Result -> key

public function key

Iterator: key

Pdosqlite_Result -> next

public function next

Iterator: next

Pdosqlite_Result -> prev

public function prev

Iterator: prev

Pdosqlite_Result -> valid

public function valid

Iterator: valid