DALAlterParser.inc

<?php
require_once 'DAL/Parsers/DALQueryParser.inc';
require_once 'DAL/Parsers/DALSchemaParser.inc';

class DALAlterParser extends DALQueryParser
{


    private function __construct()
    {

    }//end __construct()


    public static function parse(DomElement $xmlQuery)
    {
        $query    = array();
        $alterTag = $xmlQuery->getElementsByTagName('alter')->item(0);
        if ($alterTag !== NULL) {
            $query['ALTER'] = array();
            // Alter table.
            $query['ALTER']['table'] = $alterTag->getAttribute('table');

            // Get ALTER TABLE query info.
            foreach ($alterTag->childNodes as $alter) {
                if ($alter->nodeType === XML_ELEMENT_NODE) {
                    $info = NULL;
                    switch ($alter->tagName) {
                        case 'add-column' :
                        case 'modify-column' :
                            $info            = array();
                            $info['COLUMNS'] = DALSchemaParser::getTableColumns($alter);
                        break;
                        case 'drop-column' :
                            $info = $alter->nodeValue;
                        break;
                        case 'rename-column' :
                            $info        = array();
                            $info['OLD'] = $alter->getAttribute('old');
                            $info['NEW'] = $alter->nodeValue;
                        break;
                        case 'rename-table' :
                            $info        = array();
                            $info['OLD'] = $alter->getAttribute('old');
                            $info['NEW'] = $alter->nodeValue;
                        break;
                        case 'add-constraint' :
                            $info = DALSchemaParser::getConstraintsFromParent($alter);
                        break;
                        case 'drop-constraint' :
                            $info = $alter->nodeValue;
                        break;
                    }//end switch

                    $query['ALTER'][strtoupper($alter->tagName)] = $info;
                }//end if
            }//end foreach
        }//end if

        return $query;

    }//end parse()


    public static function validate(DomElement $query)
    {
        // Alter tag must have table attribute.
        $alterTag = $query->getElementsByTagName('alter')->item(0);
        if ($alterTag === NULL) {
            throw new DALParserException('Alter tag not found.');
        }

        if ($alterTag->getAttribute('table') === '') {
            $msg = 'Alter tag must have table attribute.';
            throw new DALParserException($msg);
        }

        $emptyTag = TRUE;
        foreach ($alterTag->childNodes as $alter) {
            if ($alter->nodeType === XML_ELEMENT_NODE) {
                $emptyTag = FALSE;
                $info     = NULL;
                switch ($alter->tagName) {
                    case 'add-column' :
                    case 'modify-column' :
                        DALSchemaParser::validateTableColumns($alter);
                    break;
                    case 'drop-column' :
                        if ($alter->nodeValue === '') {
                            $msg = 'drop-column tag must have a value.';
                            throw new DALParserException($msg);
                        }

                    break;
                    case 'rename-column' :
                        if ($alter->nodeValue === '') {
                            $msg = 'rename-column tag must have a value.';
                            throw new DALParserException($msg);
                        }

                        if ($alter->getAttribute('old') === '') {
                            $msg = 'rename-column tag must have a old attr.';
                            throw new DALParserException($msg);
                        }

                    break;
                    case 'rename-table' :
                        if ($alter->nodeValue === '') {
                            $msg = 'rename-table tag must have a value.';
                            throw new DALParserException($msg);
                        }

                        if ($alter->getAttribute('old') === '') {
                            $msg = 'rename-table tag must have a old attr.';
                            throw new DALParserException($msg);
                        }

                    break;
                    case 'add-constraint' :
                        DALSchemaParser::validateConstraints($alter);
                    break;
                    case 'drop-constraint' :
                        if ($alter->nodeValue === '') {
                            $msg = 'drop-constraint tag must have a value.';
                            throw new DALParserException($msg);
                        }

                    break;
                    default :
                        $msg = 'Invalid ALTER TABLE tag: '.$alter->tagName;
                        throw new DALParserException($msg);
                    break;
                }//end switch
            }//end if
        }//end foreach

        if ($emptyTag === TRUE) {
            $msg = 'Empty alter tag found.';
            throw new DALParserException($msg);
        }

    }//end validate()


}//end class

?>