<?php
/**
 * @version 	$Id: ansi.php 1115 2009-08-22 15:26:29Z johan $
 * @category	Koowa
 * @package		Koowa_Database
 * @subpackage  Query
 * @copyright	Copyright (C) 2007 - 2009 Johan Janssens and Mathias Verraes. All rights reserved.
 * @license		GNU GPLv2 <http://www.gnu.org/licenses/old-licenses/gpl-2.0.html>
 */

/**
 * ANSI SQL dialect definition file
 * 
 * This class draws heavily on PEAR:SQL_Parser Copyright (c) 2002-2004 Brent Cook,
 * John Griffin. Released under the LGPL license
 *
 * @author    	Johan Janssens <hide@address.com>
 * @category	Koowa
 * @package     Koowa_Database
 * @subpackage  Query
 */

/**
 * define tokens accepted by the SQL dialect.
 */
$dialect = array(
    'commands' => array(
        'alter',
        'create',
        'drop',
        'select',
        'delete',
        'insert',
        'update',
    ),

    'operators' => array(
        '=',
        '<>',
        '<',
        '<=',
        '>',
        '>=',
        'like',
        'clike',
        'slike',
        'not',
        'is',
        'in',
        'between',
        'and',
        'or',
    ),

    'types' => array(
        'character',
        'char',
        'varchar',
        'nchar',
        'bit',
        'numeric',
        'decimal',
        'dec',
        'integer',
        'int',
        'smallint',
        'float',
        'real',
        'double',
        'date',
        'time',
        'timestamp',
        'interval',
        'bool',
        'boolean',
        'set',
        'enum',
        'text',
    ),

    'conjunctions' => array(
        'by',
        'as',
        'on',
        'into',
        'from',
        'where',
        'with',
    ),

    'functions' => array(
        'avg',
        'count',
        'max',
        'min',
        'sum',
        'nextval',
        'currval',
    ),

    'reserved' => array(
        'absolute',
        'action',
        'add',
        'all',
        'allocate',
        'and',
        'any',
        'are',
        'asc',
        'ascending',
        'assertion',
        'at',
        'authorization',
        'begin',
        'bit_length',
        'both',
        'cascade',
        'cascaded',
        'case',
        'cast',
        'catalog',
        'char_length',
        'character_length',
        'check',
        'close',
        'coalesce',
        'collate',
        'collation',
        'column',
        'commit',
        'connect',
        'connection',
        'constraint',
        'constraints',
        'continue',
        'convert',
        'corresponding',
        'cross',
        'current',
        'current_date',
        'current_time',
        'current_timestamp',
        'current_user',
        'cursor',
        'day',
        'deallocate',
        'declare',
        'default',
        'deferrable',
        'deferred',
        'desc',
        'descending',
        'describe',
        'descriptor',
        'diagnostics',
        'disconnect',
        'distinct',
        'domain',
        'else',
        'end',
        'end-exec',
        'escape',
        'except',
        'exception',
        'exec',
        'execute',
        'exists',
        'external',
        'extract',
        'false',
        'fetch',
        'first',
        'for',
        'foreign',
        'found',
        'full',
        'get',
        'global',
        'go',
        'goto',
        'grant',
        'group',
        'having',
        'hour',
        'identity',
        'immediate',
        'indicator',
        'initially',
        'inner',
        'input',
        'insensitive',
        'intersect',
        'isolation',
        'join',
        'key',
        'language',
        'last',
        'leading',
        'left',
        'level',
        'limit',
        'local',
        'lower',
        'match',
        'minute',
        'module',
        'month',
        'names',
        'national',
        'natural',
        'next',
        'no',
        'null',
        'nullif',
        'octet_length',
        'of',
        'only',
        'open',
        'option',
        'or',
        'order',
        'outer',
        'output',
        'overlaps',
        'pad',
        'partial',
        'position',
        'precision',
        'prepare',
        'preserve',
        'primary',
        'prior',
        'privileges',
        'procedure',
        'public',
        'read',
        'references',
        'relative',
        'restrict',
        'revoke',
        'right',
        'rollback',
        'rows',
        'schema',
        'scroll',
        'second',
        'section',
        'session',
        'session_user',
        'size',
        'some',
        'space',
        'sql',
        'sqlcode',
        'sqlerror',
        'sqlstate',
        'substring',
        'system_user',
        'table',
        'temporary',
        'then',
        'timezone_hour',
        'timezone_minute',
        'to',
        'trailing',
        'transaction',
        'translate',
        'translation',
        'trim',
        'true',
        'union',
        'unique',
        'unknown',
        'upper',
        'usage',
        'user',
        'using',
        'value',
        'values',
        'varying',
        'view',
        'when',
        'whenever',
        'work',
        'write',
        'year',
        'zone',
        'eoc',
    ),

    'synonyms' => array(
        'decimal' => 'numeric',
        'dec' => 'numeric',
        'numeric' => 'numeric',
        'float' => 'float',
        'real' => 'real',
        'double' => 'real',
        'int' => 'int',
        'integer' => 'int',
        'interval' => 'interval',
        'smallint' => 'smallint',
        'timestamp' => 'timestamp',
        'bool' => 'bool',
        'boolean' => 'bool',
        'set' => 'set',
        'enum' => 'enum',
        'text' => 'text',
        'char' => 'char',
        'character' => 'char',
        'varchar' => 'varchar',
        'ascending' => 'asc',
        'asc' => 'asc',
        'descending' => 'desc',
        'desc' => 'desc',
        'date' => 'date',
        'time' => 'time',
    ),

    'lexeropts' => array(
        'allowIdentFirstDigit' => false,
    ),

    'parseropts' => array(
    ),

    'comments' => array(
        '--' => "\n",
    ),
    
    'quotes' => array(
        "'" => 'string',
        '"' => 'ident',
    ),
);