org.assistments.service.dao.base.impl

Class JdbcHelper

java.lang.Object

org.assistments.service.dao.base.impl.JdbcHelper

public class JdbcHelper
extends java.lang.Object

Constructor Summary

Constructors

Constructor and Description
JdbcHelper()

Method Summary

Modifier and Type	Method and Description
static void	confirmExactRowsDeleted(java.lang.String table, int expectedNumDeleted, int actualNumDeleted)
static void	confirmExactRowsProcessed(java.lang.String table, int expectedProcessed, int actualProcessed)
static boolean	confirmMaxRowsDeleted(java.lang.String table, int expectedMaxDeleted, int actualNumDeleted) Reports whether the actual number of rows deleted did not exceed the expected number of rows to delete.
static void	confirmMaxRowsProcessed(java.lang.String table, int expectedMaxProcessed, int actualProcessed)
static void	confirmMinimumRowsDeleted(java.lang.String table, int expectedMinDeleted, int actualNumDeleted)
static java.sql.Timestamp	getSqlTime(java.time.Instant instantTime)
static java.sql.Timestamp	getSqlTimeFromNow(int amountToAdd, java.time.temporal.TemporalUnit unit)
static java.sql.Timestamp	getSqlTimeNow()
static java.lang.String	getTemplateColumnNames(java.lang.String[] names) Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource
static java.lang.String	getTemplateString(java.lang.String tableName, java.lang.String[] columnNames) Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource
static java.lang.String	getTemplateValuesStr(int columnCount) Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource
static java.time.LocalDate	toLocalDate(java.sql.Date sqlDate)
static java.sql.Date	toSqlDate(java.time.LocalDate localDate)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcHelper

public JdbcHelper()

Method Detail

getSqlTime

public static java.sql.Timestamp getSqlTime(java.time.Instant instantTime)

getSqlTimeNow

public static java.sql.Timestamp getSqlTimeNow()

toLocalDate

public static java.time.LocalDate toLocalDate(java.sql.Date sqlDate)

toSqlDate

public static java.sql.Date toSqlDate(java.time.LocalDate localDate)

getSqlTimeFromNow

public static java.sql.Timestamp getSqlTimeFromNow(int amountToAdd,
                                                   java.time.temporal.TemporalUnit unit)

getTemplateString

@Deprecated
public static java.lang.String getTemplateString(java.lang.String tableName,
                                                              java.lang.String[] columnNames)

Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource

getTemplateColumnNames

@Deprecated
public static java.lang.String getTemplateColumnNames(java.lang.String[] names)

Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource

getTemplateValuesStr

@Deprecated
public static java.lang.String getTemplateValuesStr(int columnCount)

Deprecated. Confirm not used. Replace w/code using MapSqlParameterSource

confirmMaxRowsDeleted

public static boolean confirmMaxRowsDeleted(java.lang.String table,
                                            int expectedMaxDeleted,
                                            int actualNumDeleted)
                                     throws java.lang.IllegalStateException

Reports whether the actual number of rows deleted did not exceed the expected number of rows to delete.

Parameters:

expectedMaxDeleted - Maximum number of rows expected to delete.

actualNumDeleted - Actual number of rows deleted.

Returns:

Throws:

java.lang.IllegalStateException - when more than expectedMaxDeleted rows were deleted.

confirmMinimumRowsDeleted

public static void confirmMinimumRowsDeleted(java.lang.String table,
                                             int expectedMinDeleted,
                                             int actualNumDeleted)
                                      throws java.lang.IllegalStateException

Throws:

java.lang.IllegalStateException

confirmExactRowsDeleted

public static void confirmExactRowsDeleted(java.lang.String table,
                                           int expectedNumDeleted,
                                           int actualNumDeleted)
                                    throws java.lang.IllegalStateException

Throws:

java.lang.IllegalStateException

confirmExactRowsProcessed

public static void confirmExactRowsProcessed(java.lang.String table,
                                             int expectedProcessed,
                                             int actualProcessed)
                                      throws java.lang.IllegalStateException,
                                             NotFoundException

Throws:

java.lang.IllegalStateException

NotFoundException

confirmMaxRowsProcessed

public static void confirmMaxRowsProcessed(java.lang.String table,
                                           int expectedMaxProcessed,
                                           int actualProcessed)
                                    throws java.lang.IllegalStateException

Throws:

java.lang.IllegalStateException