package com.seagate.mes.rho.common.utils;

import static org.junit.Assert.*;

import java.beans.PropertyVetoException;

import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.FixMethodOrder;
import org.junit.Test;
import org.junit.runners.MethodSorters;

import com.mchange.v2.c3p0.ComboPooledDataSource;

@FixMethodOrder(MethodSorters.NAME_ASCENDING)
public class HisSequenceServiceTest {

	private static ComboPooledDataSource ds;

	private HisSequenceService service;

	@BeforeClass
	public static void init() throws PropertyVetoException {
		 ds = new ComboPooledDataSource();
		 ds.setJdbcUrl( "jdbc:oracle:thin:@nrmlnhd1.nrm.minn.seagate.com:1521:nrmlnhd1" );
		 ds.setUser("hismes");
		 ds.setPassword("Seagate123");
	}

	@Before
	public void setUp() {
		service = new HisSequenceService(ds);
	}

	@Test
	public void test1CreateSequence() {

		HISSequenceVO vo = new HISSequenceVO();
		vo.setEntityName("TEST");
		vo.setEntityType("TEST");
		vo.setLastSeqNumber(0);
		vo.setMaxSeqNumber(999);

		long seq = service.createSequence(vo);

		assertEquals(0, seq);
	}

	@Test
	public void test2LastSequenceNumber() {

		HISSequenceVO vo = new HISSequenceVO();
		vo.setEntityName("TEST");
		vo.setEntityType("TEST");

		long seq = service.getLastSeqNumber(vo);

		assertEquals(0, seq);
	}

	@Test
	public void test3NextSequenceNumberCreateNew() {

		HISSequenceVO vo = new HISSequenceVO();
		vo.setEntityName("TEST1");
		vo.setEntityType("TEST");

		long seq = service.getNextSequenceNumber(vo);

		assertEquals(0, seq);
	}

	@Test
	public void test4NextSequenceNumber() {

		HISSequenceVO vo = new HISSequenceVO();
		vo.setEntityName("TEST");
		vo.setEntityType("TEST");

		long seq = service.getNextSequenceNumber(vo);

		assertEquals(1, seq);
	}

	@Test
	public void test5GetMaxSequenceNumber() {

		HISSequenceVO vo = new HISSequenceVO();
		vo.setEntityName("TEST");
		vo.setEntityType("TEST");

		long seq = service.getMaxSeqNumber(vo);

		assertEquals(999, seq);
	}

	@Test
	public void test6DeleteSequenceNumber() {

		service.deleteSequnce("TEST", "TEST");

		assertTrue(true);
	}

	@Test
	public void test7DeleteSequenceNumberTest1() {

		service.deleteSequnce("TEST1", "TEST");

		assertTrue(true);
	}

}