AccountHandlerTest.java

package com.application.DB;

import org.junit.jupiter.api.Assertions;
import org.junit.jupiter.api.Test;

import static com.application.DB.Settings.USERS_TABLE_NAME;

class AccountHandlerTest {

    AccountHandlerTest(){
        USERS_TABLE_NAME = "users_testing";
    }

    @Test
    void logIn() throws Exception {
        AccountHandler.deleteUser("loginTestAccount");
        AccountHandler.addUser("test","test","+4712345678","loginTestAccount","test",false);
        Assertions.assertEquals(1, AccountHandler.logIn("loginTestAccount","test").getTotalRows());
        AccountHandler.deleteUser("loginTestAccount");
    }

    @Test
    void logInFailed() throws Exception {
        Assertions.assertEquals(0, AccountHandler.logIn("qefjdnweflkweoihde","test").getTotalRows());
    }

    @Test
    void getAccount() throws Exception {
        AccountHandler.deleteUser("testAccount");
        AccountHandler.addUser("test","test","+4712345678","testAccount","test",false);
        Assertions.assertEquals(1, AccountHandler.getAccount("testAccount").getTotalRows());
        AccountHandler.deleteUser("testAccount");
    }

    //The test checks if the user is added
    @Test
    void addUser() throws Exception {
        AccountHandler.deleteUser("testAccount");
        AccountHandler.addUser("test","test","+4712345678","testAccount","test",false);
        Assertions.assertEquals(1, AccountHandler.getAccount("testAccount").getTotalRows());
        AccountHandler.deleteUser("testAccount");
    }

    //The test checks if the user is added
    @Test
    void addAlreadyExistingUser() throws Exception {
        AccountHandler.deleteUser("testAccountAlready");
        AccountHandler.addUser("test","test","+4712345678","testAccountAlready","test",false);
        Assertions.assertFalse(AccountHandler.addUser("test","test","+4712345678","testAccountAlready","test",false));
        AccountHandler.deleteUser("testAccountAlready");
    }

    @Test
    void deleteUser() throws Exception {
        AccountHandler.deleteUser("deleteTestAccount");
        AccountHandler.addUser("test","test","+4712345678","deleteTestAccount","test",false);
        AccountHandler.deleteUser("deleteTestAccount");
        Assertions.assertEquals(0, AccountHandler.getAccount("deleteTestAccount").getTotalRows());
    }

    @Test
    void deleteUserNonExistingUser() throws Exception {
        Assertions.assertFalse(AccountHandler.deleteUser("erjfnerjkfwefbaekrørebf"));
    }
}