Merging code from trunk that fixes #774, this work was done by incastrix
[phpeclipse.git] / archive / net.sourceforge.phpeclipse.quantum.sql / src / com / quantum / sql / SQLGrammar.java
1 package com.quantum.sql;
2
3 /**
4  * @author BC
5  */
6 public abstract class SQLGrammar {
7
8         public static String[] KEYWORDS = {
9                 "ADD", "ALL", "ALTER", "AND", "ANY",
10                 "AS", "ASC", "AUTOINCREMENT", "AVA", "BETWEEN",
11                 "BINARY", "BIT", "BOOLEAN", "BY", "CREATE",
12                 "BYTE", "CHAR", "CHARACTER", "COLUMN", "CONSTRAINT",
13                 "COUNT", "COUNTER", "CURRENCY", "DATABASE", "DATE",
14                 "DATETIME", "DELETE", "DESC", "DISALLOW", "DISTINCT",
15                 "DISTINCTROW", "DOUBLE", "DROP", "EXISTS", "FROM",
16                 "FLOAT", "FLOAT4", "FLOAT8", "FOREIGN", "GENERAL",
17                 "GROUP", "GUID", "HAVING", "INNER", "INSERT",
18                 "IGNORE", "IMP", "IN", "INDEX", "INT", 
19                 "INTEGER", "INTEGER1", "INTEGER2", "INTEGER4", "INTO",
20                 "IS", "JOIN", "KEY", "LEFT", "LEVEL", 
21                 "LIKE", "LOGICAL", "LONG", "LONGBINARY", "LONGTEXT",
22                 "MAX", "MEMO", "MIN", "MOD", "MONEY", 
23                 "NOT", "NULL", "NUMBER", "NUMERIC", "OLEOBJECT",
24                 "ON", "PIVOT", "OPTION", "PRIMARY", "ORDER",
25                 "OUTER", "OWNERACCESS", "PARAMETERS", "PERCENT", "REAL",
26                 "REFERENCES", "RIGHT", "SELECT", "SET", "SHORT",
27                 "SINGLE", "SMALLINT", "SOME", "STDEV", "STDEVP",
28                 "STRING", "SUM", "TABLE", "TABLEID", "TEXT", 
29                 "TIME", "TIMESTAMP", "TOP", "TRANSFORM", "UNION",
30                 "UNIQUE", "UPDATE", "VALUE", "VALUES", "VAR",
31                 "VARBINARY", "VARCHAR", "VARP", "WHERE", "WITH",
32                 "YESNO" 
33         };
34         
35     public static final String[] NON_RESERVED_WORDS = { 
36                 "ADA", "C", "CATALOG_NAME", "CHARACTER_SET_CATALOG", "CHARACTER_SET_NAME", 
37                         "CHARACTER_SET_SCHEMA", "CLASS_ORIGIN", "COBOL", "COLLATION_CATALOG", 
38                         "COLLATION_NAME", "COLLATION_SCHEMA", "COLUMN_NAME", "COMMAND_FUNCTION", 
39                         "COMMITTED", "CONDITION_NUMBER", "CONNECTION_NAME", "CONSTRAINT_CATALOG", 
40                         "CONSTRAINT_NAME", "CONSTRAINT_SCHEMA", "CURSOR_NAME", "DATA", 
41                         "DATETIME_INTERVAL_CODE", "DATETIME_INTERVAL_PRECISION", "DYNAMIC_FUNCTION", 
42                         "FORTRAN", "LENGTH", "MESSAGE_LENGTH", "MESSAGE_OCTET_LENGTH", 
43                         "MESSAGE_TEXT", "MORE", "MUMPS", "NAME", "NULLABLE", "NUMBER", "PASCAL", 
44                         "PLI", "REPEATABLE", "RETURNED_LENGTH", "RETURNED_OCTET_LENGTH", 
45                         "RETURNED_SQLSTATE", "ROW_COUNT", "SCALE", "SCHEMA_NAME", 
46                         "SERIALIZABLE", "SERVER_NAME", "SUBCLASS_ORIGIN", "TABLE_NAME", 
47                         "TYPE", "UNCOMMITTED", "UNNAMED"
48     };
49     
50     public static final String[] COMMANDS = {
51         "select * from ${tablename} where ${columnname} = ${value}",
52                 "update ${tablename} set ${columnname} = ${value} where ${column2name} = ${value2}"
53     };
54 }