- package com.zenika.resanet.test;
- import com.zenika.resanet.modele.*;
- import org.hibernate.Query;
- import org.hibernate.SessionFactory;
- import org.hibernate.Transaction;
- import org.hibernate.cfg.Configuration;
- import org.hibernate.classic.Session;
- import org.junit.*;
- import java.util.Date;
- import java.util.List;
- /**
- * @author olivier
- */
- public class TestQueries {
- private static SessionFactory sessionFactory;
- private Session session;
- @BeforeClass
- public static void beforeAllTests() {
- Configuration configuration = new Configuration();
- configuration.configure();
- sessionFactory = configuration.buildSessionFactory();
- //insertTestData();
- }
- private static void insertTestData() {
- Session session = sessionFactory.openSession();
- Transaction tx = session.beginTransaction();
- tx.begin();
- Pays france = new Pays("France");
- Pays italie = new Pays("Italie");
- session.persist(france);
- session.persist(italie);
- Ville paris = new Ville("Paris");
- Ville lyon = new Ville("Lyon");
- Ville rome = new Ville("Rome");
- france.ajouterVille(paris);
- france.ajouterVille(lyon);
- italie.ajouterVille(rome);
- session.persist(paris);
- session.persist(lyon);
- session.persist(rome);
- Transport trainParisLyon = new Train(paris, lyon, new Date());
- trainParisLyon.setPrix(50);
- trainParisLyon.setHeureDepart("10");
- session.persist(trainParisLyon);
- Transport trainParisRome = new Train(paris, rome, new Date());
- session.persist(trainParisRome);
- Transport trainLyonRome = new Train(lyon, rome, new Date());
- session.persist(trainLyonRome);
- Transport trainRomeLyon = new Train(rome, lyon, new Date());
- trainRomeLyon.setHeureDepart("20");
- trainRomeLyon.setPrix(300);
- session.persist(trainRomeLyon);
- Reservation resa = new Reservation();
- resa.getTransports().add(trainParisLyon);
- resa.getTransports().add(trainParisRome);
- session.persist(resa);
- tx.commit();
- session.close();
- }
- @AfterClass
- public static void afterAllTests() {
- sessionFactory.close();
- }
- @Before
- public void beforeEachTest() {
- session = sessionFactory.openSession();
- }
- @After
- public void afterEachTest() {
- session.close();
- }
- }