PostgreSQLDatabase

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

Delete all entries from the table instead of truncating it.

This gives a massive speed improvement compared to using TRUNCATE, with the caveat that primary keys are not reset etc.

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 Postgres used for querying a datetime in a certain format

Function to return an SQL datetime expression that can be used with Postgres used for querying a datetime addition

Function to return an SQL datetime expression that can be used with Postgres 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 configuration.

Properly extract the search functions out of the core.

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

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

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

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

Full text cluster method. (e.g. GIN or GiST)

Full text search method.

Determines whether to check a database exists on the host by querying the 'postgres' database and running createDatabase.

Some locked down systems prevent access to the 'postgres' table in which case you need to set this to false.

If allow_query_master_postgres is false, and model_schema_as_database is also false, then attempts to create or check databases beyond the initial connection will result in a runtime error.

For instances where multiple databases are used beyond the initial connection you may set this option to true to force database switches to switch schemas instead of using databases. This may be useful if the database user does not have cross-database permissions, and in cases where multiple databases are used (such as in running test cases).

If this is true then the database will only be set during the initial connection, and attempts to change to this database will use the 'public' schema instead

Override the language that tsearch uses. By default it is 'english, but could be any of the supported languages that can be found in the pg_catalog.pg_ts_config table.

No description

No description

Sets the system timezone for the database connection

Returns the name of the current schema in use

Utility method to manually set the schema to an alternative Check existance & sets search path to the supplied schema name

Override the schema search path. Search using the arguments supplied.

NOTE: The search path is normally set through setSchema() and only one schema is selected. The facility to add more than one schema to the search path is provided as an advanced PostgreSQL feature for raw SQL queries. Sapphire cannot search for datamodel tables in alternate schemas, so be wary of using alternate schemas within the ORM environment.

Determines the name of the current database to be reported externally by substituting the schema name for the database name.

Should only be used when model_schema_as_database is true

Translates a requested database name to a schema name to substitute internally.

Should only be used when model_schema_as_database is true