/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package fitness.application;

import java.time.LocalDate;
import java.util.ArrayList;
import java.util.Arrays;
import org.junit.After;
import org.junit.AfterClass;
import org.junit.Assert;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;
import static org.junit.Assert.*;

/**
 *
 * @author Simon Read, Simon William and James Tan
 */
public class DatabaseControllerTest {

    public DatabaseControllerTest() {
    }

    @BeforeClass
    public static void setUpClass() {
    }

    @AfterClass
    public static void tearDownClass() {
    }

    @Before
    public void setUp() {
    }

    @After
    public void tearDown() {
    }

    /**
     * Test of getUserDashboard method, of class DatabaseController.
     */
    @Test
    public void testGetUserDashboard() {
        DatabaseController instance = new DatabaseController();
        System.out.println("getUserDashboard");

        instance.userId = 8888;

        ArrayList<ArrayList> expResult = new ArrayList<ArrayList>();
        ArrayList<String> goals = new ArrayList<String>();
        ArrayList<String> daily = new ArrayList<String>();
        goals.add("7");
        goals.add("60");
        goals.add("7000");
        goals.add("7");
        goals.add("7");
        daily.add("3");
        daily.add("0");
        daily.add("0");
        daily.add("2");
        daily.add("0");

        expResult.add(goals);
        expResult.add(daily);

        instance.date = LocalDate.parse("2017-05-03");
        instance.previousWeek = LocalDate.parse("2017-05-03").minusDays(7);
        instance.previousMonth = LocalDate.parse("2017-05-03").minusMonths(1);
        ArrayList<ArrayList> result = instance.getUserDashboard();

        instance.closeDatabase();
        assertEquals(expResult, result);

    }

    /**
     * Test of addPractitioner method, of class DatabaseController.
     */
    @Test
    public void testAddPractitioner() {
        System.out.println("addPractitioner");
        DatabaseController instance = new DatabaseController();

        int practitionerId = 07;
        String password = "jkl";
        String fName = "Bunsen";
        String lName = "Beaker";

        String[] expResult = new String[4];
        expResult[0] = practitionerId + "";
        expResult[1] = password + "";
        expResult[2] = fName + "";
        expResult[3] = lName + "";

        instance.addPractitioner(practitionerId, password, fName, lName);
        String[] result = instance.getUser(07);

        instance.closeDatabase();
        Assert.assertArrayEquals(expResult, result);

    }
// this is bad
    /**
     * Test of addClient method, of class DatabaseController.
     */
    @Test
    public void testAddClient() {
        DatabaseController instance = new DatabaseController();
        System.out.println("addClient");

        String password = "cookies";
        String fName = "Paul";
        String lName = "Dell'Orso";
        int age = 60;
        int pracID = 56;

        String[] expResult = new String[6];
        expResult[0] = 1001 + "";
        expResult[1] = password + "";
        expResult[2] = fName + "";
        expResult[3] = lName + "";
        expResult[4] = age + "";
        expResult[5] = pracID + "";

        instance.setUserId(pracID);

        instance.addClient(password, fName, lName, age);
        String[] result = instance.getUser(1001);
        instance.removeUser(1001);
        instance.closeDatabase();


        Assert.assertArrayEquals(expResult, result);
    }

