Test5.java

package Team5.SmartTowns;

import Team5.SmartTowns.Data.locationRepositoryJDBC;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.autoconfigure.jdbc.JdbcTest;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.test.context.jdbc.Sql;

import static org.junit.jupiter.api.Assertions.assertEquals;

@SpringBootTest
@JdbcTest

@Sql({"schema.sql", "data.sql"})
public class Test5 {

    @Autowired
    private JdbcTemplate ajdbc;


    @Test
//	test 1
    void whenInjectInMemoryDataSource_thenReturnCorrectEmployeeCount() {
        locationRepositoryJDBC employeeDAO = new locationRepositoryJDBC(ajdbc);
//        employeeDAO.setJdbcTemplate(ajdbc);
        assertEquals(4, employeeDAO.getAllLocation().size());

    }



}