Changeset 24

Timestamp:

Sep 22, 2010, 10:01:20 PM (14 years ago)

Author:

fmguler

Message:

Refs #3 - Added liquibase library for test database operations, which means we can update and rollback a test database in the test scenarios. Now we should add test scenarios to be tested on this database.

Location:

trunk/fmgVen

Files:

• etc/test-db (added)
• etc/test-db/test-db-changelog.xml (added)
• lib/nblibraries.properties (modified) (1 diff)
• lib/test/liquibase-1.9.5.jar (added)
• nbproject/project.properties (modified) (1 diff)
• test/com/fmguler/ven/sample/Sample.java (modified) (3 diffs)

trunk/fmgVen/lib/nblibraries.properties

@@ -6 +6 @@
     ${base}/CopyLibs/org-netbeans-modules-java-j2seproject-copylibstask.jar
 libs.Test.classpath=\
-    ${base}/test/postgresql-8.4-701.jdbc3.jar
+    ${base}/test/postgresql-8.4-701.jdbc3.jar;\
+    ${base}/test/liquibase-1.9.5.jar
 libs.Ven.classpath=\
     ${base}/ven/spring-beans.jar;\

trunk/fmgVen/nbproject/project.properties

@@ -39 +39 @@
     ${javac.classpath}:\
     ${build.classes.dir}:\
-    ${libs.junit.classpath}
+    ${libs.junit.classpath}:\
+    ${libs.Test.classpath}
 javadoc.additionalparam=
 javadoc.author=false

trunk/fmgVen/test/com/fmguler/ven/sample/Sample.java

@@ -20 +20 @@
 import com.fmguler.ven.Ven;
 import com.fmguler.ven.sample.domain.SomeDomainObject;
+import java.sql.SQLException;
+import java.util.Locale;
 import javax.sql.DataSource;
+import liquibase.FileSystemFileOpener;
+import liquibase.exception.JDBCException;
+import liquibase.exception.LiquibaseException;
 import org.springframework.jdbc.datasource.DriverManagerDataSource;
+import liquibase.Liquibase;
+import liquibase.database.Database;
+import liquibase.database.DatabaseFactory;
 
 /**
@@ -29 +37 @@
 public class Sample {
     public static void main(String[] args) {
+        buildDatabase();
         test1();
+        //rollbackDatabase();
     }
 
@@ -51 +61 @@
         ds.setUsername("postgres");
         ds.setPassword("qwerty");
-        ds.setUrl("jdbc:postgresql://127.0.0.1:5432/vendb");
+        ds.setUrl("jdbc:postgresql://127.0.0.1:5432/ven-test");
         return ds;
     }
+
+    private static void buildDatabase() {
+        try {
+            Locale currLocale = Locale.getDefault();
+            Locale.setDefault(Locale.ENGLISH);
+            Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(getDataSource().getConnection());
+            Liquibase liquibase = new Liquibase("etc/test-db/test-db-changelog.xml", new FileSystemFileOpener(), database);
+            liquibase.update("");
+            Locale.setDefault(currLocale);
+        } catch (SQLException ex) {
+            ex.printStackTrace();
+        } catch (JDBCException ex) {
+            ex.printStackTrace();
+        } catch (LiquibaseException ex) {
+            ex.printStackTrace();
+        }
+    }
+
+    private static void rollbackDatabase() {
+        try {
+            Locale currLocale = Locale.getDefault();
+            Locale.setDefault(Locale.ENGLISH);
+            Database database = DatabaseFactory.getInstance().findCorrectDatabaseImplementation(getDataSource().getConnection());
+            Liquibase liquibase = new Liquibase("etc/test-db/test-db-changelog.xml", new FileSystemFileOpener(), database);
+            //liquibase.rollback(51, "");
+            liquibase.rollback("0", "");
+            Locale.setDefault(currLocale);
+        } catch (SQLException ex) {
+            ex.printStackTrace();
+        } catch (JDBCException ex) {
+            ex.printStackTrace();
+        } catch (LiquibaseException ex) {
+            ex.printStackTrace();
+        }
+    }
 }