Package lu.kbra.pclib.db.utils.impl

Interface DataBaseEntryUtils

All Superinterfaces:

DataBaseEntryUtilsOptionsOwner

All Known Subinterfaces:

ProxyDataBaseEntryUtils

All Known Implementing Classes:

BaseDataBaseEntryUtils, BaseProxyDataBaseEntryUtils, MySQLDataBaseEntryUtils, PostgreSQLDataBaseEntryUtils, SpringDataBaseEntryUtils, SQLiteDataBaseEntryUtils

public interface DataBaseEntryUtils
extends DataBaseEntryUtilsOptionsOwner

Field Summary

Fields

Modifier and Type	Field	Description
static final String	FUNCTION_KEY
static final String	MEMBER_KEY
static final String	QUALIFIER_KEY
static final String	TABLE_NAME_KEY

Fields inherited from interface lu.kbra.pclib.db.utils.impl.DataBaseEntryUtilsOptionsOwner

FAIL_ON_DUPLICATE_FACTORY_METHOD, FAIL_ON_DUPLICATE_FACTORY_METHOD_PROPERTY, FORCE_DEFAULT_VALUE_ON_NON_NULL, FORCE_DEFAULT_VALUE_ON_NON_NULL_PROPERTY, WARN_ON_DUPLICATE_FACTORY_METHOD, WARN_ON_DUPLICATE_FACTORY_METHOD_PROPERTY

Method Summary

