Package edu.suffolk.litlab.efsp.ecfcodes

Class CodeDatabaseUtils

java.lang.Object

edu.suffolk.litlab.efsp.ecfcodes.CodeDatabaseUtils

public class CodeDatabaseUtils
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final record	CodeDatabaseUtils.Column
static final record	CodeDatabaseUtils.TableColumns
static class	CodeDatabaseUtils.UnsupportedTableException	This exception is returned when a given table name isn't in the pre-approved list of names.

Constructor Summary

Constructors

Constructor	Description
CodeDatabaseUtils()

Method Summary

Modifier and Type	Method	Description
static String	createInsertQuery(String tableName, CodeDatabaseUtils.TableColumns tc)	Returns an INSERT statement for the given table + court.
static String	createTableQuery(String tableName, CodeDatabaseUtils.TableColumns tc)
static String	getIndicesExist()
static String	getTableExists()
static String	likeWildcard(String searchTerm)	In most cases, we want to find all instances of the search term, not the exact term.
static PreparedStatement	singleInsert(PreparedStatement stmt, CodeDatabaseUtils.TableColumns columns, Map<String,String> rowVals, String courtName, String jurisStr)

Methods inherited from class java.lang.Object

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

Constructor Details

CodeDatabaseUtils

public CodeDatabaseUtils()

Method Details

getTableExists

public static String getTableExists()

getIndicesExist

public static String getIndicesExist()

likeWildcard

public static String likeWildcard(String searchTerm)

In most cases, we want to find all instances of the search term, not the exact term. It's a LIKE compare, so add the 0 or more characters on either side.

Parameters:

searchTerm -

Returns:

createInsertQuery

public static String createInsertQuery(String tableName,
 CodeDatabaseUtils.TableColumns tc)

Returns an INSERT statement for the given table + court. The statement includes a ON CONFLICT (all columns...) DO NOTHING clause.

Parameters:

tableName - The name of the DB table (i.e. code list) to insert into

courtName - The Court Location ID to add codes for

createTableQuery

public static String createTableQuery(String tableName,
 CodeDatabaseUtils.TableColumns tc)

singleInsert

public static PreparedStatement singleInsert(PreparedStatement stmt,
 CodeDatabaseUtils.TableColumns columns,
 Map<String,String> rowVals,
 String courtName,
 String jurisStr)
                                      throws SQLException

Throws:

SQLException