vB_dB_QueryDefs
in package
Uses
vB_Trait_NoSerialize
Table of Contents
- $db_type : mixed
- The database type
- $query_data : mixed
- This is the definition for queries we will process through. We could also put them in the database, but this eliminates a query.
- $table_data : mixed
- This is the definition for tables we will process through. It saves a
- __serialize() : mixed
- __sleep() : mixed
- __unserialize() : mixed
- __wakeup() : mixed
- getQueryData() : mixed
- This returns the query definitions
- getTableData() : mixed
- This returns the table definitions
- executeWriteQuery() : mixed
- Handles a write query -- pretty much anything that doesn't return a result set.
- getQueryBuilder() : mixed
- getResultSet() : mixed
- Returns the resultset for a particular query string
Properties
$db_type
The database type
protected
mixed
$db_type
= ''
Should be overriden by child classes.
$query_data
This is the definition for queries we will process through. We could also put them in the database, but this eliminates a query.
protected
mixed
$query_data
= array()
$table_data
This is the definition for tables we will process through. It saves a
protected
mixed
$table_data
= array()
database query to put them here.
Methods
__serialize()
public
__serialize() : mixed
Return values
mixed —__sleep()
public
__sleep() : mixed
Return values
mixed —__unserialize()
public
__unserialize(mixed $serialized) : mixed
Parameters
- $serialized : mixed
Return values
mixed —__wakeup()
public
__wakeup() : mixed
Return values
mixed —getQueryData()
This returns the query definitions
public
getQueryData() : mixed
Return values
mixed —getTableData()
This returns the table definitions
public
getTableData() : mixed
Return values
mixed —executeWriteQuery()
Handles a write query -- pretty much anything that doesn't return a result set.
protected
executeWriteQuery(object $db, string $sql[, string $tag = '' ]) : mixed
Intend for use by method queries to reduce repetative code and increase standardization
Parameters
- $db : object
-
-- the internal db connection object for this DB type
- $sql : string
-
-- the query string for this DB type.
- $tag : string = ''
-
-- if provided this will append and indentifying comment to the query to assist determining where the query resulted from. This will involve more than simply the tag text. (The tag should not contain any user generated content -- if you don't know where it came from, don't use it).
Return values
mixed —getQueryBuilder()
protected
getQueryBuilder(mixed $db) : mixed
Parameters
- $db : mixed
Return values
mixed —getResultSet()
Returns the resultset for a particular query string
protected
getResultSet(object $db, string $sql[, string $tag = '' ]) : mixed
Intend for use by method queries to reduce repetative code and increase standardization
Parameters
- $db : object
-
-- the internal db connection object for this DB type
- $sql : string
-
-- the query string for this DB type.
- $tag : string = ''
-
-- if provided this will append and indentifying comment to the query to assist determining where the query resulted from. This will involve more than simply the tag text. (The tag should not contain any user generated content -- if you don't know where it came from, don't use it).