/**
* Compiles an ALTER TABLE statement from components array
*
* @param array Array of SQL query components
* @return string SQL ALTER TABLE query
* @see parseALTERTABLE()
*/
public function compileALTERTABLE($components)
{
$query = '';
// Execute query (based on handler derived from the TABLE name which we actually know for once!)
switch ((string) $this->databaseConnection->handlerCfg[$this->databaseConnection->lastHandlerKey]['type']) {
case 'native':
$query = parent::compileALTERTABLE($components);
break;
case 'adodb':
$tableName = $this->databaseConnection->quoteName($components['TABLE'], NULL, TRUE);
$fieldName = $this->databaseConnection->quoteName($components['FIELD'], NULL, TRUE);
switch (strtoupper(str_replace(array(' ', "\n", "\r", "\t"), '', $components['action']))) {
case 'ADD':
$query = $this->databaseConnection->handlerInstance[$this->databaseConnection->lastHandlerKey]->DataDictionary->AddColumnSQL($tableName, $fieldName . ' ' . $this->compileFieldCfg($components['definition']));
break;
case 'CHANGE':
$query = $this->databaseConnection->handlerInstance[$this->databaseConnection->lastHandlerKey]->DataDictionary->AlterColumnSQL($tableName, $fieldName . ' ' . $this->compileFieldCfg($components['definition']));
break;
case 'DROP':
case 'DROPKEY':
break;
case 'ADDKEY':
case 'ADDPRIMARYKEY':
case 'ADDUNIQUE':
$query .= ' (' . implode(',', $components['fields']) . ')';
break;
case 'DEFAULTCHARACTERSET':
case 'ENGINE':
// ??? todo!
break;
}
break;
}
return $query;
}
