include/database/MysqlManager.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

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

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

This function increments the global $sql_queries variable

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

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.

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

Drops the table associated with a bean

Drops the table by name

Generates SQL for dropping a 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

Setup FT indexing

Generate a set of Insert statements based on the bean given

Returns the sql for the next value in a sequence

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

Returns the type of the variable in the field

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

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

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)

Implements a generic insert for any bean.

Insert data into table by parameter definition

Generates SQL for insert statement.

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

Return DB error message for the last query executed

Return limit query based on given query

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

Execute multiple queries one after another

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 ''

Renames an index using fields definition

Implements repair of a db table for a bean.

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

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.