Adding a test for table generation using JPA metadata

arun-gupta · arun-gupta · commit f8acc00a2faa · 2013-12-07T06:47:10.000-08:00
diff --git a/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/TestServlet.java b/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/TestServlet.java
diff --git a/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/metadata/Employee.java b/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/metadata/Employee.java
@@ -37,7 +37,7 @@
  * only if the new code is made subject to such option by the copyright
  * holder.
  */
-package org.javaee7.jpa.schemagen;
+package org.javaee7.jpa.schemagen.metadata;
 
 import java.io.Serializable;
 import javax.persistence.Column;
diff --git a/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/metadata/EmployeeBean.java b/jpa/schema-gen-metadata/src/main/java/org/javaee7/jpa/schemagen/metadata/EmployeeBean.java
@@ -37,7 +37,7 @@
  * only if the new code is made subject to such option by the copyright
  * holder.
  */
-package org.javaee7.jpa.schemagen;
+package org.javaee7.jpa.schemagen.metadata;
 
 import java.util.List;
 import javax.ejb.Stateless;
diff --git a/jpa/schema-gen-metadata/src/main/resources/META-INF/load.sql b/jpa/schema-gen-metadata/src/main/resources/META-INF/load.sql
@@ -0,0 +1,8 @@
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (1, 'Penny')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (2, 'Sheldon')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (3, 'Amy')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (4, 'Leonard')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (5, 'Bernadette')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (6, 'Raj')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (7, 'Howard')
+INSERT INTO EMPLOYEE_SCHEMA_GEN_METADATA("ID", "NAME") VALUES (8, 'Priya')
diff --git a/jpa/schema-gen-metadata/src/main/resources/META-INF/persistence.xml b/jpa/schema-gen-metadata/src/main/resources/META-INF/persistence.xml
@@ -9,6 +9,7 @@
             <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
             <property name="javax.persistence.schema-generation.create-source" value="metadata"/> 
             <property name="javax.persistence.schema-generation.drop-source" value="metadata"/> 
+            <property name="javax.persistence.sql-load-script-source" value="META-INF/load.sql"/> 
         </properties>
     </persistence-unit>
 </persistence>
diff --git a/jpa/schema-gen-metadata/src/main/webapp/index.jsp b/jpa/schema-gen-metadata/src/main/webapp/index.jsp
diff --git a/jpa/schema-gen-metadata/src/test/java/org/javaee7/jpa/schemagen/metadata/EmployeeBeanTest.java b/jpa/schema-gen-metadata/src/test/java/org/javaee7/jpa/schemagen/metadata/EmployeeBeanTest.java
@@ -0,0 +1,49 @@
+package org.javaee7.jpa.schemagen.metadata;
+
+import org.javaee7.jpa.schemagen.metadata.Employee;
+import org.javaee7.jpa.schemagen.metadata.EmployeeBean;
+import java.util.List;
+import javax.inject.Inject;
+import org.jboss.arquillian.container.test.api.Deployment;
+import org.jboss.arquillian.junit.Arquillian;
+import org.jboss.shrinkwrap.api.ShrinkWrap;
+import org.jboss.shrinkwrap.api.spec.WebArchive;
+import org.junit.Test;
+import static org.junit.Assert.*;
+import org.junit.runner.RunWith;
+
+/**
+ * @author Arun Gupta
+ */
+@RunWith(Arquillian.class)
+public class EmployeeBeanTest {
+
+    @Inject
+    EmployeeBean bean;
+
+    @Deployment
+    public static WebArchive createDeployment() {
+        return ShrinkWrap.create(WebArchive.class)
+                .addClasses(Employee.class,
+                        EmployeeBean.class)
+                .addAsResource("META-INF/persistence.xml")
+                .addAsResource("META-INF/load.sql");
+    }
+
+    @Test
+    public void testGet() throws Exception {
+        assertNotNull(bean);
+        List<Employee> list = bean.get();
+        assertNotNull(list);
+        assertEquals(8, list.size());
+        assertFalse(list.contains(new Employee("Penny")));
+        assertFalse(list.contains(new Employee("Sheldon")));
+        assertFalse(list.contains(new Employee("Amy")));
+        assertFalse(list.contains(new Employee("Leonard")));
+        assertFalse(list.contains(new Employee("Bernadette")));
+        assertFalse(list.contains(new Employee("Raj")));
+        assertFalse(list.contains(new Employee("Howard")));
+        assertFalse(list.contains(new Employee("Priya")));
+    }
+
+}
