001: /*
002: * $Id: TestNotNullConstraint.java,v 1.13 2005/12/20 18:32:41 ahimanikya Exp $
003: * =======================================================================
004: * Copyright (c) 2002 Axion Development Team. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above
011: * copyright notice, this list of conditions and the following
012: * disclaimer.
013: *
014: * 2. Redistributions in binary form must reproduce the above copyright
015: * notice, this list of conditions and the following disclaimer in
016: * the documentation and/or other materials provided with the
017: * distribution.
018: *
019: * 3. The names "Tigris", "Axion", nor the names of its contributors may
020: * not be used to endorse or promote products derived from this
021: * software without specific prior written permission.
022: *
023: * 4. Products derived from this software may not be called "Axion", nor
024: * may "Tigris" or "Axion" appear in their names without specific prior
025: * written permission.
026: *
027: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
028: * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
029: * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
030: * PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
031: * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
032: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
033: * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
034: * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
035: * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
036: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
037: * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
038: * =======================================================================
039: */
040:
041: package org.axiondb.constraints;
042:
043: import junit.framework.Test;
044: import junit.framework.TestSuite;
045:
046: import org.axiondb.ColumnIdentifier;
047: import org.axiondb.Constraint;
048: import org.axiondb.DataType;
049: import org.axiondb.TableIdentifier;
050: import org.axiondb.engine.rows.SimpleRow;
051: import org.axiondb.event.RowEvent;
052: import org.axiondb.event.RowInsertedEvent;
053: import org.axiondb.types.CharacterVaryingType;
054: import org.axiondb.types.IntegerType;
055:
056: /**
057: * @version $Revision: 1.13 $ $Date: 2005/12/20 18:32:41 $
058: * @author Rodney Waldhoff
059: */
060: public class TestNotNullConstraint extends BaseConstraintTest {
061:
062: //------------------------------------------------------------ Conventional
063:
064: public TestNotNullConstraint(String testName) {
065: super (testName);
066: }
067:
068: public static Test suite() {
069: return new TestSuite(TestNotNullConstraint.class);
070: }
071:
072: //---------------------------------------------------------- TestConstraint
073:
074: protected Constraint createConstraint() {
075: return new NotNullConstraint();
076: }
077:
078: protected Constraint createConstraint(String name) {
079: return new NotNullConstraint(name);
080: }
081:
082: //--------------------------------------------------------------- Lifecycle
083:
084: public void setUp() throws Exception {
085: super .setUp();
086: }
087:
088: public void tearDown() throws Exception {
089: super .tearDown();
090: }
091:
092: private Constraint makeConstraint(String name, String tablename,
093: String columnname, DataType columntype) {
094: NotNullConstraint constraint = new NotNullConstraint(name);
095: constraint.addSelectable(new ColumnIdentifier(
096: new TableIdentifier(tablename), columnname, null,
097: columntype));
098: return constraint;
099: }
100:
101: //------------------------------------------------------------------- Tests
102:
103: public void testEvaluateOnDelete() throws Exception {
104: Constraint constraint = makeConstraint("C1", "FOO", "NAME",
105: new CharacterVaryingType(10));
106: Constraint constraint2 = makeConstraint("C2", "FOO", "NUM",
107: new IntegerType());
108: SimpleRow row = createRow("testing", new Integer(17));
109: RowEvent event = new RowInsertedEvent(getTable(), row, null);
110: assertTrue(constraint.evaluate(event));
111: assertTrue(constraint2.evaluate(event));
112: }
113:
114: public void testEvaluateOnInsertOfNonNullString() throws Exception {
115: Constraint constraint = makeConstraint("C1", "FOO", "NAME",
116: new CharacterVaryingType(10));
117: SimpleRow row = createRow("testing", null);
118: RowEvent event = new RowInsertedEvent(getTable(), null, row);
119: assertTrue(constraint.evaluate(event));
120: }
121:
122: public void testEvaluateOnUpdateToNonNullString() throws Exception {
123: Constraint constraint = makeConstraint("C1", "FOO", "NAME",
124: new CharacterVaryingType(10));
125: SimpleRow old = createRow(null, null);
126: SimpleRow row = createRow("testing", null);
127: RowEvent event = new RowInsertedEvent(getTable(), old, row);
128: assertTrue(constraint.evaluate(event));
129: }
130:
131: public void testEvaluateOnInsertOfNullString() throws Exception {
132: Constraint constraint = makeConstraint("C1", "FOO", "NAME",
133: new CharacterVaryingType(10));
134: SimpleRow row = createRow(null, null);
135: RowEvent event = new RowInsertedEvent(getTable(), null, row);
136: assertTrue(!constraint.evaluate(event));
137: }
138:
139: public void testEvaluateOnUpdateToNullString() throws Exception {
140: Constraint constraint = makeConstraint("C1", "FOO", "NAME",
141: new CharacterVaryingType(10));
142: SimpleRow old = createRow(null, null);
143: SimpleRow row = createRow(null, null);
144: RowEvent event = new RowInsertedEvent(getTable(), old, row);
145: assertTrue(!constraint.evaluate(event));
146: }
147:
148: public void testEvaluateOnInsertOfNonNullInt() throws Exception {
149: Constraint constraint = makeConstraint("C2", "FOO", "NUM",
150: new IntegerType());
151: SimpleRow row = createRow(null, new Integer(17));
152: RowEvent event = new RowInsertedEvent(getTable(), null, row);
153: assertTrue(constraint.evaluate(event));
154: }
155:
156: public void testEvaluateOnUpdateToNonNullInt() throws Exception {
157: Constraint constraint = makeConstraint("C2", "FOO", "NUM",
158: new IntegerType());
159: SimpleRow old = createRow(null, null);
160: SimpleRow row = createRow(null, new Integer(17));
161: RowEvent event = new RowInsertedEvent(getTable(), old, row);
162: assertTrue(constraint.evaluate(event));
163: }
164:
165: public void testEvaluateOnInsertOfNullInt() throws Exception {
166: Constraint constraint = makeConstraint("C2", "FOO", "NUM",
167: new IntegerType());
168: SimpleRow row = createRow(null, null);
169: RowEvent event = new RowInsertedEvent(getTable(), null, row);
170: assertTrue(!constraint.evaluate(event));
171: }
172:
173: public void testEvaluateOnUpdateToNullInt() throws Exception {
174: Constraint constraint = makeConstraint("C2", "FOO", "NUM",
175: new IntegerType());
176: SimpleRow old = createRow(null, null);
177: SimpleRow row = createRow(null, null);
178: RowEvent event = new RowInsertedEvent(getTable(), old, row);
179: assertTrue(!constraint.evaluate(event));
180: }
181:
182: }
|