1 files changed, 134 insertions, 0 deletions
diff --git a/tests/com/iciql/test/UpgradesTest.java b/tests/com/iciql/test/UpgradesTest.java
new file mode 100644
index 0000000..d4c15e1
--- /dev/null
+++ b/tests/com/iciql/test/UpgradesTest.java
@@ -0,0 +1,134 @@
+/*
+ * Copyright 2011 James Moger.
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package com.iciql.test;
+
+import static org.junit.Assert.assertEquals;
+
+import java.util.List;
+import java.util.concurrent.atomic.AtomicInteger;
+
+import org.junit.Test;
+
+import com.iciql.Db;
+import com.iciql.DbUpgrader;
+import com.iciql.Iciql.IQVersion;
+import com.iciql.test.models.Product;
+import com.iciql.test.models.SupportedTypes;
+import com.iciql.test.models.SupportedTypes.SupportedTypes2;
+
+/**
+ * Tests the database and table upgrade functions.
+ * 
+ */
+public class UpgradesTest {
+
+	@Test
+	public void testDatabaseUpgrade() {
+		Db db = IciqlSuite.openNewDb();
+
+		List<Product> products = Product.getList();
+
+		// set the v1 upgrader and insert a record.
+		// this will trigger the upgrade.
+		V1DbUpgrader v1 = new V1DbUpgrader();
+		db.setDbUpgrader(v1);
+		db.insert(products.get(0));
+
+		// confirm that upgrade occurred
+		assertEquals(0, v1.oldVersion.get());
+		assertEquals(1, v1.newVersion.get());
+
+		// open a second connection to the database
+		// and then apply the v2 upgrade.
+		// For H2 its important to keep the first connection
+		// alive so that the database is not destroyed.
+		Db db2 = IciqlSuite.openCurrentDb();
+
+		// set the v2 upgrader and insert a record.
+		// this will trigger the upgrade.
+		V2DbUpgrader v2 = new V2DbUpgrader();
+		db2.setDbUpgrader(v2);
+		db2.insert(products.get(1));
+
+		// confirm that upgrade occurred
+		assertEquals(1, v2.oldVersion.get());
+		assertEquals(2, v2.newVersion.get());
+
+		db.executeUpdate("DROP TABLE iq_versions");
+		db.close();
+		db2.close();
+	}
+
+	@Test
+	public void testTableUpgrade() {
+		Db db = IciqlSuite.openNewDb();
+
+		// insert first, this will create version record automatically
+		List<SupportedTypes> original = SupportedTypes.createList();
+		db.insertAll(original);
+
+		// reset the dbUpgrader (clears the update check cache)
+		V2DbUpgrader dbUpgrader = new V2DbUpgrader();
+		db.setDbUpgrader(dbUpgrader);
+
+		SupportedTypes2 s2 = new SupportedTypes2();
+
+		List<SupportedTypes2> types = db.from(s2).select();
+		assertEquals(10, types.size());
+		assertEquals(1, dbUpgrader.oldVersion.get());
+		assertEquals(2, dbUpgrader.newVersion.get());
+		db.executeUpdate("DROP TABLE iq_versions");
+		db.close();
+	}
+
+	/**
+	 * A sample database upgrader class.
+	 */
+	class BaseDbUpgrader implements DbUpgrader {
+		final AtomicInteger oldVersion = new AtomicInteger(0);
+		final AtomicInteger newVersion = new AtomicInteger(0);
+
+		public boolean upgradeTable(Db db, String schema, String table, int fromVersion, int toVersion) {
+			// just claims success on upgrade request
+			oldVersion.set(fromVersion);
+			newVersion.set(toVersion);
+			return true;
+		}
+
+		public boolean upgradeDatabase(Db db, int fromVersion, int toVersion) {
+			// just claims success on upgrade request
+			oldVersion.set(fromVersion);
+			newVersion.set(toVersion);
+			return true;
+		}
+	}
+
+	/**
+	 * A sample V1 database upgrader class.
+	 */
+	@IQVersion(1)
+	class V1DbUpgrader extends BaseDbUpgrader {
+	}
+
+	/**
+	 * A sample V2 database upgrader class.
+	 */
+	@IQVersion(2)
+	class V2DbUpgrader extends BaseDbUpgrader {
+	}
+
+}