PostgreSQLSchemaManager

Injector injection point for database controller

Enable supression of database messages.

Execute the given SQL query.

This abstract function must be defined by subclasses as part of the actual implementation. It should return a subclass of SS_Query as the result.

Execute the given SQL parameterised query with the specified arguments

Initiates a schema update within a single callback

Cancels the schema updates requested during (but not after) schemaUpdate() call.

Returns true if we are during a schema update.

Returns true if schema modifications were requested during (but not after) schemaUpdate() call.

Instruct the schema manager to record a table creation to later execute

Instruct the schema manager to record a table alteration to later execute

Instruct the schema manager to record a field to be later created

Instruct the schema manager to record an index to be later created

Instruct the schema manager to record a field to be later updated

Instruct the schema manager to record an index to be later updated

Handler for the other transXXX methods - mark the given table as being altered if it doesn't already exist

Generate the following table in the database, modifying whatever already exists as necessary.

Change detection for CREATE TABLE $options other than "Engine"

If the given table exists, move it out of the way by renaming it to obsolete(tablename).

Generate the given index in the database, modifying whatever already exists as necessary.

The keys of the array are the names of the index. The values of the array can be one of:

• true: Create a single column index on the field named the same as the index.
• array('type' => 'index|unique|fulltext', 'value' => 'FieldA, FieldB'): This gives you full control over the index.

Splits a spec string safely, considering quoted columns, whitespace, and cleaning brackets

Builds a properly quoted column list from an array

Given an index specification in the form of a string ensure that each column name is property quoted, stripping brackets and modifiers.

This index may also be in the form of a "CREATE INDEX..." sql fragment

Given an index spec determines the index type

Converts an array or string index spec into a universally useful array

This takes the index spec which has been provided by a class (ie static $indexes = blah blah) and turns it into a proper string.

Some indexes may be arrays, such as fulltext and unique indexes, and this allows database-specific arrays to be created. See requireTable() for details on the index format.

Returns true if the given table is exists in the current database

Return true if the table exists and already has a the field specified

Generate the given field on the table, modifying whatever already exists as necessary.

If the given field exists, move it out of the way by renaming it to obsolete(fieldname).

Show a message about database alteration

This returns the data type for the id column which is the primary key for each table

Checks a table's integrity and repairs it if necessary.

Returns the values of the given enum field

Make a proper implementation

No description

Retrieves the list of all databases the user has access to

Determine if the database with the specified name exists

Create a database with the specified name

Drops a database with the specified name

Alter an index on a table.

Determines the key that should be used to identify this index when retrieved from DBSchemaManager->indexList.

In some connectors this is the database-visible name, in others the usercode-visible name.

Return the list of indexes in a table.

Returns a list of all tables in the database.

Keys are table names in lower case, values are table names in case that database expects.

Create a new table.

Alter a table's schema.

Rename a table.

Create a new field on a table.

Change the database column name of the given field.

Get a list of all the fields for the given table.

Returns a map of field name => field spec.

This allows the cached values for a table's field list to be erased.

If $tablename is empty, then the whole cache is erased.

Creates a postgres database, ignoring model_schema_as_database

Determines if a postgres database exists, ignoring model_schema_as_database

Determines the list of all postgres databases, ignoring model_schema_as_database

Drops a postgres database, ignoring model_schema_as_database

Returns true if the schema exists in the current database

Creates a schema in the current database

Drops a schema from the database. Use carefully!

Returns the list of all available schemas on the current database

Builds the internal Postgres index name given the silverstripe table and index name

Builds the internal Postgres trigger name given the silverstripe table and trigger name

Change the database type of the given field.

Create an index on a table.

No description

Given a trigger name attempt to determine the columns upon which it acts

Find out what the constraint information is, given a constraint name.

We also cache this result, so the next time we don't need to do a query all over again.

A function to return the field names and datatypes for the particular table

Pass a legit trigger name and it will be dropped This assumes that the trigger has been named in a unique fashion

This will return the fields that the trigger is monitoring

Return a boolean type-formatted string

Return a date type-formatted string

Return a decimal type-formatted string

Return a enum type-formatted string

Return a float type-formatted string

Return a float type-formatted string cause double is not supported

Return a int type-formatted string

Return a bigint type-formatted string

Return a datetime type-formatted string For PostgreSQL, we simply return the word 'timestamp', no other parameters are necessary

Return a text type-formatted string

Return a time type-formatted string

Return a varchar type-formatted string

No description

Create a fulltext search datatype for PostgreSQL This will also return a trigger to be applied to this table

Get the actual enum fields from the constraint value:

No description

No description

No description

Return a set type-formatted string This is used for Multi-enum support, which isn't actually supported by Postgres.

Throws a user error to show our lack of support, and return an "int", specifically for sapphire tests that test multi-enums. This results in a test failure, but not crashing the test run.