package testUnitaire.database.crud.alltest;

import java.math.BigDecimal;
import java.sql.Date;
import java.sql.SQLException;
import java.sql.Time;

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

import testUnitaire.database.crud.testCrud;
import database.crud.vente.VenteArticleCrud;
import database.dataset.Vente_article;

public class testCrudVente_Article extends testCrud<Vente_article> {

	@Override
	@Before
	public void init() throws SQLException {
		setCrud(new VenteArticleCrud(getConnection()));
		setDataset(new Vente_article(magicID, Time.valueOf("10:15:32"), Date.valueOf("2013-05-07"), new BigDecimal("2.13"), magicID, magicID, 3));
		setDataset2(new Vente_article(magicID+1, Time.valueOf("10:15:32"), Date.valueOf("2013-05-07"), new BigDecimal("2.13"), magicID, magicID, 3));
	}

	@Test(expected = SQLException.class)  
	public void insertionDuneFKfactureNonValide() throws SQLException {
		getCrud().create(new Vente_article(magicID-1, Time.valueOf("10:15:32"), Date.valueOf("2013-05-07"), new BigDecimal("2.13"), magicID+1, magicID, 3));
	}
	
	@Test(expected = SQLException.class)  
	public void insertionDuneFKarticleNonValide() throws SQLException {  
		getCrud().create(new Vente_article(magicID-1, Time.valueOf("10:15:32"), Date.valueOf("2013-05-07"), new BigDecimal("2.13"), magicID, magicID+1, 3));
	}
}