package testUnitaire.database.crud.alltest;

import java.sql.Date;
import java.sql.SQLException;

import org.junit.Before;
import org.junit.Test;

import testUnitaire.database.crud.testCrud;
import database.crud.reservation.ReservationGroupeCrud;
import database.dataset.Reservation;
import database.dataset.Reservation_groupe;

public class testCrudReservationGroupe extends testCrud<Reservation_groupe> {

	@Override
	@Before
	public void init() throws SQLException {
		setCrud(new ReservationGroupeCrud(getConnection()));
		setDataset(new Reservation_groupe(magicID, magicID, Date.valueOf("2013-05-05"), Date.valueOf("2013-05-07"), "un commentaire de qualiter", magicID, magicID));
		setDataset2(new Reservation_groupe(magicID+1, magicID, Date.valueOf("2013-05-05"), Date.valueOf("2013-05-07"), "un commentaire de qualiter", magicID, magicID));
	}
	
	@Test(expected = SQLException.class)  
	public void insertionDuneFKchambreNonValide() throws SQLException {  
		getCrud().create(new Reservation_groupe(magicID-1, magicID+1, Date.valueOf("2013-05-05"), Date.valueOf("2013-05-07"), "un commentaire de qualiter", magicID, magicID));
	}
	
	@Test(expected = SQLException.class)  
	public void insertionDuneFKstatusNonValide() throws SQLException {  
		getCrud().create(new Reservation_groupe(magicID-1, magicID, Date.valueOf("2013-05-05"), Date.valueOf("2013-05-07"), "un commentaire de qualiter", magicID+1, magicID));
	}
	
	@Test(expected = SQLException.class)  
	public void insertionDuneFKgroupeNonValide() throws SQLException {  
		getCrud().create(new Reservation_groupe(magicID-1, magicID, Date.valueOf("2013-05-05"), Date.valueOf("2013-05-07"), "un commentaire de qualiter", magicID, magicID+1));
	}
	
	@Test
	public void testDeReadByFkGroupe() throws SQLException{
		for (Reservation r :((ReservationGroupeCrud)getCrud()).readBygroupe_fk(magicID))
			System.out.println(r.toString());
	}
}