    /**
     * This test case test the user if client Test of getUser method, of class
     * DatabaseController.
     */
    @Test
    public void testGetUser() {
        System.out.println("getUser");
        int user = 8888;
        DatabaseController instance = new DatabaseController();
        int expResult = 6;
        String[] collection = instance.getUser(user);
        int result = collection.length;
        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /**
     * This test case test the user if practitioner Test of getUser method, of
     * class DatabaseController.
     */
    @Test
    public void testGetUserPrac() {
        System.out.println("getUser");
        int user = 12;
        DatabaseController instance = new DatabaseController();
        int expResult = 4;
        String[] collection = instance.getUser(user);
        int result = collection.length;
        assertEquals(expResult, result);

        instance.closeDatabase();
    }
//

    /**
     * Test of setUserId method, of class DatabaseController.
     */
    @Test
    public void testSetUserId() {
        System.out.println("setUserId");
        int userId = 8888;
        int expResult = userId;
        DatabaseController instance = new DatabaseController();
        instance.setUserId(userId);

        int result = instance.getUserId();

        assertEquals(expResult, result);
        instance.closeDatabase();

    }

    /**
     * Test of getUserId method, of class DatabaseController.
     */
    @Test
    public void testGetUserId() {
        System.out.println("getUserId");
        DatabaseController instance = new DatabaseController();
        int expResult = 8888;
        int userId = 8888;
        instance.setUserId(userId);
        int result = instance.getUserId();

        assertEquals(expResult, result);
        instance.closeDatabase();
    }

    /**
     * Test of getCurrentUser method, of class DatabaseController.
     */
    @Test
    public void testGetCurrentUser() {
        System.out.println("getCurrentUser");
        DatabaseController instance = new DatabaseController();
        int expResult = 6;
        instance.userId = 8888;
        String[] collection = instance.getCurrentUser();
        int result = collection.length;
        assertEquals(expResult, result);
        instance.closeDatabase();
    }

    /**
     * Test of getClients method, of class DatabaseController.
     */
    @Test
    public void testGetClients() {
        System.out.println("getClients");
        DatabaseController instance = new DatabaseController();
        instance.userId = 12;
        int expResult = 4;
        ArrayList collection = instance.getClients();
        int result = collection.size();

        assertEquals(expResult, result);
        instance.closeDatabase();
    }

    /**
     * Test of getPassword method, of class DatabaseController.
     */
    @Test
    public void testGetPassword() {
        System.out.println("getPassword");
        int userID = 8888;
        DatabaseController instance = new DatabaseController();
        String expResult = "qwe123";
        String result = instance.getPassword(userID);
        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /** this is full of bads
     * Test of removeUser method, of class DatabaseController.
     */
    @Test
    public void testRemoveUser() {
        System.out.println("removeUser");
        int userId = 9876;
        DatabaseController instance = new DatabaseController();
        instance.userId = 9876;
        boolean result = false;
        boolean expResult = true;
        instance.removeUser(userId);
        String[] testUsers = instance.getUser(userId);
        if (testUsers == null) {
            //pass
            result = true;
        }

        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /**
     * Test of updatePassword method, of class DatabaseController.
     */
    @Test
    public void testUpdatePassword() {
        System.out.println("updatePassword");
        int userId = 3333;
        String newPassword = "doughnuts";
        DatabaseController instance = new DatabaseController();
        instance.updatePassword(userId, newPassword);
        String result = instance.getPassword(userId);
        String expResult = newPassword;

        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /**
     * Test of getQuery method, of class DatabaseController.
     */
    @Test
    public void testGetQuery() {

        System.out.println("getQuery");
        String query = "strength";
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;
        boolean expResult = true;
        boolean resultSize = false;
        ArrayList<String[]> result = instance.getQuery(query);
        int arrSize = result.size();
        if (arrSize > 1) {
            resultSize = true;
        }
        instance.closeDatabase();

        assertEquals(expResult, resultSize);

    }

    /**
     * Test of addStengthEntry method, of class DatabaseController.
     */
    @Test
    public void testAddStrengthEntry() {
        System.out.println("addStengthEntry");

        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;
        int programId = 3888;
        String exerciseName = "Biceps Curl";
        String entryDate = "2017-05-04";
        double weight = 5.2;
        int reps = 12;

        ArrayList<String[]> strengthEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> strengthEntryAfter = new ArrayList<String[]>();
        ArrayList<String> strengthEntryValues = new ArrayList<String>();

        strengthEntryValues.add(Integer.toString(programId));
        strengthEntryValues.add(exerciseName);
        strengthEntryValues.add(entryDate);
        strengthEntryValues.add(Double.toString(weight));
        strengthEntryValues.add(Integer.toString(reps));

        strengthEntryBefore = instance.getQuery("strength");

        instance.addStengthEntry(strengthEntryValues);

        strengthEntryAfter = instance.getQuery("strength");

        String sqlQuery = "DELETE FROM strengthEntry WHERE entryDate IS '2017-05-04'";
        instance.removeQuery(sqlQuery);
        instance.closeDatabase();
        assertEquals(strengthEntryBefore.size(), strengthEntryAfter.size() - 1);
    }

    /**
     * Test of addAerobicEntry method, of class DatabaseController.
     */
    @Test
    public void testAddAerobicEntry() {
        System.out.println("addAerobicEntry");

        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;
        int programId = 3889;
        String day = "Saturday";
        int week = 1;
        int minutes = 45;
        String entryDate = "2017-05-03";

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();
        ArrayList<String> aerobicEntryValues = new ArrayList<String>();

        aerobicEntryValues.add(Integer.toString(programId));
        aerobicEntryValues.add(day);
        aerobicEntryValues.add(Integer.toString(week));
        aerobicEntryValues.add(Integer.toString(minutes));
        aerobicEntryValues.add(entryDate);

        arrEntryBefore = instance.getQuery("aerobic");
        instance.addAerobicEntry(aerobicEntryValues);
        arrEntryAfter = instance.getQuery("aerobic");

        String sqlQuery = "DELETE FROM aerobicEntry WHERE entryDate IS '2017-05-03'";
        instance.removeQuery(sqlQuery);
        instance.closeDatabase();
        assertEquals(arrEntryBefore.size(), arrEntryAfter.size() - 1);
    }

    /**
     * Test of addPedometerEntry method, of class DatabaseController.
     */
    @Test
    public void testAddPedometerEntry() {
        System.out.println("addPedometerEntry");
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;
        int programId = 3889;
        String day = "Saturday";
        int week = 1;
        int steps = 45;
        String entryDate = "2017-05-03";

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();
        ArrayList<String> pedometerEntryValues = new ArrayList<String>();
        pedometerEntryValues.add(Integer.toString(programId));
        pedometerEntryValues.add(day);
        pedometerEntryValues.add(Integer.toString(week));
        pedometerEntryValues.add(Integer.toString(steps));
        pedometerEntryValues.add(entryDate);

        arrEntryBefore = instance.getQuery("pedometer");
        instance.addPedometerEntry(pedometerEntryValues);
        arrEntryAfter = instance.getQuery("pedometer");

        String sqlQuery = "DELETE FROM pedometerEntry WHERE entryDate IS '2017-05-03'";
        instance.removeQuery(sqlQuery);
        instance.closeDatabase();
        assertEquals(arrEntryBefore.size(), arrEntryAfter.size() - 1);
    }

    /**
     * Test of addBalanceEntry method, of class DatabaseController.
     */
    @Test
    public void testAddBalanceEntry() {
        System.out.println("addBalanceEntry");
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;

        int programId = 3891;
        int leftLegTime = 80;
        int rightLegTime = 80;
        String entryDate = "2017-05-03";

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();
        ArrayList<String> balanceEntryValues = new ArrayList<String>();

        balanceEntryValues.add(Integer.toString(programId));
        balanceEntryValues.add(Integer.toString(leftLegTime));
        balanceEntryValues.add(Integer.toString(rightLegTime));
        balanceEntryValues.add(entryDate);

        arrEntryBefore = instance.getQuery("balance");
        instance.addBalanceEntry(balanceEntryValues);
        arrEntryAfter = instance.getQuery("balance");

        assertEquals(arrEntryBefore.size(), arrEntryAfter.size() - 1);
        String sqlQuery = "DELETE FROM balanceEntry WHERE entryDate IS '2017-05-03'";
        instance.removeQuery(sqlQuery);
        instance.closeDatabase();
    }

    /**
     * Test of addFlexibilityEntry method, of class DatabaseController.
     */
    @Test
    public void testAddFlexibilityEntry() {
        System.out.println("addFlexibilityEntry");
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;

        int programId = 3892;
        String entryDate = "2017-05-03";
        Boolean[] stretches = new Boolean[19];

        for (int i = 0; i < stretches.length; i++) {
            stretches[i] = true;
        }

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();
        ArrayList<String> balanceEntryValues = new ArrayList<String>();
        balanceEntryValues.add(Integer.toString(programId));
        balanceEntryValues.add(entryDate);
        for (int j = 0; j < stretches.length; j++) {
            balanceEntryValues.add(Boolean.toString(stretches[j]));
        }

        arrEntryBefore = instance.getQuery("flexibility");
        instance.addFlexibilityEntry(balanceEntryValues);
        arrEntryAfter = instance.getQuery("flexibility");

        String sqlQuery = "DELETE FROM flexibilityEntry WHERE entryDate IS '2017-05-03'";
        instance.removeQuery(sqlQuery);

        instance.closeDatabase();

        assertEquals(arrEntryBefore.size(), arrEntryAfter.size() - 1);

    }

    /**
     * Test of addCondition method, of class DatabaseController.
     */
    @Test
    public void testAddCondition() {
        System.out.println("addCondition");
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;
        instance.newUserId = 8888;
        int userId = 8888;
        double weight = 142.42;
        int height = 180;
        Boolean[] conditions = new Boolean[10];
        for (int i = 0; i < conditions.length; i++) {
            conditions[i] = true;
        }
        String medicationType = "Gatorade";
        String otherProblem = "Kung Fu Elbow";

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();

        arrEntryBefore = instance.getQuery("condition");

        instance.addCondition(weight, height, conditions, medicationType, otherProblem);

        arrEntryAfter = instance.getQuery("condition");

        assertEquals(arrEntryBefore.size(), arrEntryAfter.size() - 1);
        String sqlQuery = "DELETE FROM condition WHERE medicationType IS 'Gatorade'";

        instance.removeQuery(sqlQuery);
        instance.closeDatabase();


    }

    /**
     * Test of removeQuery method, of class DatabaseController.
     */
    @Test
    public void testRemoveQuery() {
        System.out.println("removeQuery");
        DatabaseController instance = new DatabaseController();

        instance.userId = 8888;
        int programId = 3889;
        String day = "Saturday";
        int week = 1;
        int steps = 45;
        String entryDate = "2017-05-03";

        ArrayList<String[]> arrEntryBefore = new ArrayList<String[]>();
        ArrayList<String[]> arrEntryAfter = new ArrayList<String[]>();
        ArrayList<String> pedometerEntryValues = new ArrayList<String>();
        pedometerEntryValues.add(Integer.toString(programId));
        pedometerEntryValues.add(day);
        pedometerEntryValues.add(Integer.toString(week));
        pedometerEntryValues.add(Integer.toString(steps));
        pedometerEntryValues.add(entryDate);
        //add  it to remove
        arrEntryBefore = instance.getQuery("pedometer");
        instance.addPedometerEntry(pedometerEntryValues);
        //remove querry
        String sqlQuery = "DELETE FROM pedometerEntry WHERE entryDate IS '2017-05-03'";
        instance.removeQuery(sqlQuery);
        //get querry after removed
        arrEntryAfter = instance.getQuery("pedometer");

        instance.closeDatabase();
        assertEquals(arrEntryBefore.size(), arrEntryAfter.size());

    }

    /**
     * Test of findUserGoals method, of class DatabaseController.
     */
    @Test
    public void testFindUserGoals() {
        System.out.println("findUserGoals");
        DatabaseController instance = new DatabaseController();
        instance.userId = 3456;

        int[] expResult = {1, 0, 0, 0, 1};
        int[] result = instance.findUserGoals(3456);

        assertArrayEquals(expResult, result);
        instance.closeDatabase();
    }

    /**
     * Test of getProgramId method, of class DatabaseController.
     */
    @Test
    public void testGetProgramId() {
        System.out.println("getProgramId");
        DatabaseController instance = new DatabaseController();
        instance.userId = 8888;

        String s = "strength";
        int expResult = 3888;
        int result = instance.getProgramId(s,8888);

        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /**
     * Test of getExerciseList method, of class DatabaseController.
     */
    @Test
    public void testGetExerciseList() {
        System.out.println("getExerciseList");
        DatabaseController instance = new DatabaseController();
        ArrayList<String> expResult = new ArrayList<String>();
        expResult.add("Seated Lateral Raise");
        expResult.add("Biceps Curl");
        expResult.add("Shoulder Shrugs");
        expResult.add("One Arm Triceps");
        expResult.add("One Arm Row");
        expResult.add("Chest Press");
        expResult.add("Abdominal Crunch");
        expResult.add("Leg Extension");
        expResult.add("Bulgarian Squat");
        expResult.add("Calf Raise");
        expResult.add("Hamstring Curl");
        expResult.add("Glute Extension");
        expResult.add("Deadlift");
        expResult.add("Squat");
        ArrayList<String> result = instance.getExerciseList();
        assertEquals(expResult, result);

        instance.closeDatabase();
    }




    /**
     * Test of generateId method, of class DatabaseController.
     */
    @Test
    public void testGenerateId() {
        System.out.println("generateId");
        String s = "client";
        DatabaseController instance = new DatabaseController();

        int expResult = 1001;
        int result = instance.generateId(s);
        assertEquals(expResult, result);

        instance.closeDatabase();
    }

    /**
     * Test of setClientId method, of class DatabaseController.
     */
    @Test
    public void testSetClientId() {
        System.out.println("setClientId");
        int id = 8888;
        DatabaseController instance = new DatabaseController();
        instance.userId =8888;
        instance.setClientId(id);

    }

    /**
     * Test of getClientId method, of class DatabaseController.
     */
    @Test
    public void testGetClientId() {
        System.out.println("getClientId");
        DatabaseController instance = new DatabaseController();
        int expResult = 0;
        int result = instance.getClientId();
        assertEquals(expResult, result);

    }
}