Methods

All methods in the Solar_Sql_Adapter class.

Public

__construct()

Constructor.

__destruct()

Default destructor; does nothing other than provide a safe fallback for calls to parent::__destruct().

addColumn()

Adds a portable column to a table in the database.

begin()

Leave autocommit mode and begin a transaction.

commit()

Commit a transaction and return to autocommit mode.

connect()

Creates a PDO object and connects to the database.

createIndex()

Creates a portable index on a table.

createSequence()

Creates a sequence in the database.

createTable()

Creates a portable table.

delete()

Deletes rows from the table based on a WHERE clause.

disconnect()

Closes the database connection.

dropColumn()

Drops a column from a table in the database.

dropIndex()

Drops an index from a table in the database.

dropSequence()

Drops a sequence from the database.

dropTable()

Drops a table from the database, if it exists.

dump()

Convenience method for getting a dump the whole object, or one of its properties, or an external variable.

fetchAll()

Fetches all rows from the database using sequential keys.

fetchAssoc()

Fetches all rows from the database using associative keys (defined by the first column).

fetchCol()

Fetches the first column of all rows as a sequential array.

fetchIndexInfo()

Returns an array describing table indexes from the cache; if the cache entry is not available, queries the database for the index information.

fetchOne()

Fetches one row from the database.

fetchPairs()

Fetches an associative array of all rows as key-value pairs (first column is the key, second column is the value).

fetchPdo()

Fetches a PDOStatement result object.

fetchSql()

Builds the SQL statement and returns it as a string instead of executing it.

fetchTableCols()

Returns an array describing table columns from the cache; if the cache entry is not available, queries the database for the column descriptions.

fetchTableList()

Returns a list of database tables from the cache; if the cache entry is not available, queries the database for the list of tables.

fetchValue()

Fetches the very first value (i.e., first column of the first row).

getCache()

Returns the cache object.

getCacheKeyPrefix()

Gets the connection-specific cache key prefix.

getPdo()

Get the PDO connection object (connects to the database if needed).

getProfile()

Get the query profile array.

insert()

Inserts a row of data into a table.

lastInsertId()

Get the last auto-incremented insert ID from the database.

locale()

Looks up class-specific locale strings based on a key.

nextSequence()

Gets the next number in a sequence; creates the sequence if it does not exist.

query()

Prepares and executes an SQL statement, optionally binding values to named parameters in the statement.

quote()

Safely quotes a value for an SQL statement.

quoteInto()

Quotes a value and places into a piece of text at a placeholder; the placeholder is a question-mark.

quoteMulti()

Quote multiple text-and-value pieces.

quoteName()

Quotes a single identifier name (table, table alias, table column, index, sequence).

quoteNamesIn()

Quotes all fully-qualified identifier names ("table.col") in a string, typically an SQL snippet for a SELECT clause.

rollback()

Roll back a transaction and return to autocommit mode.

setCache()

Injects a cache dependency for $_cache.

setCacheKeyPrefix()

Sets the connection-specific cache key prefix.

setProfiling()

Turns profiling on and off.

update()

Updates a table with specified data based on a WHERE clause.

Protected

_addProfile()

Adds an element to the profile array.

_bind()

Binds an array of scalars as values into a prepared PDOStatment.

_buildConfig()

Builds and returns the default config for a class, including all configs inherited from its parents.

_buildDsn()

Creates a PDO-style DSN.

_checkIdentifier()

Check if a table, index, or column name is a valid portable identifier.

_checkIdentifierColumn()

Checks a column name.

_checkIdentifierPart()

Checks one part of a dotted identifier (schema.table, database.table, etc).

_createSequence()

Creates a sequence, optionally starting at a certain number.

_dropIndex()

Drops an index.

_dropSequence()

Drops a sequence.

_exception()

Convenience method for returning exceptions with localized text.

_fetchIndexInfo()

Returns an array of index information for a table.

_fetchTableCols()

Returns an array describing the columns in a table.

_fetchTableList()

Returns a list of database tables.

_getCacheKey()

Gets a full cache key.

_getTypeSizeScope()

Given a column specification, parse into datatype, size, and decimal scope.

_modAutoincPrimary()

Given a column definition, modifies the auto-increment and primary-key clauses in place.

_modIndexName()

Modifies an index name for adapters.

_modSelect()

Modifies a SELECT statement in place to add a LIMIT clause.

_modSequenceName()

Modifies a sequence name for adapters.

_nextSequence()

Gets the next sequence number; creates the sequence if needed.

_postConfig()

A hook that activates after _buildConfig() in the constructor.

_postConnect()

After connection, set various connection attributes.

_postConstruct()

Post-construction tasks to complete object construction.

_preConfig()

A hook that activates before _buildConfig() in the constructor.

_prepare()

Prepares an SQL query as a PDOStatement object.

_quoteName()

Quotes an identifier name (table, index, etc); ignores empty values and values of '*'.

_quoteNamesIn()

Quotes all fully-qualified identifier names ("table.col") in a string.

_select()

Returns a SELECT statement built from its component parts.

_selectCompound()

Builds a compound SELECT command string from its component parts, without the LIMIT portions; those are left to the individual adapters.

_selectSingle()

Builds a single SELECT command string from its component parts, without the LIMIT portions; those are left to the individual adapters.

_selectSingleFrom()

Builds the FROM clause for a SELECT command.

_setDsn()

Sets the DSN value for the connection from the config info.

_setup()

Follow-on setup from the constructor; useful for extended classes.

_splitSchemaIdent()

Splits a schema.table identifier into its component parts.

_sqlColdef()

Returns a column definition string.

_sqlCreateTable()

Returns a CREATE TABLE command string for the adapter.

Private

None.



Local