include/database/DBManager.php

Create DB Driver

Wrapper for those trying to access the private and protected class members directly

Adds a column to table identified by field def.

This method generates sql for adding a column to table identified by field def.

Adds a new indexes

Generates alter constraint statement given a table name and vardef definition.

Alters old column identified by oldFieldDef to new fieldDef.

This method genrates sql for altering old column identified by oldFieldDef to new fieldDef.

Quote the strings of the passed in array

Check special requirements for DB installation.

Checks the current connection; if it is not connected then reconnect

Checks for error happening in the database

Check if connecting user has certain privilege

Commits pending changes to the database when the driver is setup to support transactions.

Compare a field in two tables

Compares two vardefs

Returns the database string needed for concatinating multiple database strings together

Connects to the database backend

Use when you need to convert a database string to a different value; this function does it in a database-backend aware way Supported conversions: today return current date left Take substring from the left date_format Format date as string, supports %Y-%m-%d, %Y-%m, %Y time_format Format time as string date Convert date string to datetime value time Convert time string to datetime value datetime Convert datetime string to datetime value ifnull If var is null, use default value concat Concatenate strings quarter Quarter number of the date length Length of string month Month number of the date add_date Add specified interval to a date add_time Add time interval to a date text2char Convert text field to varchar

This function increments the global $sql_queries variable

Create a database

Create DB user

Creates an index identified by name on the given fields.

Generates SQL for create index statement for a bean.

Implements creation of a db table for a bean.

Implements creation of a db table

Generates sql for create table statement for a bean.

Generates sql for create table statement for a bean.

Check if certain database exists

Implements a generic delete for any bean identified by id

Deletes an auto increment

Deletes a column identified by fieldDef.

This method generates sql that deletes a column identified by fieldDef.

Generates SQL for delete statement identified by id.

Disable keys on the table

Disconnects from the database

This method generates sql that drops a column identified by fieldDef.

Drop a database

Drops indexes

Drops the table associated with a bean

Drops the table by name

Generates SQL for dropping a table.

Generates SQL for dropping a table.

Return representation of an empty value depending on type The value is fully quoted, converted, etc.

Re-enable keys on the table

Quotes a string for storing in the database

Takes a prepared stmt index and the data to replace and creates the query and runs it.

Fetches the next row in the query result into an associative array

Runs a query and returns a single row

Fetches the next row in the query result into an associative array

Converts from Database data to app data

Check if the database supports fulltext indexing Note that database driver can be capable of supporting FT (see supports('fulltext)) but particular instance can still have it disabled

Setup FT indexing

Generate a set of Insert statements based on the bean given

Returns the number of rows affected by the last query

Returns the next value for an auto increment

Returns the sql for the next value in a sequence

List of available collation settings

Returns the valid type for a column given the type in fieldDef

returns a SQL query that creates the indices as defined in metadata

Uses the audit enabled fields array to find fields whose value has changed.

Returns the current database handle

Get database configuration information (DB-dependent)

List of available collation settings

Returns the type of the variable in the field

Returns the description of fields based on the result

Returns a DB specific FROM clause which can be used to select against functions.

Generate fulltext query from set of terms

Returns a DB specific piece of SQL which will generate GUID (UUID) This string can be used in dynamic SQL to do multiple inserts with a single query.

Returns this instance's DBHelper Actually now returns $this

Runs a query and returns a single row containing single value

Get DB option by name

Get DB options

Returns the static queryCount value

Returns the time the last query took to execute

Returns the number of rows returned by the result

Get DB driver name used for install/upgrade scripts

Take an SQL statement and produce a list of fields used in that select

Get table description

Returns an array of tables for this database

retrieves the different components from the passed column type as it is used in the type mapping and vardefs type format: [([,])]

Return a version of $proposed that can be used as a column name in any of our supported databases Practically this means no longer than 25 characters as the smallest identifier length for our supported DBs is 30 chars for Oracle plus we add on at least four characters in some places (for indicies for example)

Returns definitions of all indies for passed table.

Returns definitions of all indies for passed table.

Implements a generic insert for any bean.

Insert data into table by parameter definition

Generates SQL for insert statement.

Get install configuration for this DB

Check if type is boolean

Check if this DB name is valid

Checks to see if passed array is truely an array of defitions

Check if type is a number

Get last database error This function should return last error as reported by DB driver and should return false if no error condition happened

Return DB error message for the last query executed

Runs a limit query: one where we specify where to start getting records and how many to get

Return limit query based on given query

Massages the field defintions to fill in anything else the DB backend may add

Outputs a correct string for the sql statement according to value

Modifies indexes

Return current time in format fit for insertion into DB (with quotes)

Returns the number of columns in a table

Create ORDER BY clause for ENUM type field

Run both prepare and execute without the client having to run both individually.

Parse fulltext search query with mysql syntax: terms quoted by "" + means the term must be included - means the term must be excluded * or % at the end means wildcard

Given a sql stmt attempt to parse it into the sql and the tokens. Then return the index of this prepared statement Tokens can come in the following forms: ? - a scalar which will be quoted ! - a literal which will not be quoted & - binary data to read from a file

Parses and runs queries

Execute multiple queries one after another

Quote string in DB-specific manner

Quotes a string for storing in the database

Quote value according to type Numerics aren't quoted Dates are converted and quoted Rest is just quoted

Return string properly quoted with ''

Rename column in the DB

Renames an index using fields definition

Implements repair of a db table for a bean.

Builds the SQL commands that repair a table structure

Resets the queryCount value to 0

Implements a generic retrieve for any bean identified by id

Generates SQL for select statement for any bean identified by id.

Implements a generic retrieve for a collection of beans.

This method implements a generic sql for a collection of beans.

Rollsback pending changes to the database when the driver is setup to support transactions.

Saves changes to module's audit table

Sets the next auto-increment value of a column to a specific value.

Sets the dieOnError value

Set database options Options are usually db-dependant and derive from $config['dbconfigoption']

This function sets the query threshold limit

Check if this DB supports certain capability See $this->capabilities for the list

Checks if a table with the name $tableName exists and returns true if it does or false otherwise

Get tables like expression

Truncates a string to a given length

Generates SQL for truncating a table.

Implements a generic update for any bean

Generates SQL for update statement.

Check if certain DB user exists

Check if this driver can be used

Check if this query is valid Validates only SELECT queries

Verify SQl statement using per-DB verification function provided the function exists

Return's the version of the database