Quick implementation of BETWEEN, IS NULL, and IS NOT NULL.

1 files changed, 9 insertions, 0 deletions

diff --git a/tests/com/iciql/test/ModelsTest.java b/tests/com/iciql/test/ModelsTest.java
index acaf634..c529012 100644
--- a/tests/com/iciql/test/ModelsTest.java
+++ b/tests/com/iciql/test/ModelsTest.java
@@ -131,6 +131,11 @@ public class ModelsTest {
 
 		List<EnumModels> list = db.from(e).where(e.tree()).atLeast(Tree.BIRCH).select();
 		assertEquals(3, list.size());
+		
+		// between is an int compare
+		list = db.from(e).where(e.tree()).between(Tree.BIRCH, Tree.WALNUT).select();
+		assertEquals(2, list.size());
+
 	}
 	
 	private void testStringEnums(EnumModels e, List<?> models) {
@@ -143,6 +148,10 @@ public class ModelsTest {
 
 		List<EnumModels> list = db.from(e).where(e.tree()).isNot(Tree.BIRCH).select();
 		assertEquals(models.size() - 1, list.size());
+		
+		// between is a string compare
+		list = db.from(e).where(e.tree()).between(Tree.MAPLE, Tree.PINE).select();
+		assertEquals(3, list.size());
 	}
 
 	@Test