diff options
Diffstat (limited to 'tests/com/iciql/test')
-rw-r--r-- | tests/com/iciql/test/ModelsTest.java | 2 | ||||
-rw-r--r-- | tests/com/iciql/test/PrimitivesTest.java | 29 | ||||
-rw-r--r-- | tests/com/iciql/test/models/EnumModels.java | 2 | ||||
-rw-r--r-- | tests/com/iciql/test/models/SupportedTypes.java | 8 |
4 files changed, 26 insertions, 15 deletions
diff --git a/tests/com/iciql/test/ModelsTest.java b/tests/com/iciql/test/ModelsTest.java index 75c2073..8a933ae 100644 --- a/tests/com/iciql/test/ModelsTest.java +++ b/tests/com/iciql/test/ModelsTest.java @@ -163,7 +163,7 @@ public class ModelsTest { true); assertEquals(1, models.size()); // a poor test, but a start - assertEquals(1697, models.get(0).length()); + assertEquals(1780, models.get(0).length()); } @Test diff --git a/tests/com/iciql/test/PrimitivesTest.java b/tests/com/iciql/test/PrimitivesTest.java index aee2479..2d591c3 100644 --- a/tests/com/iciql/test/PrimitivesTest.java +++ b/tests/com/iciql/test/PrimitivesTest.java @@ -37,22 +37,27 @@ public class PrimitivesTest { db.insert(model);
PrimitivesModel p = new PrimitivesModel();
-
+
// retrieve model and compare
PrimitivesModel retrievedModel = db.from(p).selectFirst();
assertTrue(model.equivalentTo(retrievedModel));
- // retrieve with conditions and compare
-// StatementLogger.activateConsoleLogger();
-// retrievedModel = db.from(p).where(p.myLong).is(model.myLong).and(p.myInteger).is(model.myInteger)
-// .selectFirst();
-// assertTrue(model.equivalentTo(retrievedModel));
-//
-// // update myInteger and compare
-// db.from(p).set(p.myInteger).to(10).where(p.myLong).is(model.myLong).update();
-// retrievedModel = db.from(p).selectFirst();
-
-// assertEquals(10, retrievedModel.myInteger);
+ retrievedModel = db.from(p).where("mylong = ? and myinteger = ?", model.myLong, model.myInteger)
+ .selectFirst();
+ assertTrue(model.equivalentTo(retrievedModel));
+
+ // retrieve with conditions and compare
+ // StatementLogger.activateConsoleLogger();
+ // retrievedModel =
+ // db.from(p).where(p.myLong).is(model.myLong).and(p.myInteger).is(model.myInteger)
+ // .selectFirst();
+ // assertTrue(model.equivalentTo(retrievedModel));
+ //
+ // // update myInteger and compare
+ // db.from(p).set(p.myInteger).to(10).where(p.myLong).is(model.myLong).update();
+ // retrievedModel = db.from(p).selectFirst();
+
+ // assertEquals(10, retrievedModel.myInteger);
db.close();
}
diff --git a/tests/com/iciql/test/models/EnumModels.java b/tests/com/iciql/test/models/EnumModels.java index bd9d88a..e5f6f39 100644 --- a/tests/com/iciql/test/models/EnumModels.java +++ b/tests/com/iciql/test/models/EnumModels.java @@ -127,7 +127,7 @@ public abstract class EnumModels { // override the enumtype to string
// ensure that we specify a length so that the column is VARCHAR
- @IQEnum(EnumType.STRING)
+ @IQEnum(EnumType.NAME)
@IQColumn(length = 25)
private Tree tree;
diff --git a/tests/com/iciql/test/models/SupportedTypes.java b/tests/com/iciql/test/models/SupportedTypes.java index b8abf2d..49dd951 100644 --- a/tests/com/iciql/test/models/SupportedTypes.java +++ b/tests/com/iciql/test/models/SupportedTypes.java @@ -96,7 +96,11 @@ public class SupportedTypes { @IQColumn private byte[] myBlob; - @IQEnum(EnumType.STRING) + // test default enum type NAME + @IQColumn(trim = true, length = 25) + private Flower myDefaultFlower; + + @IQEnum(EnumType.NAME) @IQColumn(trim = true, length = 25) private Flower myFavoriteFlower; @@ -139,6 +143,7 @@ public class SupportedTypes { s.mySqlTime = new java.sql.Time(rand.nextLong()); s.mySqlTimestamp = new java.sql.Timestamp(rand.nextLong()); s.myBlob = new byte[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 }; + s.myDefaultFlower = Flower.DAFFODIL; s.myFavoriteFlower = Flower.MUM; s.myOtherFavoriteFlower = Flower.MARIGOLD; s.myFavoriteTree = Tree.BIRCH; @@ -162,6 +167,7 @@ public class SupportedTypes { same &= mySqlTime.toString().equals(s.mySqlTime.toString()); same &= myString.equals(s.myString); same &= compare(myBlob, s.myBlob); + same &= myDefaultFlower.equals(s.myDefaultFlower); same &= myFavoriteFlower.equals(s.myFavoriteFlower); same &= myOtherFavoriteFlower.equals(s.myOtherFavoriteFlower); same &= myFavoriteTree.equals(s.myFavoriteTree); |