Package lu.kbra.pclib.db.table

Interface AbstractDBTable<T extends DatabaseEntry>

All Superinterfaces:

SQLQueryable<T>

All Known Implementing Classes:

DatabaseTable, DBTableProxy, DeferredDatabaseTable, MigrationColumnTable, MigrationConstraintTable, MigrationHistoryPhaseTable, MigrationHistoryTable, MigrationTable, MigrationTableTable

public interface AbstractDBTable<T extends DatabaseEntry>
extends SQLQueryable<T>

Method Summary

Modifier and Type	Method	Description
int	clear()
int	countNotNull(T data)
int	countUniques(T data)
boolean	create()
T	delete(T data)
<C extends Collection<T>> C	deleteAll(C datas)
<C extends Collection<T>, D extends Collection<T>> D	deleteAllIfExists(C datas, Supplier<D> supplier)
Optional<T>	deleteIfExists(T data)
Optional<T>	deleteUnique(T data)
List<T>	deleteUniques(T data)
AbstractDBTable<T>	drop()
boolean	exists()
boolean	exists(T data)
boolean	existsUnique(T data)
boolean	existsUniques(T data)
<C extends Collection<T>, D extends Collection<T>> D	filterExists(C datas, Supplier<D> supplier)
<C extends Collection<T>, D extends Collection<T>> D	filterExistsByUnique(C datas, Supplier<D> supplier)
<C extends Collection<T>, D extends Collection<T>> D	filterExistsUnique(C datas, Supplier<D> supplier)
String[]	getCreateSQL()
Map<String,Object>	getCustomHints()
Database	getDatabase()
SQLQueryableHookManager	getQueryableHookManager()
TableStructure	getStructure()
default String	getTableId()
T	insert(T data)
<C extends Collection<T>> C	insertAll(C datas)
T	insertAndReload(T data)
<C extends Collection<T>> C	insertAndReloadAll(C datas)
T	load(T data)
<C extends Collection<T>> C	loadAll(C datas)
<C extends Collection<T>, D extends Collection<T>> D	loadAllByUnique(C datas, Supplier<D> supplier)
<C extends Collection<T>, D extends Collection<T>> D	loadAllIfExists(C datas, Supplier<D> supplier)
<C extends Collection<T>> C	loadAllUnique(C datas)
List<T>	loadByUnique(T data)	Returns a list of all the possible entries matching with the unique values of the input.
Optional<T>	loadIfExists(T data)
T	loadIfExistsElseInsert(T data)	Loads the first pk result, returns a the newly inserted instance if none is found
T	loadUnique(T data)	Loads the only unique result, or throws an exception if none is found.
Optional<T>	loadUniqueIfExists(T data)	Loads the only unique result, returns null if none is found and throws an exception if too many are available.
T	loadUniqueIfExistsElseInsert(T data)	Loads the first unique result, returns a the newly inserted instance if none is found and throws an exception if too many are available.
T	loadUniqueIfExistsElseInsertAndReload(T data)	Loads the first unique result, returns null if none is found and throws an exception if too many are available.
void	setQueryableHookManager(SQLQueryableHookManager queryableHookManager)
void	setTableStructure(TableStructure tableStructure)
int	truncate()
T	update(T data)
<C extends Collection<T>> C	updateAll(C datas)
T	updateAndReload(T data)
<C extends Collection<T>> C	updateAndReloadAll(C datas)
Optional<T>	updateAndReloadIfExists(T data)
T	updateAndReloadIfExistsElseInsert(T data)
T	updateAndReloadIfExistsElseInsertAndReload(T data)
Optional<T>	updateIfExists(T data)
T	updateIfExistsElseInsert(T data)
T	updateIfExistsElseInsertAndReload(T data)

Methods inherited from interface lu.kbra.pclib.db.impl.SQLQueryable

count, getConnector, getDatabaseEntryUtils, getEntryClass, getName, getQualifiedName, getStatementAsSQL, getTargetClass, query

Method Details

clear

int clear()
   throws DBException

Throws:

DBException

countNotNull

int countNotNull(T data)
          throws DBException

Throws:

DBException

countUniques

int countUniques(T data)
          throws DBException

Throws:

DBException

create

boolean create()
        throws DBException

Specified by:

create in interface SQLQueryable<T extends DatabaseEntry>

Returns:

true if it was created

Throws:

DBException

delete

T delete(T data)
  throws DBException

Throws:

DBException

deleteIfExists

Optional<T> deleteIfExists(T data)
                    throws DBException

Throws:

DBException

deleteUnique

Optional<T> deleteUnique(T data)
                  throws DBException

Throws:

DBException

deleteUniques

List<T> deleteUniques(T data)
               throws DBException

Throws:

DBException

drop

AbstractDBTable<T> drop()
                 throws DBException

Throws:

DBException

exists

boolean exists()
        throws DBException

Specified by:

exists in interface SQLQueryable<T extends DatabaseEntry>

Throws:

DBException

exists

boolean exists(T data)
        throws DBException

Throws:

DBException

existsUnique

boolean existsUnique(T data)
              throws DBException

Throws:

DBException

existsUniques

boolean existsUniques(T data)
               throws DBException

