Class dibi
Interface for database drivers.
This class is static container class for creating DB objects and store connections info.
final public
|
#
__construct(
)
Static class – cannot be instantiated. Static class – cannot be instantiated. |
public static
DibiConnection
|
#
connect(
mixed
$config = array (
),
string
$name = 0
)
Creates a new DibiConnection object and connects it to specified database. Creates a new DibiConnection object and connects it to specified database. Parameters$config mixed connection parameters$name string connection nameThrows |
public static
void
|
#
disconnect(
)
Disconnects from database (doesn't destroy DibiConnection object). Disconnects from database (doesn't destroy DibiConnection object). |
public static
bool
|
#
isConnected(
)
Returns TRUE when connection was established. Returns TRUE when connection was established. |
public static
DibiConnection
|
#
getConnection(
string
$name = NULL
)
Retrieve active connection. |
public static
DibiConnection
|
#
setConnection(
DibiConnection
$connection
)
Sets connection. Sets connection. Parameters$connection DibiConnection |
public static
void
|
#
activate(
string
$name
)
Change active connection. |
public static
IDibiProfiler
|
#
getProfiler(
)
Retrieve active connection profiler. |
public static
DibiResult|int
|
#
query(
array|mixed
$args
)
Generates and executes SQL query – Monostate for DibiConnection::query(). Generates and executes SQL query – Monostate for DibiConnection::query(). Parameters$args array|mixed one or more argumentsReturnsDibiResult|int result set object (if any)
Throws |
public static
DibiResult|int
|
#
nativeQuery(
string
$sql
)
Executes the SQL query – Monostate for DibiConnection::nativeQuery(). Executes the SQL query – Monostate for DibiConnection::nativeQuery(). Parameters$sql string SQL statement.ReturnsDibiResult|int result set object (if any)
|
public static
bool
|
#
test(
array|mixed
$args
)
Generates and prints SQL query – Monostate for DibiConnection::test(). Generates and prints SQL query – Monostate for DibiConnection::test(). Parameters$args array|mixed one or more arguments |
public static
DibiDataSource
|
#
dataSource(
array|mixed
$args
)
Generates and returns SQL query as DibiDataSource – Monostate for DibiConnection::test(). Generates and returns SQL query as DibiDataSource – Monostate for DibiConnection::test(). Parameters$args array|mixed one or more arguments |
public static
DibiRow
|
#
fetch(
array|mixed
$args
)
Executes SQL query and fetch result – Monostate for DibiConnection::query() & fetch(). Executes SQL query and fetch result – Monostate for DibiConnection::query() & fetch(). Parameters$args array|mixed one or more argumentsThrows |
public static
array
|
#
fetchAll(
array|mixed
$args
)
Executes SQL query and fetch results – Monostate for DibiConnection::query() & fetchAll(). Executes SQL query and fetch results – Monostate for DibiConnection::query() & fetchAll(). Parameters$args array|mixed one or more argumentsReturnsarray of DibiRow
Throws |
public static
string
|
#
fetchSingle(
array|mixed
$args
)
Executes SQL query and fetch first column – Monostate for DibiConnection::query() & fetchSingle(). Executes SQL query and fetch first column – Monostate for DibiConnection::query() & fetchSingle(). Parameters$args array|mixed one or more argumentsThrows |
public static
string
|
#
fetchPairs(
array|mixed
$args
)
Executes SQL query and fetch pairs – Monostate for DibiConnection::query() & fetchPairs(). Executes SQL query and fetch pairs – Monostate for DibiConnection::query() & fetchPairs(). Parameters$args array|mixed one or more argumentsThrows |
public static
int
|
#
getAffectedRows(
)
Gets the number of affected rows. Gets the number of affected rows. Monostate for DibiConnection::getAffectedRows() Returnsint number of rows
Throws |
public static
int
|
#
affectedRows(
)
Gets the number of affected rows. Alias for getAffectedRows(). Gets the number of affected rows. Alias for getAffectedRows(). Returnsint number of rows
Throws |
public static
int
|
#
getInsertId(
string
$sequence = NULL
)
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Monostate for DibiConnection::getInsertId() Parameters$sequence string optional sequence nameThrows |
public static
int
|
#
insertId(
string
$sequence = NULL
)
Retrieves the ID generated for an AUTO_INCREMENT column. Alias for getInsertId(). Retrieves the ID generated for an AUTO_INCREMENT column. Alias for getInsertId(). Parameters$sequence string optional sequence nameThrows |
public static
void
|
#
begin(
string
$savepoint = NULL
)
Begins a transaction – Monostate for DibiConnection::begin(). Begins a transaction – Monostate for DibiConnection::begin(). Parameters$savepoint string optional savepoint nameThrows |
public static
void
|
#
commit(
string
$savepoint = NULL
)
Commits statements in a transaction – Monostate for DibiConnection::commit($savepoint = NULL). Commits statements in a transaction – Monostate for DibiConnection::commit($savepoint = NULL). Parameters$savepoint string optional savepoint nameThrows |
public static
void
|
#
rollback(
string
$savepoint = NULL
)
Rollback changes in a transaction – Monostate for DibiConnection::rollback(). Rollback changes in a transaction – Monostate for DibiConnection::rollback(). Parameters$savepoint string optional savepoint nameThrows |
public static
DibiDatabaseInfo
|
#
getDatabaseInfo(
)
Gets a information about the current database – Monostate for DibiConnection::getDatabaseInfo(). Gets a information about the current database – Monostate for DibiConnection::getDatabaseInfo(). |
public static
int
|
#
loadFile(
string
$file
)
Import SQL dump from file – extreme fast! Import SQL dump from file – extreme fast! Parameters$file string filenameReturnsint count of sql commands
|
public static
|
#
__callStatic(
$name,
$args
)
Replacement for majority of dibi::methods() in future. Replacement for majority of dibi::methods() in future. |
public static
DibiFluent
|
#
command(
)
|
public static
DibiFluent
|
#
select(
string
$args
)
Parameters$args string column name |
public static
DibiFluent
|
#
update(
string
$table,
array
$args
)
Parameters$table string table$args array |
public static
DibiFluent
|
#
insert(
string
$table,
array
$args
)
Parameters$table string table$args array |
public static
DibiFluent
|
#
delete(
string
$table
)
Parameters$table string table |
public static
|
#
datetime(
$time = NULL
)
|
public static
|
#
date(
$date = NULL
)
|
public static
void
|
#
addSubst(
string
$expr,
string
$subst
)
Create a new substitution pair for indentifiers. Create a new substitution pair for indentifiers. Parameters$expr string from$subst string to |
public static
void
|
#
removeSubst(
mixed
$expr
)
Remove substitution pair. Remove substitution pair. Parameters$expr mixed from or TRUE |
public static
void
|
#
setSubstFallback(
callback
$callback
)
Sets substitution fallback handler. Sets substitution fallback handler. Parameters$callback callback |
public static
mixed
|
#
defaultSubstFallback(
string
$expr
)
Default substitution fallback handler. Default substitution fallback handler. Parameters$expr string |
public static
string
|
#
dump(
string|DibiResult
$sql = NULL,
bool
$return = false
)
Prints out a syntax highlighted version of the SQL command or DibiResult. Prints out a syntax highlighted version of the SQL command or DibiResult. Parameters$sql string|DibiResult$return bool return output instead of printing it? |
TEXT |
's' # |
BINARY |
'bin' # |
BOOL |
'b' # |
INTEGER |
'i' # |
FLOAT |
'f' # |
DATE |
'd' # |
DATETIME |
't' # |
TIME |
't' # |
IDENTIFIER |
'n' # |
FIELD_TEXT |
's' # |
FIELD_BINARY |
'bin' # |
FIELD_BOOL |
'b' # |
FIELD_INTEGER |
'i' # |
FIELD_FLOAT |
'f' # |
FIELD_DATE |
'd' # |
FIELD_DATETIME |
't' # |
FIELD_TIME |
't' # |
VERSION |
'1.3-dev' # |
REVISION |
'1f438fa released on 2010-10-06' # |
ASC |
'ASC' # |
DESC |
'DESC' # |
static
DibiLazyStorage
|
$substs | DibiLazyStorage::__set_state(array( 'callback' => array ( 0 => 'dibi', 1 => 'defaultSubstFallback', ), )) |
Substitutions for identifiers # |
static
string
|
$sql | NULL |
Last SQL command @see dibi::query() # |
static
int
|
$elapsedTime | NULL |
Elapsed time for last query # |
static
int
|
$totalTime | NULL |
Elapsed time for all queries # |
static
int
|
$numOfQueries | 0 |
Number or queries # |
static
string
|
$defaultDriver | 'mysql' |
Default dibi driver # |