io.ebeaninternal.server.deploy.parse.SqlReservedWords Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ebean Show documentation

composite of common runtime dependencies for all platforms

There is a newer version: 15.10.0

package io.ebeaninternal.server.deploy.parse;

import java.util.HashSet;

/**
 * Keywords deemed inappropriate for use as table alias' column or table name.
 * 
 * That is, they might cause sql syntax errors if used.
 * 
 */
public class SqlReservedWords {

	private static final String baseKeyWords =
		"ALIAS,ALTER,ADD,ALL,ARE,AND,ANY,ARRAY"
		+",AS,ASC,AT"
		+",AVG,BEGIN,BETWEEN,BIGINT,BINARY,BIT,BIT_LENGTH,BLOB,BOOLEAN"
		+",BOTH,BY,CALL,CALLED,CASCADE,CASCADED,CASE,CAST,CATALOG,CHAR"
		+",CHARACTER,CHECK,CLOB,CLOSE,COALESCE,COLLATE"
		+",COLLATION,COLUMN,COMMIT,CONDITION,CONNECT,CONNECTION,CONSTRAINT"
		+",CONSTRAINTS,CONSTRUCTOR,CONTAINS,CONTINUE,CONVERT"
		+",COUNT,CREATE,CROSS,CURRENT_DATE"
		+",CURRENT_PATH,CURRENT_ROLE,CURRENT_TIME,CURRENT_TIMESTAMP"
		+",CURRENT_USER,CURSOR,DATE"
		+",DAY,DEC,DECIMAL,DECLARE,DEFAULT,DELETE"
		+",DESC"
		+",DISTINCT,DO,DOUBLE,DROP,ELSE,ELSEIF,END,EQUALS"
		+",EXEC,EXIT,EXISTS,EXTRACT"
		+",FLOAT,FROM,FOR,FREE"
		+",GET,GLOBAL,GO,GOTO,GRANT,GROUP,HAVING,HOUR"
		+",IF,IN,INNER,INOUT,INSERT"
		+",INT,INTEGER,INTO,IS,JOIN"
		+",LAST,LIKE,LIMIT"
		+",MAX,MIN"
		+",NCHAR,NCLOB,NOT"
		+",NULL,NULLIF,NUMERIC,"
		+",OR,ORDER,OUTER"
		+",REAL,REF,REFERENCES"
		+",RETURN,RETURNS"
		+",SELECT,SSL"
		+",SMALLINT,"
		+",SYSTEM,SYSTEM_USER,TABLE"
		+",TO"
		+",TRIGGER,UNION,UNIQUE"
		+",UPDATE,USER,VARCHAR,VIEW,WHEN"
		+",WHERE,WITH";


	private static final HashSet keywords = new HashSet<>();
	static {

		String[] initialKeywords = baseKeyWords.split(",");
    for (String initialKeyword : initialKeywords) {
      keywords.add(initialKeyword.trim());
    }

	}


	/**
	 * Return true if the tableAlias is a keyword.
	 */
	public static synchronized boolean isKeyword(String keyword){
		String s = keyword.trim().toUpperCase();
		return keywords.contains(s);
	}

	/**
	 * Add a sql keyword to the known set.
	 */
	public static synchronized void addKeyword(String keyword){
		if (keyword != null){
			keyword = keyword.trim().toUpperCase();
			if (!keyword.isEmpty()){
				keywords.add(keyword);
			}
		}
	}
}