Skip to content

Commit 79500db

Browse files
radcortezradcortez
committed
Added tests for storedprocedure project.
1 parent 0a25ef4 commit 79500db

File tree

9 files changed

+80
-176
lines changed

9 files changed

+80
-176
lines changed

‎jpa/storedprocedure/pom.xml

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -6,9 +6,8 @@
66
<artifactId>jpa-samples</artifactId>
77
<version>1.0-SNAPSHOT</version>
88
<relativePath>../pom.xml</relativePath>
9-
</parent>
9+
</parent>
1010

11-
<groupId>org.javaee7.jpa</groupId>
1211
<artifactId>storedprocedure</artifactId>
1312
<version>1.0-SNAPSHOT</version>
1413
<packaging>war</packaging>

‎jpa/storedprocedure/src/main/java/org/javaee7/jpa/storedprocedure/Movie.java

Lines changed: 4 additions & 27 deletions
Original file line numberDiff line numberDiff line change
@@ -16,39 +16,22 @@
1616
*/
1717
@Entity
1818
@Table(name = "MOVIE_STORED_PROCEDURE")
19-
@XmlRootElement
2019
@NamedQueries({
2120
@NamedQuery(name = "Movie.findAll", query = "SELECT m FROM Movie m"),
22-
@NamedQuery(name = "Movie.findById", query = "SELECT m FROM Movie m WHERE m.id = :id"),
23-
@NamedQuery(name = "Movie.findByName", query = "SELECT m FROM Movie m WHERE m.name = :name"),
24-
@NamedQuery(name = "Movie.findByActors", query = "SELECT m FROM Movie m WHERE m.actors = :actors")})
25-
@NamedStoredProcedureQuery(name = "mySP", procedureName = "top10Movies")
21+
})
22+
@NamedStoredProcedureQuery(name = "top10Movies", procedureName = "top10Movies")
2623
public class Movie implements Serializable {
27-
private static final long serialVersionUID = 1L;
2824
@Id
2925
@NotNull
3026
private Integer id;
31-
27+
3228
@NotNull
3329
@Size(min = 1, max = 50)
3430
private String name;
35-
31+
3632
@NotNull
3733
@Size(min = 1, max = 200)
3834
private String actors;
39-
40-
public Movie() {
41-
}
42-
43-
public Movie(Integer id) {
44-
this.id = id;
45-
}
46-
47-
public Movie(Integer id, String name, String actors) {
48-
this.id = id;
49-
this.name = name;
50-
this.actors = actors;
51-
}
5235

5336
public Integer getId() {
5437
return id;
@@ -73,10 +56,4 @@ public String getActors() {
7356
public void setActors(String actors) {
7457
this.actors = actors;
7558
}
76-
77-
@Override
78-
public String toString() {
79-
return name;
80-
}
81-
8259
}

‎jpa/storedprocedure/src/main/java/org/javaee7/jpa/storedprocedure/MovieBean.java

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,23 @@
1+
package org.javaee7.jpa.storedprocedure;
2+
3+
import javax.ejb.Stateless;
4+
import javax.persistence.EntityManager;
5+
import javax.persistence.PersistenceContext;
6+
import java.util.List;
7+
8+
/**
9+
* @author Roberto Cortez
10+
*/
11+
@Stateless
12+
public class MovieBean {
13+
@PersistenceContext
14+
private EntityManager em;
15+
16+
public List<Movie> listMovies() {
17+
return em.createNamedQuery("Movie.findAll", Movie.class).getResultList();
18+
}
19+
20+
public void executeStoredProcedure() {
21+
em.createNamedStoredProcedureQuery("top10Movies").execute();
22+
}
23+
}

‎jpa/storedprocedure/src/main/java/org/javaee7/jpa/storedprocedure/TestServlet.java

Lines changed: 0 additions & 83 deletions
This file was deleted.

‎jpa/storedprocedure/src/main/resources/META-INF/create.sql

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,2 +1 @@
1-
DROP TABLE MOVIE_STORED_PROCEDURE
2-
CREATE TABLE MOVIE_STORED_PROCEDURE("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "ACTORS" VARCHAR(200) not null)
1+
CREATE TABLE MOVIE_STORED_PROCEDURE("ID" INTEGER not null primary key, "NAME" VARCHAR(50) not null, "ACTORS" VARCHAR(200) not null)

‎jpa/storedprocedure/src/main/resources/META-INF/drop.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
DROP TABLE MOVIE_STORED_PROCEDURE

‎jpa/storedprocedure/src/main/resources/META-INF/persistence.xml

Lines changed: 8 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,16 @@
11
<?xml version="1.0" encoding="UTF-8"?>
2-
<persistence version="2.1"
3-
xmlns="http://xmlns.jcp.org/xml/ns/persistence"
4-
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
2+
<persistence version="2.1"
3+
xmlns="http://xmlns.jcp.org/xml/ns/persistence"
4+
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
55
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
66
<persistence-unit name="myPU" transaction-type="JTA">
77
<properties>
8-
<property name="javax.persistence.ddl-create-script-source" value="META-INF/create.sql"/>
8+
<property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
9+
<property name="javax.persistence.schema-generation.create-source" value="script"/>
10+
<property name="javax.persistence.schema-generation.drop-source" value="script"/>
11+
<property name="javax.persistence.schema-generation.create-script-source" value="META-INF/create.sql"/>
12+
<property name="javax.persistence.schema-generation.drop-script-source" value="META-INF/drop.sql"/>
913
<property name="javax.persistence.sql-load-script-source" value="META-INF/load.sql"/>
10-
<property name="eclipselink.deploy-on-startup" value="true"/>
11-
<property name="eclipselink.logging.exceptions" value="false"/>
12-
<!--<property name="eclipselink.logging.level" value="FINE"/>-->
1314
</properties>
1415
</persistence-unit>
1516
</persistence>

‎jpa/storedprocedure/src/main/webapp/index.jsp

Lines changed: 0 additions & 55 deletions
This file was deleted.

‎jpa/storedprocedure/src/test/java/org/javaee7/jpa/storedprocedure/StoredProcedureTest.java

Lines changed: 42 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,42 @@
1+
package org.javaee7.jpa.storedprocedure;
2+
3+
import org.jboss.arquillian.container.test.api.Deployment;
4+
import org.jboss.arquillian.junit.Arquillian;
5+
import org.jboss.shrinkwrap.api.ShrinkWrap;
6+
import org.jboss.shrinkwrap.api.spec.WebArchive;
7+
import org.junit.Test;
8+
import org.junit.runner.RunWith;
9+
10+
import javax.inject.Inject;
11+
import java.util.List;
12+
13+
import static org.junit.Assert.assertFalse;
14+
15+
/**
16+
* @author Roberto Cortez
17+
*/
18+
@RunWith(Arquillian.class)
19+
public class StoredProcedureTest {
20+
@Inject
21+
private MovieBean movieBean;
22+
23+
@Deployment
24+
public static WebArchive createDeployment() {
25+
WebArchive war = ShrinkWrap.create(WebArchive.class)
26+
.addPackage("org.javaee7.jpa.storedprocedure")
27+
.addAsResource("META-INF/persistence.xml")
28+
.addAsResource("META-INF/create.sql")
29+
.addAsResource("META-INF/drop.sql")
30+
.addAsResource("META-INF/load.sql");
31+
System.out.println(war.toString(true));
32+
return war;
33+
}
34+
35+
@Test
36+
public void testStoredProcedure() throws Exception {
37+
List<Movie> movies = movieBean.listMovies();
38+
assertFalse(movies.isEmpty());
39+
40+
//movieBean.executeStoredProcedure();
41+
}
42+
}

0 commit comments

Comments
 (0)