DALUpdateParser.inc

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

class DALUpdateParser extends DALQueryParser
{


    private function __construct()
    {

    }//end __construct()


    public static function parse(DomElement $xmlQuery)
    {
        $query = array();

        $updateTag = $xmlQuery->getElementsByTagName('update')->item(0);
        if ($updateTag !== NULL) {
            $query['UPDATE'] = array();

            // Insert fields.
            $fieldsTag = $updateTag->getElementsByTagName('fields')->item(0);
            if ($fieldsTag !== NULL) {
                $query['UPDATE']['table'] = $fieldsTag->getAttribute('table');

                $qfields = array();
                $fields  = $fieldsTag->getElementsByTagName('field');
                foreach ($fields as $field) {
                    $qfields[] = $field->nodeValue;
                }
            }

            $query['UPDATE']['FIELDS'] = $qfields;

            // Get fields.
            $valuesTag = $updateTag->getElementsByTagName('values')->item(0);

            // Add values.
            foreach ($valuesTag->childNodes as $value) {
                if ($value->nodeType === XML_ELEMENT_NODE) {
                    $vCol = $value->getAttribute('column');
                    if (XML::hasChildElements($value) === TRUE) {
                        $qvals[$vCol] = self::parseSingleField(XML::getFirstChildElement($value));
                    } else {
                        $qvals[$vCol] = $value->nodeValue;
                    }
                }
            }

            $query['UPDATE']['VALUES'] = $qvals;

            // Get where clause if there is any.
            $where           = DALWhereParser::parse($updateTag);
            $query['UPDATE'] = array_merge($query['UPDATE'], $where);
        }//end if

        return $query;

    }//end parse()


    public static function validate(DomElement $query)
    {
        $updateTag = $query->getElementsByTagName('update')->item(0);
        if ($updateTag === NULL) {
            throw new DALParserException('Update tag not found.');
        }

        // Update tag must have fields tag.
        $fieldsTag = $updateTag->getElementsByTagName('fields');
        if ($fieldsTag->length !== 0) {
            $fieldsTag     = $fieldsTag->item(0);
            $parentTagName = $fieldsTag->parentNode->tagName;
        } else {
            $fieldsTag = NULL;
        }

        if (($fieldsTag === NULL) || ($parentTagName !== 'update')) {
            $msg = 'Update query must have fields tag.';
            throw new DALParserException($msg);
        }

        self::validateFieldsTag($fieldsTag);

        $valuesTag = $updateTag->getElementsByTagName('values')->item(0);
        if ($valuesTag === NULL) {
            $msg = 'Update query must have values tag.';
            throw new DALParserException($msg);
        }

        self::validateValuesTag($valuesTag);

        $whereTag = $updateTag->getElementsByTagName('where')->item(0);
        if ($whereTag !== NULL) {
            DALWhereParser::validate($whereTag);
        }

    }//end validate()


}//end class

?>