DALWithParser.inc

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

class DALWithParser extends DALQueryParser
{


    private function __construct()
    {

    }//end __construct()


    public static function parse(DomElement $xmlQuery)
    {
        $query   = array();
        $withTag = $xmlQuery->getElementsByTagName('with')->item(0);

        $query['WITH'] = self::parseSqlFunction($withTag);

        // Find the select.
        $query['WITH'] = array_merge($query['WITH'], DALUnionParser::parse($withTag));

        $after = $withTag->getElementsByTagName('after')->item(0);

        $query['WITH']['AFTER'] = DALSelectParser::parse($after);

        $connectBy = $withTag->getElementsByTagName('connect-by-prior')->item(0);

        $query['WITH']['CONNECT-BY-PRIOR'] = current(DALWhereParser::parse($connectBy->parentNode, 'connect-by-prior'));

        return $query;

    }//end parse()


    public static function validate(DomElement $xmlQuery)
    {

    }//end validate()


    protected static function parseSqlFunction(DomElement $function)
    {
        $query                         = array();
        $query['FUNCTION']             = array();
        $query['FUNCTION']['function'] = $function->getAttribute('function');
        $query['FUNCTION']['ARGS']     = array();

        if ($function->getAttribute('alias') !== '') {
            $query['FUNCTION']['alias'] = $function->getAttribute('alias');
        }

        $argsTag = $function->getElementsByTagName('args')->item(0);
        $argTags = $argsTag->getElementsByTagName('arg');

        foreach ($argTags as $arg) {
            $query['FUNCTION']['ARGS'][] = $arg->nodeValue;
        }

        return $query;

    }//end parseSqlFunction()


}//end class

?>