Modifier and Type	Method	Description
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	computeDefaultValue(Class<B> tableClazz, Field field)
Stream<ColumnTypeFactory>	computeType(Class<?> rawType, Map<String,Object> hints)
String	fieldToColumnName(Field field)
String	fieldToColumnName(String name)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	fillInsert(B table, T data, ResultSet rs)	Only reload generated keys
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	fillLoad(B table, T data, ResultSet rs)	Full reload
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	fillLoadAll(B table, Class<T> entryClazz, ResultSet result, Consumer<T> listExporter)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	fillUpdate(B table, T data, ResultSet rs)
String	getDbmsQualifierName()
<T extends DataBaseEntry> Class<T>	getEntryType(Class<? extends SQLQueryable<?>> tableClass)
<T extends DataBaseEntry> Field	getFieldFor(Class<T> entryClazz, String sqlName)
SQLFunctionResolver	getFunctionResolver()
<B extends SQLQueryable<T>, T extends DataBaseEntry> ColumnData[]	getGeneratedKeys(Class<T> entryClazz, Class<B> tableClazz)
<T extends DataBaseEntry> Method	getInsertMethod(Class<T> data)
<T extends DataBaseEntry> Method	getLoadMethod(Class<T> data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String[]	getNonNullKeys(B instance, T data)	returns the names of the columns that aren't null. ignored primary keys, generated and OnUpdate columns.
<B extends SQLQueryable<T>, T extends DataBaseEntry> Map<String,Object>	getNonNullValues(B instance, T data)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> String	getPreparedDeleteSQL(B table, T data)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> String	getPreparedInsertSQL(B table, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getPreparedSelectCountNotNullSQL(B instance, String[] notNullKeys, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getPreparedSelectCountUniqueSQL(B instance, String[][] uniqueKeys, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getPreparedSelectSQL(B table, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	getPreparedSelectUniqueSQL(B instance, String[][] uniqueKeys, T data)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> String	getPreparedUpdateSQL(B table, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> ColumnData[]	getPrimaryKeys(Class<T> entryClazz, Class<B> tableClazz)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String[]	getPrimaryKeysNames(Class<T> entryClazz, Class<B> tableClazz)
Map<String,Object>	getQueryableHints(Class<?> tableClazz)
<V extends SQLQueryable<T>, T extends DataBaseEntry> String	getQueryableName(Class<V> tableClass)
String	getReferencedColumnName(ForeignKey fk)
SQLStructureVisitor	getStructureVisitor()
ColumnType	getTypeFor(Class<?> clazz, Optional<AnnotatedType> type, Map<String,Object> typeHints)
ColumnType	getTypeFor(AnnotatedType type)
ColumnType	getTypeFor(AnnotatedType annotatedType, Map<String,Object> typeHints)
ColumnType	getTypeFor(Field field)
default ColumnType	getTypeFor(Parameter param)
Map<String,Object>	getTypeHints(AnnotatedType type)
<T extends DataBaseEntry> String[][]	getUniqueKeys(ConstraintData[] allConstraints, T data)
<T extends DataBaseEntry> Map<String,Object>[]	getUniqueValues(ConstraintData[] allConstraints, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String[]	getUpdateColumnsNames(Class<T> entryClazz, Class<B> tableClazz)
<T extends DataBaseEntry> Method	getUpdateMethod(Class<T> data)
<T extends DataBaseEntry> Method	getUpdateMethod(T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> T	instance(Class<T> entryClazz, Class<B> tableClazz)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> void	prepareDeleteSQL(PreparedStatement stmt, B instance, T data)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> void	prepareInsertSQL(PreparedStatement stmt, B instance, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	prepareSelectCountNotNullSQL(PreparedStatement stmt, B instance, String[] notNullKeys, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	prepareSelectCountUniqueSQL(PreparedStatement stmt, B instance, String[][] uniqueKeys, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	prepareSelectSQL(PreparedStatement stmt, B instance, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> void	prepareSelectUniqueSQL(PreparedStatement stmt, B instance, String[][] uniqueKeys, T data)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> void	prepareUpdateSQL(PreparedStatement stmt, B instance, T data)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	qualifiedName(Class<B> typeName)
<B extends SQLQueryable<T>, T extends DataBaseEntry> String	replaceSQLQualifiers(Class<B> tableClazz, String input)
DataBaseStructure	scanDataBase(DataBase dataBase, Map<String,Object> baseHints)
<B extends AbstractDBTable<T>, T extends DataBaseEntry> TableStructure	scanEntry(Class<B> tableClazz, Class<T> entryClazz)
<T extends DataBaseEntry> TableStructure	scanTable(Class<? extends AbstractDBTable<T>> data)

Methods inherited from interface lu.kbra.pclib.db.utils.impl.DataBaseEntryUtilsOptionsOwner

getOption, getOptionOrDefault, getOptionOrDefault, getOptions, hasOption, isFailOnDuplicateFactoryMethod, isForceDefaultValueOnNonNull, isWarnOnDuplicateFactoryMethod, setOption

Field Details

TABLE_NAME_KEY

static final String TABLE_NAME_KEY

See Also:

• Constant Field Values

QUALIFIER_KEY

static final String QUALIFIER_KEY

See Also:

• Constant Field Values

FUNCTION_KEY

static final String FUNCTION_KEY

See Also:

• Constant Field Values

MEMBER_KEY

static final String MEMBER_KEY

See Also:

• Constant Field Values

Method Details

computeType

Stream<ColumnTypeFactory> computeType(Class<?> rawType,
 Map<String,Object> hints)

fieldToColumnName

String fieldToColumnName(Field field)

fieldToColumnName

String fieldToColumnName(String name)

fillInsert

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void fillInsert(B table,
 T data,
 ResultSet rs)
         throws SQLException

Only reload generated keys

Throws:

SQLException

fillLoad

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void fillLoad(B table,
 T data,
 ResultSet rs)
       throws SQLException

Full reload

Throws:

SQLException

fillLoadAll

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void fillLoadAll(B table,
 Class<T> entryClazz,
 ResultSet result,
 Consumer<T> listExporter)
          throws SQLException

Throws:

SQLException

fillUpdate

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void fillUpdate(B table,
 T data,
 ResultSet rs)
         throws SQLException

Throws:

SQLException

getDbmsQualifierName

String getDbmsQualifierName()

getEntryType

<T extends DataBaseEntry> Class<T> getEntryType(Class<? extends SQLQueryable<?>> tableClass)

getFieldFor

<T extends DataBaseEntry> Field getFieldFor(Class<T> entryClazz,
 String sqlName)

getFunctionResolver

SQLFunctionResolver getFunctionResolver()

getGeneratedKeys

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
ColumnData[] getGeneratedKeys(Class<T> entryClazz,
 Class<B> tableClazz)

getInsertMethod

<T extends DataBaseEntry> Method getInsertMethod(Class<T> data)

getLoadMethod

<T extends DataBaseEntry> Method getLoadMethod(Class<T> data)

getNonNullKeys

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String[] getNonNullKeys(B instance,
 T data)

returns the names of the columns that aren't null. ignored primary keys, generated and OnUpdate columns.

getNonNullValues

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
Map<String,Object> getNonNullValues(B instance,
 T data)

getPreparedDeleteSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
String getPreparedDeleteSQL(B table,
 T data)

getPreparedInsertSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
String getPreparedInsertSQL(B table,
 T data)

getPreparedSelectCountNotNullSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String getPreparedSelectCountNotNullSQL(B instance,
 String[] notNullKeys,
 T data)

getPreparedSelectCountUniqueSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String getPreparedSelectCountUniqueSQL(B instance,
 String[][] uniqueKeys,
 T data)

getPreparedSelectSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String getPreparedSelectSQL(B table,
 T data)

getPreparedSelectUniqueSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String getPreparedSelectUniqueSQL(B instance,
 String[][] uniqueKeys,
 T data)

getPreparedUpdateSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
String getPreparedUpdateSQL(B table,
 T data)

getPrimaryKeys

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
ColumnData[] getPrimaryKeys(Class<T> entryClazz,
 Class<B> tableClazz)

getPrimaryKeysNames

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String[] getPrimaryKeysNames(Class<T> entryClazz,
 Class<B> tableClazz)

getQueryableHints

Map<String,Object> getQueryableHints(Class<?> tableClazz)

getQueryableName

<V extends SQLQueryable<T>,
T extends DataBaseEntry>
String getQueryableName(Class<V> tableClass)

getReferencedColumnName

String getReferencedColumnName(ForeignKey fk)

getStructureVisitor

SQLStructureVisitor getStructureVisitor()

getTypeFor

ColumnType getTypeFor(AnnotatedType type)

getTypeFor

ColumnType getTypeFor(AnnotatedType annotatedType,
 Map<String,Object> typeHints)

getTypeFor

ColumnType getTypeFor(Class<?> clazz,
 Optional<AnnotatedType> type,
 Map<String,Object> typeHints)

getTypeFor

ColumnType getTypeFor(Field field)

getTypeFor

default ColumnType getTypeFor(Parameter param)

getTypeHints

Map<String,Object> getTypeHints(AnnotatedType type)

getUniqueKeys

<T extends DataBaseEntry> String[][] getUniqueKeys(ConstraintData[] allConstraints,
 T data)

getUniqueValues

<T extends DataBaseEntry> Map<String,Object>[] getUniqueValues(ConstraintData[] allConstraints,
 T data)

getUpdateColumnsNames

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String[] getUpdateColumnsNames(Class<T> entryClazz,
 Class<B> tableClazz)

getUpdateMethod

<T extends DataBaseEntry> Method getUpdateMethod(Class<T> data)

getUpdateMethod

<T extends DataBaseEntry> Method getUpdateMethod(T data)

instance

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
T instance(Class<T> entryClazz,
 Class<B> tableClazz)

prepareDeleteSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
void prepareDeleteSQL(PreparedStatement stmt,
 B instance,
 T data)
               throws SQLException

Throws:

SQLException

prepareInsertSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
void prepareInsertSQL(PreparedStatement stmt,
 B instance,
 T data)
               throws SQLException

Throws:

SQLException

prepareSelectCountNotNullSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void prepareSelectCountNotNullSQL(PreparedStatement stmt,
 B instance,
 String[] notNullKeys,
 T data)
                           throws SQLException

Throws:

SQLException

prepareSelectCountUniqueSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void prepareSelectCountUniqueSQL(PreparedStatement stmt,
 B instance,
 String[][] uniqueKeys,
 T data)
                          throws SQLException

Throws:

SQLException

prepareSelectSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void prepareSelectSQL(PreparedStatement stmt,
 B instance,
 T data)
               throws SQLException

Throws:

SQLException

prepareSelectUniqueSQL

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
void prepareSelectUniqueSQL(PreparedStatement stmt,
 B instance,
 String[][] uniqueKeys,
 T data)
                     throws SQLException

Throws:

SQLException

prepareUpdateSQL

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
void prepareUpdateSQL(PreparedStatement stmt,
 B instance,
 T data)
               throws SQLException

Throws:

SQLException

qualifiedName

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String qualifiedName(Class<B> typeName)

replaceSQLQualifiers

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String replaceSQLQualifiers(Class<B> tableClazz,
 String input)

scanDataBase

DataBaseStructure scanDataBase(DataBase dataBase,
 Map<String,Object> baseHints)

scanEntry

<B extends AbstractDBTable<T>,
T extends DataBaseEntry>
TableStructure scanEntry(Class<B> tableClazz,
 Class<T> entryClazz)

scanTable

<T extends DataBaseEntry> TableStructure scanTable(Class<? extends AbstractDBTable<T>> data)

computeDefaultValue

<B extends SQLQueryable<T>,
T extends DataBaseEntry>
String computeDefaultValue(Class<B> tableClazz,
 Field field)