Throws:

DBException

getCreateSQL

String[] getCreateSQL()

getCustomHints

Map<String,Object> getCustomHints()

Specified by:

getCustomHints in interface SQLQueryable<T extends DatabaseEntry>

getDatabase

Database getDatabase()

Specified by:

getDatabase in interface SQLQueryable<T extends DatabaseEntry>

getStructure

TableStructure getStructure()

Specified by:

getStructure in interface SQLQueryable<T extends DatabaseEntry>

setTableStructure

void setTableStructure(TableStructure tableStructure)

getQueryableHookManager

SQLQueryableHookManager getQueryableHookManager()

Specified by:

getQueryableHookManager in interface SQLQueryable<T extends DatabaseEntry>

setQueryableHookManager

void setQueryableHookManager(SQLQueryableHookManager queryableHookManager)

insert

T insert(T data)
  throws DBException

Throws:

DBException

insertAndReload

T insertAndReload(T data)
           throws DBException

Throws:

DBException

load

T load(T data)
throws DBException

Throws:

DBException

loadByUnique

List<T> loadByUnique(T data)
              throws DBException

Returns a list of all the possible entries matching with the unique values of the input.

Throws:

DBException

loadUnique

T loadUnique(T data)
      throws DBException

Loads the only unique result, or throws an exception if none is found.

Throws:

DBException

loadUniqueIfExists

Optional<T> loadUniqueIfExists(T data)
                        throws DBException

Loads the only unique result, returns null if none is found and throws an exception if too many are available.

Throws:

DBException

loadIfExists

Optional<T> loadIfExists(T data)
                  throws DBException

Throws:

DBException

loadUniqueIfExistsElseInsert

T loadUniqueIfExistsElseInsert(T data)
                        throws DBException

Loads the first unique result, returns a the newly inserted instance if none is found and throws an exception if too many are available.

Throws:

DBException

loadUniqueIfExistsElseInsertAndReload

T loadUniqueIfExistsElseInsertAndReload(T data)
                                 throws DBException

Loads the first unique result, returns null if none is found and throws an exception if too many are available.

Throws:

DBException

truncate

int truncate()
      throws DBException

Throws:

DBException

update

T update(T data)
  throws DBException

Throws:

DBException

updateAndReload

T updateAndReload(T data)
           throws DBException

Throws:

DBException

updateAndReloadIfExists

Optional<T> updateAndReloadIfExists(T data)

updateAndReloadIfExistsElseInsert

T updateAndReloadIfExistsElseInsert(T data)

updateAndReloadIfExistsElseInsertAndReload

T updateAndReloadIfExistsElseInsertAndReload(T data)

updateIfExists

Optional<T> updateIfExists(T data)

updateIfExistsElseInsert

T updateIfExistsElseInsert(T data)

updateIfExistsElseInsertAndReload

T updateIfExistsElseInsertAndReload(T data)

insertAll

<C extends Collection<T>> C insertAll(C datas)
                               throws DBException

Throws:

DBException

insertAndReloadAll

<C extends Collection<T>> C insertAndReloadAll(C datas)
                                        throws DBException

Throws:

DBException

deleteAll

<C extends Collection<T>> C deleteAll(C datas)
                               throws DBException

Throws:

DBException

updateAll

<C extends Collection<T>> C updateAll(C datas)
                               throws DBException

Throws:

DBException

updateAndReloadAll

<C extends Collection<T>> C updateAndReloadAll(C datas)
                                        throws DBException

Throws:

DBException

loadAll

<C extends Collection<T>> C loadAll(C datas)
                             throws DBException

Throws:

DBException

loadAllUnique

<C extends Collection<T>> C loadAllUnique(C datas)
                                   throws DBException

Throws:

DBException

loadAllByUnique

<C extends Collection<T>,
D extends Collection<T>> D loadAllByUnique(C datas,
 Supplier<D> supplier)
                                                             throws DBException

Throws:

DBException

loadAllIfExists

<C extends Collection<T>,
D extends Collection<T>> D loadAllIfExists(C datas,
 Supplier<D> supplier)
                                                             throws DBException

Throws:

DBException

deleteAllIfExists

<C extends Collection<T>,
D extends Collection<T>> D deleteAllIfExists(C datas,
 Supplier<D> supplier)
                                                               throws DBException

Throws:

DBException

filterExists

<C extends Collection<T>,
D extends Collection<T>> D filterExists(C datas,
 Supplier<D> supplier)
                                                          throws DBException

Throws:

DBException

filterExistsUnique

<C extends Collection<T>,
D extends Collection<T>> D filterExistsUnique(C datas,
 Supplier<D> supplier)
                                                                throws DBException

Throws:

TooManyMatchingRowsException - if a row matches > 0 unique rows

DBException

filterExistsByUnique

<C extends Collection<T>,
D extends Collection<T>> D filterExistsByUnique(C datas,
 Supplier<D> supplier)
                                                                  throws DBException

Throws:

DBException

loadIfExistsElseInsert

T loadIfExistsElseInsert(T data)
                  throws DBException

Loads the first pk result, returns a the newly inserted instance if none is found

Throws:

DBException

getTableId

default String getTableId()