package com.quantum.sql;

/**
 * @author BC
 */
public abstract class SQLGrammar {

	public static String[] KEYWORDS = {
		"ADD", "ALL", "ALTER", "AND", "ANY",
		"AS", "ASC", "AUTOINCREMENT", "AVA", "BETWEEN",
		"BINARY", "BIT", "BOOLEAN", "BY", "CREATE",
		"BYTE", "CHAR", "CHARACTER", "COLUMN", "CONSTRAINT",
		"COUNT", "COUNTER", "CURRENCY", "DATABASE", "DATE",
		"DATETIME", "DELETE", "DESC", "DISALLOW", "DISTINCT",
		"DISTINCTROW", "DOUBLE", "DROP", "EXISTS", "FROM",
		"FLOAT", "FLOAT4", "FLOAT8", "FOREIGN", "GENERAL",
		"GROUP", "GUID", "HAVING", "INNER", "INSERT",
		"IGNORE", "IMP", "IN", "INDEX", "INT", 
		"INTEGER", "INTEGER1", "INTEGER2", "INTEGER4", "INTO",
		"IS", "JOIN", "KEY", "LEFT", "LEVEL", 
		"LIKE", "LOGICAL", "LONG", "LONGBINARY", "LONGTEXT",
		"MAX", "MEMO", "MIN", "MOD", "MONEY", 
		"NOT", "NULL", "NUMBER", "NUMERIC", "OLEOBJECT",
		"ON", "PIVOT", "OPTION", "PRIMARY", "ORDER",
		"OUTER", "OWNERACCESS", "PARAMETERS", "PERCENT", "REAL",
		"REFERENCES", "RIGHT", "SELECT", "SET", "SHORT",
		"SINGLE", "SMALLINT", "SOME", "STDEV", "STDEVP",
		"STRING", "SUM", "TABLE", "TABLEID", "TEXT", 
		"TIME",	"TIMESTAMP", "TOP", "TRANSFORM", "UNION",
		"UNIQUE", "UPDATE", "VALUE", "VALUES", "VAR",
		"VARBINARY", "VARCHAR", "VARP", "WHERE", "WITH",
		"YESNO" 
	};
	
    public static final String[] NON_RESERVED_WORDS = { 
    		"ADA", "C", "CATALOG_NAME", "CHARACTER_SET_CATALOG", "CHARACTER_SET_NAME", 
			"CHARACTER_SET_SCHEMA", "CLASS_ORIGIN", "COBOL", "COLLATION_CATALOG", 
			"COLLATION_NAME", "COLLATION_SCHEMA", "COLUMN_NAME", "COMMAND_FUNCTION", 
			"COMMITTED", "CONDITION_NUMBER", "CONNECTION_NAME", "CONSTRAINT_CATALOG", 
			"CONSTRAINT_NAME", "CONSTRAINT_SCHEMA", "CURSOR_NAME", "DATA", 
			"DATETIME_INTERVAL_CODE", "DATETIME_INTERVAL_PRECISION", "DYNAMIC_FUNCTION", 
			"FORTRAN", "LENGTH", "MESSAGE_LENGTH", "MESSAGE_OCTET_LENGTH", 
			"MESSAGE_TEXT", "MORE", "MUMPS", "NAME", "NULLABLE", "NUMBER", "PASCAL", 
			"PLI", "REPEATABLE", "RETURNED_LENGTH", "RETURNED_OCTET_LENGTH", 
			"RETURNED_SQLSTATE", "ROW_COUNT", "SCALE", "SCHEMA_NAME", 
			"SERIALIZABLE", "SERVER_NAME", "SUBCLASS_ORIGIN", "TABLE_NAME", 
			"TYPE", "UNCOMMITTED", "UNNAMED"
    };
    
    public static final String[] COMMANDS = {
    	"select * from ${tablename} where ${columnname} = ${value}",
		"update ${tablename} set ${columnname} = ${value} where ${column2name} = ${value2}"
    };
}