API tools faq
paste
Advertisement
Guest User

new.java

a guest
Nov 1st, 2015
142
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.74 KB | None | 0 0
raw download clone embed print report
  1. package org.jboss.tools.examples.test;
  2.  
  3. import static org.junit.Assert.assertNotNull;
  4.  
  5. import java.text.SimpleDateFormat;
  6. import java.util.HashSet;
  7. import java.util.Iterator;
  8. import java.util.LinkedHashSet;
  9. import java.util.List;
  10. import java.util.Set;
  11. import java.util.logging.Logger;
  12.  
  13.  
  14. import javax.inject.Inject;
  15. import javax.persistence.EntityManager;
  16. import javax.persistence.Query;
  17.  
  18. import org.jboss.arquillian.container.test.api.Deployment;
  19. import org.jboss.arquillian.junit.Arquillian;
  20. import org.jboss.arquillian.transaction.api.annotation.TransactionMode;
  21. import org.jboss.arquillian.transaction.api.annotation.Transactional;
  22. import org.jboss.tools.examples.model.Comission;
  23. import org.jboss.tools.examples.model.Member;
  24. import org.jboss.tools.examples.model.Project;
  25. import org.jboss.tools.examples.model.ProjectDate;
  26. import org.jboss.tools.examples.model.Team;
  27.  
  28. import org.jboss.tools.examples.service.MemberRegistration;
  29. import org.jboss.tools.examples.service.ProjectRegistration;
  30. import org.jboss.tools.examples.service.TeamRegistration;
  31. import org.jboss.tools.examples.util.Resources;
  32. import org.jboss.shrinkwrap.api.Archive;
  33. import org.jboss.shrinkwrap.api.ShrinkWrap;
  34. import org.jboss.shrinkwrap.api.asset.EmptyAsset;
  35. import org.jboss.shrinkwrap.api.spec.WebArchive;
  36. import org.junit.Test;
  37. import org.junit.runner.RunWith;
  38.  
  39. @Transactional(TransactionMode.COMMIT)
  40. @RunWith(Arquillian.class)
  41. public class MemberRegistrationTest {
  42. @Deployment
  43. public static Archive<?> createTestArchive() {
  44. WebArchive archive = ShrinkWrap.create(WebArchive.class, "test.war")
  45. .addClasses(Member.class, MemberRegistration.class, Resources.class, Team.class,TeamRegistration.class, Project.class,ProjectRegistration.class, Comission.class, ProjectDate.class)
  46. .addAsResource("META-INF/test-persistence.xml", "META-INF/persistence.xml")
  47. .addAsWebInfResource(EmptyAsset.INSTANCE, "beans.xml")
  48. // Deploy our test datasource
  49. .addAsWebInfResource("test-ds.xml");
  50.  
  51.  
  52. return archive;
  53. }
  54.  
  55. @Inject
  56. MemberRegistration memberRegistration;
  57.  
  58. @Inject
  59. TeamRegistration teamRegistration;
  60.  
  61. @Inject
  62. ProjectRegistration projectRegistration;
  63.  
  64. @Inject
  65. EntityManager entityManager;
  66.  
  67. @Inject
  68. Logger log;
  69.  
  70.  
  71. @Test
  72. public void testRegister() throws Exception {
  73. //members
  74.  
  75. Member member1=new Member("Member1", "some_mail_1@fel.cvut.cz","male", "1234567890", "11");
  76. memberRegistration.register(member1);
  77. assertNotNull(member1.getId());
  78. log.info(member1.getName() + " was persisted with id " + member1.getId());
  79.  
  80.  
  81.  
  82. Member member2=new Member("Member2", "some_mail_2@fel.cvut.cz","male", "1234567890", "12");
  83. memberRegistration.register(member2);
  84. log.info(member2.getName() + " was persisted with id " + member2.getId());
  85. assertNotNull(member2.getId());
  86.  
  87.  
  88. Member member3=new Member("Member3", "some_mail_3@fel.cvut.cz","male", "1234567890", "13");
  89. memberRegistration.register(member3);
  90. log.info(member3.getName() + " was persisted with id " + member3.getId());
  91. assertNotNull(member3.getId());
  92.  
  93. Member member4=new Member("Member4", "some_mail_4@fel.cvut.cz","male", "1234567890", "18");
  94. memberRegistration.register(member4);
  95. log.info(member4.getName() + " was persisted with id " + member4.getId());
  96. assertNotNull(member4.getId());
  97.  
  98. Member member5=new Member("Member5", "some_mail_5@fel.cvut.cz","female", "1234567890", "19");
  99. memberRegistration.register(member5);
  100. log.info(member5.getName() + " was persisted with id " + member3.getId());
  101. assertNotNull(member5.getId());
  102.  
  103. Member member6=new Member("Member6", "some_mail_6@fel.cvut.cz","female", "1234567890", "18");
  104. memberRegistration.register(member6);
  105. log.info(member6.getName() + " was persisted with id " + member6.getId());
  106. assertNotNull(member6.getId());
  107.  
  108. Member member7=new Member("Member7", "some_mail_7@fel.cvut.cz","female", "1234567890", "89");
  109. memberRegistration.register(member7);
  110. log.info(member7.getName() + " was persisted with id " + member7.getId());
  111. assertNotNull(member7.getId());
  112.  
  113. Member member8=new Member("Member8", "some_mail_8@fel.cvut.cz","female", "1234567890", "22");
  114. memberRegistration.register(member8);
  115. log.info(member8.getName() + " was persisted with id " + member8.getId());
  116. assertNotNull(member8.getId());
  117.  
  118. Member member9=new Member("Member9", "some_mail_9@fel.cvut.cz","male", "1234567890", "33");
  119. memberRegistration.register(member9);
  120. log.info(member9.getName() + " was persisted with id " + member9.getId());
  121. assertNotNull(member9.getId());
  122.  
  123. Member member10=new Member("Member10", "some_mail_10@fel.cvut.cz","male", "1234567890", "55");
  124. memberRegistration.register(member10);
  125. log.info(member10.getName() + " was persisted with id " + member10.getId());
  126. assertNotNull(member10.getId());
  127.  
  128.  
  129.  
  130.  
  131. //teams
  132. SimpleDateFormat dateformat = new SimpleDateFormat("dd/MM/yyyy");
  133.  
  134. Team team1=new Team("team1", dateformat.parse("17/07/1989"),"description1", "orientation1");
  135. team1.setLeader(member1);
  136. team1.addMember(member1);
  137. team1.addMember(member2);
  138. team1.addMember(member3);
  139.  
  140.  
  141. teamRegistration.register(team1);
  142. log.info(team1.getName() + " was persisted with id " + team1.getId());
  143. assertNotNull(team1.getId());
  144.  
  145.  
  146. Team team2=new Team("team2", dateformat.parse("17/09/1989"),"description2", "orientation2");
  147. team2.setLeader(member2);
  148. team2.addMember(member3);
  149. team2.addMember(member4);
  150. team2.addMember(member5);
  151. team2.addMember(member6);
  152.  
  153. teamRegistration.register(team2);
  154. log.info(team2.getName() + " was persisted with id " + team2.getId());
  155. assertNotNull(team2.getId());
  156.  
  157. Team team3=new Team("team3", dateformat.parse("17/07/1989"),"description3", "orientation3");
  158. team3.setLeader(member9);
  159. team3.addMember(member7);
  160. team3.addMember(member8);
  161.  
  162.  
  163. teamRegistration.register(team3);
  164. log.info(team3.getName() + " was persisted with id " + team3.getId());
  165. assertNotNull(team3.getId());
  166.  
  167.  
  168. Project project1=new Project("Project1","descrip1","solutdescr");
  169. project1.addTeam(team1);
  170. project1.addTeam(team2);
  171. projectRegistration.register(project1);
  172. log.info(project1.getName() + " was persisted with id " + project1.getId());
  173. assertNotNull(project1.getId());
  174.  
  175. Project project2=new Project("Project2","descrip2","solutdescr");
  176. project1.addTeam(team1);
  177. System.out.println(team1.getMembers().size());
  178. projectRegistration.register(project2);
  179. log.info(project2.getName() + " was persisted with id " + project2.getId());
  180. assertNotNull(project2.getId());
  181.  
  182. Project project3=new Project("Project3","descrip3","solutdescr");
  183. project1.addTeam(team2);
  184. projectRegistration.register(project3);
  185. log.info(project3.getName() + " was persisted with id " + project3.getId());
  186. assertNotNull(project3.getId());
  187.  
  188. Project project4=new Project("Project4","descrip4","solutdescr");
  189. project1.addTeam(team3);
  190. projectRegistration.register(project4);
  191. log.info(project4.getName() + " was persisted with id " + project4.getId());
  192. assertNotNull(project4.getId());
  193.  
  194.  
  195.  
  196. //1
  197. String hql_1 = "from Team t order by t.name";
  198. Query query_1 = entityManager.createQuery(hql_1);
  199. List list_1=query_1.getResultList();
  200. log.info("=====3=====");
  201. System.out.println(list_1.size());
  202. Iterator it3 = list_1.iterator();
  203. while (it3.hasNext()) {
  204. Team t = (Team) it3.next();
  205. log.info("the name is " + t.getName());
  206. log.info("the id is " + t.getId());
  207. }
  208.  
  209.  
  210.  
  211.  
  212. //2
  213. entityManager.clear();
  214. String hql_2 = "select t.id from Member m join m.teams t where m.sex=:sex";
  215. Query query_2 = entityManager.createQuery(hql_2);
  216. query_2.setParameter("sex","female");
  217. List list_2=query_2.getResultList();
  218.  
  219.  
  220. entityManager.clear();
  221. String hql_22="from Team t where t.id in (:list_2)";
  222. Query query_22=entityManager.createQuery(hql_22);
  223. query_22.setParameter("list_2",list_2);
  224. List list_res=query_22.getResultList();
  225.  
  226. log.info("=====3=====");
  227.  
  228. System.out.println("lengthhh "+list_res.size());
  229. Iterator it4 = list_res.iterator();
  230. while (it4.hasNext()) {
  231. Team t = (Team) it4.next();
  232. log.info("the name is " + t.getName());
  233. log.info("the id is " + t.getId());
  234. }
  235.  
  236. //3
  237. entityManager.clear();
  238. Query query_3=entityManager.createQuery("from Member as M join fetch M.teams as teams join fetch teams.projects as p "
  239. +"where p.name = :name ");
  240.  
  241.  
  242. query_3.setParameter("name","Project1");
  243. List list=query_3.getResultList();
  244. log.info("=====3=====");
  245. Iterator it5 = list.iterator();
  246. while (it5.hasNext()) {
  247. Member m = (Member) it5.next();
  248. log.info("the name is " + m.getName());
  249. log.info("the id is " + m.getId());
  250. }
  251.  
  252. }
  253. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!