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 }