newest quantum CVS sources

[phpeclipse.git] / archive / net.sourceforge.phpeclipse.quantum.sql / src / com / quantum / sql / SQLGrammar.java

diff --git a/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/sql/SQLGrammar.java b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/sql/SQLGrammar.java
new file mode 100644 (file)
index 0000000..0bb0eed
--- /dev/null
+++ b/archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/sql/SQLGrammar.java
@@ -0,0 +1,54 @@
+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}"
+    };
+}