public static junit.framework.Test suite() throws Exception { junit.framework.TestSuite suite = new junit.framework.TestSuite(AllUnitTests.class.getName()); suite.addTest(TestFieldSearchSQLImpl.suite()); return suite; } }
@Test public void noDC() throws ServerException, SQLException { updateRecord(OBJECT_WITH_NO_DC, false); verify(mockConnection,times(0)).prepareStatement("DELETE FROM dcDates WHERE pid=?"); verify(mockConnection, times(0)).prepareStatement("INSERT INTO dcDates (pid, dcDate) values (?, ?)"); verifyStatic(times(1)); SQLUtility.replaceInto( any(Connection.class), eq("doFields"), aryEq(SHORT_FIELDS), aryEq(OBJECT_WITH_NO_DC.getShortFieldValueList().toArray(new String[]{})), eq("pid"), any(boolean[].class)); }
@Test public void dcDatesLongFields() throws ServerException, SQLException { updateRecord(OBJECT_WITH_DC_AND_DATES, true); verify(mockConnection,times(1)).prepareStatement("DELETE FROM dcDates WHERE pid=?"); verify(mockConnection, times(1)).prepareStatement("INSERT INTO dcDates (pid, dcDate) values (?, ?)"); verifyStatic(times(1)); SQLUtility.replaceInto( any(Connection.class), eq("doFields"), aryEq(LONG_FIELDS), aryEq(OBJECT_WITH_DC_AND_DATES.getLongFieldValueList().toArray(new String[]{})), eq("pid"), any(boolean[].class)); }
@Test public void dcNoDatesLongFields() throws ServerException, SQLException { updateRecord(OBJECT_WITH_DC, true); verify(mockConnection,times(1)).prepareStatement("DELETE FROM dcDates WHERE pid=?"); verify(mockConnection, times(0)).prepareStatement("INSERT INTO dcDates (pid, dcDate) values (?, ?)"); verifyStatic(times(1)); SQLUtility.replaceInto( any(Connection.class), eq("doFields"), aryEq(LONG_FIELDS), aryEq(OBJECT_WITH_DC.getLongFieldValueList().toArray(new String[]{})), eq("pid"), any(boolean[].class)); }
@Test public void dcDatesShortFields() throws ServerException, SQLException { updateRecord(OBJECT_WITH_DC_AND_DATES, false); verify(mockConnection,times(0)).prepareStatement("DELETE FROM dcDates WHERE pid=?"); verify(mockConnection, times(0)).prepareStatement("INSERT INTO dcDates (pid, dcDate) values (?, ?)"); verifyStatic(times(1)); SQLUtility.replaceInto( any(Connection.class), eq("doFields"), aryEq(SHORT_FIELDS), aryEq(OBJECT_WITH_DC.getShortFieldValueList().toArray(new String[]{})), eq("pid"), any(boolean[].class)); }
@Test public void dcNoDatesShortFields() throws ServerException, SQLException { updateRecord(OBJECT_WITH_DC, false); verify(mockConnection,times(0)).prepareStatement("DELETE FROM dcDates WHERE pid=?"); verify(mockConnection, times(0)).prepareStatement("INSERT INTO dcDates (pid, dcDate) values (?, ?)"); verifyStatic(times(1)); SQLUtility.replaceInto( any(Connection.class), eq("doFields"), aryEq(SHORT_FIELDS), aryEq(OBJECT_WITH_DC.getShortFieldValueList().toArray(new String[]{})), eq("pid"), any(boolean[].class)); }