package eu.glowacki.utp.assignment10.repositories.test;

import oracle.jdbc.pool.OracleOCIConnectionPool;
import org.junit.After;
import org.junit.Before;

import eu.glowacki.utp.assignment10.dtos.DTOBase;
import eu.glowacki.utp.assignment10.repositories.IRepository;
import org.junit.BeforeClass;

import java.sql.Connection;
import java.sql.SQLException;

public abstract class RepositoryTestBase<TDTO extends DTOBase, TRepository extends IRepository<TDTO>> {

    protected TRepository _repository;
    protected static OracleOCIConnectionPool pool;


    @Before
    public void before() {
        _repository = Create();
        if (_repository != null) {
            _repository.beginTransaction();
        }
    }

    @After
    public void after() {
        if (_repository != null) {
            _repository.rollbackTransaction();
        }
    }

    @BeforeClass
    public static void createPool() {
        try {
            pool = new OracleOCIConnectionPool("s91247", "_oracle27", "jdbc:oracle:thin:@oracle_db:baze", null);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    protected abstract TRepository Create();
}