@@ -0,0 +1,1160 @@
+package google.dao;%0A%0Aimport static org.junit.Assert.assertEquals;%0A%0Aimport java.time.LocalDate;%0Aimport java.time.Month;%0A%0Aimport org.junit.Test;%0A%0Aimport google.model.Result;%0A%0Apublic class SqlHelperTest %7B%0A%0A%09@Test%0A%09public void testInsert() %7B%0A%09%09Result result = new Result(%22Asterix i Obelix%22);%0A%09%09result.setNumberOfResults(2_000);%0A%09%09result.setDate(LocalDate.of(2017, Month.APRIL, 15));%0A%09%09String expectedSql = %22INSERT INTO RESULTS (GOOGLE_QUERY, NUMBER_OF_RESULTS, DATE_OF_SEARCH)%22%0A%09%09%09%09+ %22 VALUES ('Asterix i Obelix', 2000, '2017-04-15')%22;%0A%09%09assertEquals(expectedSql, SqlHelper.getSqlForInsert(result));%0A%09%7D%0A%0A%09@Test%0A%09public void testSelectAll() %7B%0A%09%09assertEquals(%22SELECT * FROM RESULTS%22, SqlHelper.getSqlForSelectAll());%0A%09%7D%0A%0A%09@Test%0A%09public void testSingleSelect() %7B%0A%09%09assertEquals(%22SELECT * FROM RESULTS WHERE GOOGLE_QUERY = 'Papa Smerf'%22,%0A%09%09%09%09SqlHelper.getSqlForSingleSelect(%22Papa Smerf%22));%0A%09%7D%0A%0A%09@Test%0A%09public void testDeleteAll() %7B%0A%09%09assertEquals(%22DELETE FROM RESULTS%22, SqlHelper.getSqlForDeleteAll());%0A%09%7D%0A%0A%09@Test%0A%09public void testDelete() %7B%0A%09%09assertEquals(%22DELETE FROM RESULTS WHERE GOOGLE_QUERY = 'Myszka Miki'%22,%0A%09%09%09%09SqlHelper.getSqlForDelete(%22Myszka Miki%22));%0A%09%7D%0A%0A%7D%0A

Add JUnit tests for SqlHelper.