create or replace TRIGGER trigdCOTEST
after INSERT or UPDATE of duree on TravailC
Declare
rec_employe EmployeC%ROWtype;
Begin
Select * into rec_employe from employeC e
where (select sum(duree) from travailC t where e.nuempl=t.nuempl)> hebdo ;
/*un seul enregistrement relève une exception*/
raise_application_error(-20002, 'Un employé dépasse son temps de travil hebdomadaire en faite !!');
Exception
When no_data_found Then NULL;
When too_many_rows then
raise_application_error(-20003, 'Plusieurs employés dépasse leur temps de travail hebdomadaire en faite !!');
end;

/*

package tp;
import static org.junit.Assert.assertEquals;
import static org.junit.jupiter.api.Assertions.assertThrows;

import org.junit.jupiter.api.Test;

import electromenager.MicroOndeException;


public class TestMicroCalcul {


	@Test
	public void test_porteouvertexception() {
		MicroOnde m = new MicroOnde(2,5,true);
		assertThrows(MicroOndeException.class, () -> m.ouvrir_porte() );
	}

	@Test
	public void test_porteouvertsansexception() throws MicroOndeException {
		MicroOnde m = new MicroOnde(2,5,false);
			m.ouvrir_porte();
			assertEquals(true, m.porteOuverte);

	}

	@Test
	public void test_fermerporteexception() {
		MicroOnde m = new MicroOnde(2,5,false);
		assertThrows(MicroOndeException.class, () -> m.fermer_porte() );
	}

	@Test
	public void test_fermerportetempssup0() throws MicroOndeException {
		MicroOnde m = new MicroOnde(2,5,true);
			m.fermer_porte();
			assertEquals(false, m.porteOuverte);
			assertEquals(true, m.enMarche);
	}

	@Test
	public void test_fermerporte_temps() throws MicroOndeException {
		MicroOnde m = new MicroOnde(-2,5,true);
		 m.fermer_porte();
		 assertEquals(false, m.porteOuverte);
		 assertEquals(false, m.enMarche);
	}

	@Test
	public void test_multtab0() {
		int res = new  Operations().multiplier(new int[2]);
		assertEquals(0, res);
	}

	@Test
	public void test_multtab5() {
		int[] a = new int[4];
		a[0] = 1;
		a[1] = 2;
		a[2] = 3;
		a[3] = 4;
		int res = new  Operations().multiplier(a);
		assertEquals(24, res);
	}

	@Test
	public void test_multtab() {
		int[] a = new int[3];
		a[0] = 1;
		a[1] = 2;
		a[2] = 3;
		int res = new  Operations().multiplier(a);
}

Operations op = new Operations();

	@ParameterizedTest
	@MethodSource("intProviderAdd")
	void testAdditionner(int[] op1, int oracle) {
		int result = op.additionner(op1);
		assertEquals(oracle, result, op1 + " devrait rendre "+ oracle + " mais rend " + result);
	}

	static Stream<Arguments> intProviderAdd(){
		return Stream.of(
			Arguments.of(new int[] {1,2},3),
			Arguments.of(new int[] {5,5},10),
			Arguments.of(new int[] {5,5,5},15),
			Arguments.of(new int[] {1,2,3},6),
			Arguments.of(new int[] {2,1,3},6),
			Arguments.of(new int[] {3,2,1},6),
			Arguments.of(new int[] {0},0),
			Arguments.of(new int[] {-4,4},0),
			Arguments.of(new int[] {-2,0,2},0)
			);
	}


*/