CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil Class Reference

Static Public Member Functions
static	getTableSchema ($tableName, $columns=array(), $indexes=array())
static	generateOrUpdateTableBySchemaDefinition (array $schemaDefinition, &$messageLogger, $validate=true)
static	resolveProcessedTables ()
Data Fields
const	CACHE_KEY = 'CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil_processedTableNames'
Static Protected Member Functions
static	validateSchemaDefinition (array $schemaDefinition)
static	validateColumnDefinitionsFromSchema (array $columns)
static	validateIndexDefinitionsFromSchema (array $indexes, array $columns)
static	resolveAlterQueryForColumn ($column)
static	resolveColumnUpgradeQueries ($columns, $existingFields)
static	doesIndexNeedUpgrade ($indexMetadata, $existingIndexes)
static	resolveIndexUpgradeQueries ($indexes, $existingIndexes)
static	resolveAlterTableQuery ($tableName, $columnsAndIndexes, $existingFields, $existingIndexes)
static	resolveColumnUpgradeDefinition ($column, $existingFields)
static	doesColumnNeedUpgrade ($column, $existingField)
static	isColumnTypeSameAsExistingFieldOrSmaller ($column, $existingField)
static	isColumnLengthShrinkOrConversionToUnsigned ($columnLength, $fieldLength, $columnUnsigned, $fieldUnsigned)
static	isColumnTypeSmallerThanExistingFieldType ($columnType, $fieldType)
static	resolveExistingFieldTypeAndLengthAndUsigned (array $existingField)
static	resolveColumnTypeAndLength ($columnTypeAndLength)
static	isColumnTypeSameAsExistingField ($column, $existingField)
static	isColumnNullSameAsExistingField ($column, $existingField)
static	isColumnDefaultValueSameAsExistingField ($column, $existingField)
static	resolveCreateTableQuery ($tableName, $columnsAndIndexesSchema)
static	resolveColumnStatementFromDefinition ($column, $isAddition=true)
static	resolveIndexStatementCreation ($indexName, $indexMetadata, $alterTable=false)
static	returnSchemaValidationResult ($message, $isValid=false)

---

Detailed Description

Utility to generate or update a table in database when provided with a database schema in array format

Definition at line 40 of file CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil.php.

---

Member Function Documentation

static getTableSchema	(	$	tableName,
		$	columns = array(),
		$	indexes = array()
	)			[static]

Returns table schema definition

Parameters:

	$tableName
	array	$columns
	array	$indexes

Returns:

array $schema

Definition at line 51 of file CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil.php.

static generateOrUpdateTableBySchemaDefinition	(	array $	schemaDefinition,
		&$	messageLogger,
		$	validate = true
	)			[static]

Provide a schema definition array queries to create/update database schema are executed.

Parameters:

	array	$schemaDefinition
	$messageLogger
	$validate

Exceptions:

	CException
	Exception|RedBean_Exception_SQL

Definition at line 70 of file CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil.php.

static resolveProcessedTables

(

)

[static]

Returns an array of processed tables.

Returns:

array

Definition at line 136 of file CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil.php.

---

The documentation for this class was generated from the following file:

• /home/apizurmo/zurmo/app/protected/core/utils/CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil.php