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

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import static org.junit.Assert.fail;


public class TestManager {

    private final static String DBDRIVER = "org.hsqldb.jdbc.JDBCDriver";
    private static Connection connection;

    @Before
    public void setUpDB() throws ClassNotFoundException, SQLException {
        Class.forName(DBDRIVER);
        connection = DriverManager.getConnection( "jdbc:hsqldb:hsql://localhost/workdb", "SA", "");
        Main.addUser(connection, new User("Aa",1999,true));
        Main.addUser(connection, new User("Cc",1998,true));
    }

    @After
    public void closeConnection() throws SQLException {
        connection.close();
    }


    @Test
    public void testAddUserSucces() throws ClassNotFoundException, SQLException {
        boolean isAdded=Main.addUser(connection, new User("Aa",1999,true));
        Assert.assertTrue(isAdded);
    }

    @Test(expected=NullPointerException.class)
    public void testAddUserReturnNull() throws ClassNotFoundException, SQLException {
        fail(String.valueOf(Main.addUser(connection, null)));
    }


    @Test
    public void testMethodDeleteUserSuccess() throws ClassNotFoundException, SQLException {
        Main.addUserWithId(connection, new User(-2,"Cc",1998,true));
        int isDeleted=Main.deleteUser(connection,-2);
        Assert.assertEquals(1,isDeleted);
    }

    @Test
    public void testDeleteUserFail() throws ClassNotFoundException, SQLException {

        int isDeleted=Main.deleteUser(connection,-1);
        Assert.assertNotEquals(1,isDeleted);
    }

    @Test
    public void testUpdateUserSuccess() throws ClassNotFoundException, SQLException {

        int isUpdated=Main.updateUser(connection,new User(0,"BBB",1990,false));
        Assert.assertEquals(1,isUpdated);
    }

    @Test
    public void testUpdateUserFail() throws ClassNotFoundException, SQLException {

        int isUpdated=Main.updateUser(connection,new User(-2,"BBB",1990,false));
        Assert.assertEquals(0,isUpdated);
    }

    @Test
    public void testReadUserSuccess() throws Exception {
        User user=Main.readUser(connection,0);
        Assert.assertEquals(0,user.getId());
    }

    @Test
    public void testReadEmptyUser() throws Exception {
        User user=Main.readUser(connection,-1);
        User excpectedUser=new User(0,null,0,false);
        Assert.assertEquals(excpectedUser.getFirstname(),user.getFirstname());
    }


}