package com.happybeavers.core.database.test;

import com.happybeavers.common.util.CommonTestCase;
import com.happybeavers.common.util.BeaverContext;
import com.happybeavers.core.database.MeadowSQLImpl;

import java.sql.Connection;

public class MeadowSQLImplTest extends CommonTestCase {

    //Beaver Context instance declaration
    private BeaverContext bc = null;
    //Database Connection instance declaration
    private Connection conn = null;
    //MeadowSQLImpl object declared
    private MeadowSQLImpl impl = null;
    //Select Query
    private String selectQuery = null;
    //Update Query
    private String updateQuery = null;
    //Meadow Id
    private int meadow_id = 2067;


    protected void setUp() throws Exception {
        super.setUp();
        // MeadowSQLImpl Object created.
        impl = new MeadowSQLImpl();
        //Beaver Context Created from Base class.
        bc= createBeaverContext();
        //Connection Object created to access Database.
        conn = getConnection(bc);
        //select query formed. MEADOW _ID 2067 NEED TO CHANGE IT IF IT DOES NOT EXIST IN DATABASE.
        selectQuery = "SELECT LOCATION FROM MEADOWS WHERE MEADOW_ID=" + meadow_id;
        //Update Query formed .MEADOW_ID 2067 NEED TO CHANGE IT IF IT DOES NOT EXIST IN DATABASE.
        updateQuery = "";
    }

    protected void tearDown() throws Exception {
        silentClose(conn, null, null);
        super.tearDown();
    }

    //This method tests the insertion of data into database using MeadowSQLImpl Class.
    public void testSelect() throws Exception {
        String _location = getStringFromQuery(selectQuery, conn, bc);
        assertNotNull(_location);
    }

    //This method tests the insertion of data into database using MeadowSQLImpl Class.
    public void testUpdate() throws Exception {

    }
}