package Server;

import static org.junit.Assert.*;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

public class DBAccessTest {

	@Before
	public void setUp() throws Exception {
		String driver = "org.postgresql.Driver";
		Class.forName(driver);
		String url = "jdbc:postgresql://localhost:5432/postgres";
		String user = "postgres";
		String pw = "maciej"; //
		Connection connection = DriverManager.getConnection(url, user, pw);
		Statement statement = connection.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
		String sql;
		sql = "INSERT INTO postgres.sp5data.accounts (username, password, cpr)"
				+ " values ('Maciej', 'maciej123', '0803962781')";
		try {
			statement.executeUpdate(sql);
		} catch (SQLException e) {

			e.printStackTrace();
			if(e.getErrorCode()==23505){
				return;
			}
			else{
				return;
			}
		}
	}

	@After
	public void tearDown() throws Exception {
		String driver = "org.postgresql.Driver";
		Class.forName(driver);
		String url = "jdbc:postgresql://localhost:5432/postgres";
		String user = "postgres";
		String pw = "maciej"; //
		Connection connection = DriverManager.getConnection(url, user, pw);
		Statement statement = connection.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
		String sql;
		sql = "delete from postgres.sp5data.accounts (username, password, cpr, balance)"
				+ " where username = 'Maciej';";
		try {
			statement.executeUpdate(sql);
		} catch (SQLException e) {

			e.printStackTrace();
			if(e.getErrorCode()==23505){
				return;
			}
			else{
				return;
			}
		}
	}

	@Test
	public void checkUserPassTest() {
		DBAccess dba = DBAccess.getDBAccess();
		boolean check = dba.checkUserPass(userCheck, passCheck);
		assert(check, true);

        assert(dba.checkUserPass(userCheck, "wrongPassword"), false);
        assert(dba.checkUserPass("wrongUser", passCheck), false);
	}

}