SearchManipulateCapture_SQLite3Database deprecated

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

Determines if the query should be previewed, and thus interrupted silently.

If so, this function also displays the query via the debugging system. Subclasess should respect the results of this call for each query, and not execute any queries that generate a true response.

Allows the display and benchmarking of queries as they are being run

Display query message

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!

Escapes unquoted columns keys in an associative array

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

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

There is a fulltext search for SQLite making use of virtual tables, the fts3 extension and the MATCH operator there are a few issues with fts: - shared cached lock doesn't allow to create virtual tables on versions prior to 3.6.17 - there must not be more than one MATCH operator per statement - the fts3 extension needs to be available for now we use the MySQL implementation with the MATCH()AGAINST() uglily replaced with LIKE

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.

Does this database support transaction modes?

SQLite doesn't support transaction modes.

Invoke $callback within a transaction

No description

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 getLock() for details.

Returns if the lock is available.

See 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 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).

Connect to a SQLite3 database.

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

Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).

Get inherited config value

Gets the uninherited value for the given config option

Update the config value for a given property

Extension used to distinguish between sqllite database files and other files.

Required to handle multiple databases.

Check if a database name has a valid extension

Retrieve parameters used to connect to this SQLLite database

Determine if this Db is in memory

Get file path. If in memory this is null

Execute PRAGMA commands.

Gets pragma value.

Fetch the name of the most recent savepoint

Indicate whether or not the current transaction is nested Returns false if there are no transactions, or the open transaction is the 'outer' transaction, i.e. not nested.

Increase the nested transaction level by one savepoint tracking is optional because BEGIN opens a transaction, but is not a named reference

Decrease the nested transaction level by one and reduce the savepoint tracking if we are nesting, as the last one is no longer valid

In error condition, set transactionNesting to zero

Inspect a SQL query prior to execution

No description