001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041:
042: package org.netbeans.modules.db.api.sql;
043:
044: import junit.framework.*;
045:
046: /**
047: * Tests the SQLKeyword class, that is, it ensures that the is.*Keyword()
048: * methods return true for all keywords. Hopefull this will catch someone
049: * making the keyword lists not correctly ordered when adding a
050: * possibly forgotten keyword.
051: *
052: * @author Andrei Badea
053: */
054: public class SQLKeywordsTest extends TestCase {
055:
056: public SQLKeywordsTest(String testName) {
057: super (testName);
058: }
059:
060: public void testIsSQL99ReservedKeyword() {
061: for (int i = 0; i < SQLKeywords.SQL99_RESERVED.length; i++) {
062: String identifier = SQLKeywords.SQL99_RESERVED[i]
063: .toUpperCase();
064: assertTrue(identifier + " should be a reserved keyword",
065: SQLKeywords.isSQL99ReservedKeyword(identifier));
066: identifier = identifier.toLowerCase();
067: assertTrue(identifier + " should be a reserved keyword",
068: SQLKeywords.isSQL99ReservedKeyword(identifier));
069: }
070:
071: // should return null for non-keywords
072: assertFalse(SQLKeywords.isSQL99ReservedKeyword("FOOBAR"));
073:
074: // null identifier should throw NPE
075: try {
076: SQLKeywords.isSQL99ReservedKeyword(null);
077: fail("Should have thrown NullPointerException");
078: } catch (NullPointerException e) {
079: }
080: }
081:
082: public void testIsSQL99NonReservedKeyword() {
083: for (int i = 0; i < SQLKeywords.SQL99_NON_RESERVED.length; i++) {
084: String identifier = SQLKeywords.SQL99_NON_RESERVED[i]
085: .toUpperCase();
086: assertTrue(
087: identifier + " should be a non-reserved keyword",
088: SQLKeywords.isSQL99NonReservedKeyword(identifier));
089: identifier = identifier.toLowerCase();
090: assertTrue(
091: identifier + " should be a non-reserved keyword",
092: SQLKeywords.isSQL99NonReservedKeyword(identifier));
093: }
094:
095: // should return null for non-keywords
096: assertFalse(SQLKeywords.isSQL99NonReservedKeyword("FOOBAR"));
097:
098: // null identifier should throw NPE
099: try {
100: SQLKeywords.isSQL99NonReservedKeyword(null);
101: fail("Should have thrown NullPointerException");
102: } catch (NullPointerException e) {
103: }
104: }
105:
106: public void testIsSQL99Keyword() {
107: for (int i = 0; i < SQLKeywords.SQL99_RESERVED.length; i++) {
108: String identifier = SQLKeywords.SQL99_RESERVED[i]
109: .toUpperCase();
110: assertTrue(identifier + " should be a keyword", SQLKeywords
111: .isSQL99Keyword(identifier));
112: identifier = identifier.toLowerCase();
113: assertTrue(identifier + " should be a keyword", SQLKeywords
114: .isSQL99Keyword(identifier));
115: }
116: for (int i = 0; i < SQLKeywords.SQL99_NON_RESERVED.length; i++) {
117: String identifier = SQLKeywords.SQL99_RESERVED[i]
118: .toUpperCase();
119: assertTrue(identifier + " should be a keyword", SQLKeywords
120: .isSQL99Keyword(identifier));
121: identifier = identifier.toLowerCase();
122: assertTrue(identifier + " should be a keyword", SQLKeywords
123: .isSQL99Keyword(identifier));
124: }
125:
126: // should return null for non-keywords
127: assertFalse(SQLKeywords.isSQL99Keyword("FOOBAR"));
128:
129: // null identifier should throw NPE
130: try {
131: SQLKeywords.isSQL99Keyword(null);
132: fail("Should have thrown NullPointerException");
133: } catch (NullPointerException e) {
134: }
135: }
136: }
|