Package lu.kbra.pclib.db.table

Class DBTableProxy<V extends DataBaseTable<X>,X extends DataBaseEntry>

java.lang.Object

lu.kbra.pclib.db.table.DataBaseTable<X>

lu.kbra.pclib.db.table.DBTableProxy<V,X>

All Implemented Interfaces:

SQLHookable, SQLQueryable<X>, AbstractDBTable<X>

public class DBTableProxy<V extends DataBaseTable<X>,X extends DataBaseEntry>
extends DataBaseTable<X>

Field Summary

Fields

Modifier and Type	Field	Description
protected final Connection	connection
protected final V	delegate

Fields inherited from class lu.kbra.pclib.db.table.DataBaseTable

database, dataBaseEntryUtils, tableClass, tableStructure

Constructor Summary

Constructors

Constructor	Description
DBTableProxy(V delegate, Connection connection)

Method Summary

Modifier and Type	Method	Description
int	clear()
int	count()
int	countNotNull(X data)
int	countUniques(X data)
DataBaseTableStatus<X,? extends DataBaseTable<X>>	create()	Deprecated.
X	delete(X data)
Optional<X>	deleteIfExists(X data)
Optional<X>	deleteUnique(X data)
List<X>	deleteUniques(X data)
DataBaseTable<X>	drop()	Deprecated.
boolean	exists()
boolean	exists(X data)
boolean	existsUnique(X data)
boolean	existsUniques(X data)
String[]	getCreateSQL()	Deprecated.
DataBase	getDatabase()
DataBaseEntryUtils	getDataBaseEntryUtils()
V	getDelegate()
String	getName()
String[]	getPrimaryKeysNames()
String	getQualifiedName()
Class<? extends AbstractDBTable<X>>	getTableClass()
Class<? extends SQLQueryable<X>>	getTargetClass()
X	insert(X data)
X	insertAndReload(X data)
X	load(X data)
List<X>	loadByUnique(X data)	Returns a list of all the possible entries matching with the unique values of the input.
Optional<X>	loadIfExists(X data)
X	loadIfExistsElseInsert(X data)	Loads the first pk result, returns a the newly inserted instance if none is found
X	loadUnique(X data)	Loads the first unique result, or throws an exception if none is found.
Optional<X>	loadUniqueIfExists(X data)	Loads the first unique result, returns null if none is found and throws an exception if too many are available.
X	loadUniqueIfExistsElseInsert(X 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.
<B> B	query(SQLQuery<X,B> query)
void	requestHook(SQLRequestType type, Object query)	Deprecated.
void	setDbEntryUtils(DataBaseEntryUtils dbEntryUtils)	Deprecated.
String	toString()
int	truncate()	Deprecated.
X	update(X data)
X	updateAndReload(X data)
protected AbstractConnection	use()

Methods inherited from class lu.kbra.pclib.db.table.DataBaseTable

clear, count, countNotNull, countUniques, create, createProxy, delete, deleteIfExists, deleteUnique, deleteUniques, doubleQuoteEscapeIdentifier, drop, exists, exists, existsUnique, existsUniques, gen, getConnector, getQueryable, insert, insertAndReload, load, loadByUnique, loadIfExists, loadIfExistsElseInsert, loadUnique, loadUniqueIfExists, loadUniqueIfExistsElseInsert, query, truncate, update, updateAndReload

Methods inherited from class java.lang.Object

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

Methods inherited from interface lu.kbra.pclib.db.table.AbstractDBTable

getEntryClass, getTableStructure

Field Details

delegate

protected final V extends DataBaseTable<X> delegate

connection

protected final Connection connection

Constructor Details

DBTableProxy

public DBTableProxy(V delegate,
 Connection connection)

Method Details

clear

public int clear()
          throws DBException

Specified by:

clear in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

clear in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

count

public int count()
          throws DBException

Specified by:

count in interface SQLQueryable<V extends DataBaseTable<X>>

Overrides:

count in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

countNotNull

public int countNotNull(X data)
                 throws DBException

Specified by:

countNotNull in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

countNotNull in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

countUniques

public int countUniques(X data)
                 throws DBException

Specified by:

countUniques in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

countUniques in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

create

@Deprecated
public DataBaseTableStatus<X,? extends DataBaseTable<X>> create()
                                                         throws DBException

Deprecated.

Specified by:

create in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

create in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

delete

public X delete(X data)
         throws DBException

Specified by:

delete in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

delete in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

deleteIfExists

public Optional<X> deleteIfExists(X data)
                           throws DBException

Specified by:

deleteIfExists in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

deleteIfExists in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

deleteUnique

public Optional<X> deleteUnique(X data)
                         throws DBException

Specified by:

deleteUnique in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

deleteUnique in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

deleteUniques

public List<X> deleteUniques(X data)
                      throws DBException

Specified by:

deleteUniques in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

deleteUniques in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

drop

@Deprecated
public DataBaseTable<X> drop()
                      throws DBException

Deprecated.

Specified by:

drop in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

drop in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

exists

public boolean exists()
               throws DBException

Specified by:

exists in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

exists in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

exists

public boolean exists(X data)
               throws DBException

Specified by:

exists in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

exists in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

existsUnique

public boolean existsUnique(X data)
                     throws DBException

Specified by:

existsUnique in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

existsUnique in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

existsUniques

public boolean existsUniques(X data)
                      throws DBException

Specified by:

existsUniques in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

existsUniques in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

getCreateSQL

@Deprecated
public String[] getCreateSQL()

Deprecated.

Specified by:

getCreateSQL in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

getCreateSQL in class DataBaseTable<X extends DataBaseEntry>

getDatabase

public DataBase getDatabase()

getDataBaseEntryUtils

public DataBaseEntryUtils getDataBaseEntryUtils()

getDelegate

public V getDelegate()

getName

public String getName()

getPrimaryKeysNames

public String[] getPrimaryKeysNames()

Specified by:

getPrimaryKeysNames in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

getPrimaryKeysNames in class DataBaseTable<X extends DataBaseEntry>

getQualifiedName

public String getQualifiedName()

getTableClass

public Class<? extends AbstractDBTable<X>> getTableClass()

getTargetClass

public Class<? extends SQLQueryable<X>> getTargetClass()

Specified by:

getTargetClass in interface SQLQueryable<V extends DataBaseTable<X>>

Overrides:

getTargetClass in class DataBaseTable<X extends DataBaseEntry>

insert

public X insert(X data)
         throws DBException

Specified by:

insert in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

insert in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

insertAndReload

public X insertAndReload(X data)
                  throws DBException

Specified by:

insertAndReload in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

insertAndReload in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

load

public X load(X data)
       throws DBException

Specified by:

load in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

load in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadByUnique

public List<X> loadByUnique(X data)
                     throws DBException

Description copied from class: DataBaseTable

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

Specified by:

loadByUnique in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

loadByUnique in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadIfExists

public Optional<X> loadIfExists(X data)
                         throws DBException

Overrides:

loadIfExists in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadIfExistsElseInsert

public X loadIfExistsElseInsert(X data)
                         throws DBException

Description copied from class: DataBaseTable

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

Overrides:

loadIfExistsElseInsert in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadUnique

public X loadUnique(X data)
             throws DBException

Description copied from class: DataBaseTable

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

Specified by:

loadUnique in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

loadUnique in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadUniqueIfExists

public Optional<X> loadUniqueIfExists(X data)
                               throws DBException

Description copied from class: DataBaseTable

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

Specified by:

loadUniqueIfExists in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

loadUniqueIfExists in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

loadUniqueIfExistsElseInsert

public X loadUniqueIfExistsElseInsert(X data)
                               throws DBException

Description copied from class: DataBaseTable

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

Specified by:

loadUniqueIfExistsElseInsert in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

loadUniqueIfExistsElseInsert in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

query

public <B> B query(SQLQuery<X,B> query)
            throws DBException

Specified by:

query in interface SQLQueryable<V extends DataBaseTable<X>>

Overrides:

query in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

requestHook

@Deprecated
public void requestHook(SQLRequestType type,
 Object query)

Deprecated.

Specified by:

requestHook in interface SQLHookable

Overrides:

requestHook in class DataBaseTable<X extends DataBaseEntry>

setDbEntryUtils

@Deprecated
public void setDbEntryUtils(DataBaseEntryUtils dbEntryUtils)

Deprecated.

Overrides:

setDbEntryUtils in class DataBaseTable<X extends DataBaseEntry>

toString

public String toString()

Overrides:

toString in class Object

truncate

@Deprecated
public int truncate()
             throws DBException

Deprecated.

Specified by:

truncate in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

truncate in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

update

public X update(X data)
         throws DBException

Specified by:

update in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

update in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

updateAndReload

public X updateAndReload(X data)
                  throws DBException

Specified by:

updateAndReload in interface AbstractDBTable<V extends DataBaseTable<X>>

Overrides:

updateAndReload in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException

use

protected AbstractConnection use()
                          throws DBException

Overrides:

use in class DataBaseTable<X extends DataBaseEntry>

Throws:

DBException