Database

Get the current connector

Injector injection point for connector dependency

Returns the current schema manager

Injector injection point for schema manager

Returns the current query builder

Injector injection point for schema manager

Execute the given SQL query.

Execute the given SQL parameterised query with the specified arguments

Add the sql queries that need to be partially or fully matched

Get the sql queries that need to be partially or fully matched

Get the autogenerated ID from the previous INSERT query.

Determines if we are connected to a server AND have a valid database selected.

Returns an escaped string. This string won't be quoted, so would be suitable for appending to other quoted strings.

Wrap a string into DB-specific quotes.

Escapes an identifier (table / database name). Typically the value is simply double quoted. Don't pass in already escaped identifiers in, as this will double escape the value!

Execute a complex manipulation on the database.

A manipulation is an array of insert / or update sequences. The keys of the array are table names, and the values are map containing 'command' and 'fields'. Command should be 'insert' or 'update', and fields should be a map of field names to field values, NOT including quotes.

The field values could also be in paramaterised format, such as array('MAX(?,?)' => array(42, 69)), allowing the use of raw SQL values such as array('NOW()' => array()).

Enable supression of database messages.

Clear all data out of the database

Clear all data in a given table

Generates a WHERE clause for null comparison check

Generate a WHERE clause for text matching.

function to return an SQL datetime expression that can be used with the adapter in use used for querying a datetime in a certain format

function to return an SQL datetime expression that can be used with the adapter in use used for querying a datetime addition

function to return an SQL datetime expression that can be used with the adapter in use used for querying a datetime substraction

String operator for concatenation of strings

Returns true if this database supports collations

Can the database override timezone as a connection setting, or does it use the system timezone exclusively?

Query for the version of the currently connected database

Get the database server type (e.g. mysql, postgresql).

This value is passed to the connector as the 'driver' argument when initiating a database connection

Return the number of rows affected by the previous operation.

The core search engine, used by this class and its subclasses to do fun stuff.

Searches both SiteTree and File.

Determines if this database supports transactions

Does this database support savepoints in transactions By default it is assumed that they don't unless they are explicitly enabled.

Determines if the used database supports given transactionMode as an argument to startTransaction() If transactions are completely unsupported, returns false.

Invoke $callback within a transaction

Start a prepared transaction See http://developer.postgresql.org/pgdocs/postgres/sql-set-transaction.html for details on transaction isolation options

Create a savepoint that you can jump back to if you encounter problems

Rollback or revert to a savepoint if your queries encounter problems If you encounter a problem at any point during a transaction, you may need to rollback that particular query, or return to a savepoint

Commit everything inside this transaction so far

Return depth of current transaction

Determines if the used database supports application-level locks, which is different from table- or row-level locking.

See {@link getLock()} for details.

Returns if the lock is available.

See {@link supportsLocks()} to check if locking is generally supported.

Sets an application-level lock so that no two processes can run at the same time, also called a "cooperative advisory lock".

Return FALSE if acquiring the lock fails; otherwise return TRUE, if lock was acquired successfully. Lock is automatically released if connection to the database is broken (either normally or abnormally), making it less prone to deadlocks than session- or file-based locks. Should be accompanied by a {@link releaseLock()} call after the logic requiring the lock has completed. Can be called multiple times, in which case locks "stack" (PostgreSQL, SQL Server), or auto-releases the previous lock (MySQL).

Note that this might trigger the database to wait for the lock to be released, delaying further execution.

Remove an application-level lock file to allow another process to run (if the execution aborts (e.g. due to an error) all locks are automatically released).

Instruct the database to generate a live connection

Determine if the database with the specified name exists

Retrieves the list of all databases the user has access to

Change the connection to the specified database, optionally creating the database if it doesn't exist in the current schema.

Drop the database that this object is currently connected to.

Use with caution.

Returns the name of the currently selected database

Return SQL expression used to represent the current date/time

Returns the database-specific version of the random() function