com.absio.database.table

Class AbstractTable

java.lang.Object

com.absio.database.table.AbstractTable

Direct Known Subclasses:

Accesses, Containers, PublicKeys, Users

public abstract class AbstractTable
extends Object

This is the base class for Database Tables.

Constructor Summary

Constructors

Constructor and Description
AbstractTable(String name) Default constructor to create a table with the given name.

Method Summary

Modifier and Type	Method and Description
String	getCountSql(SqlParameter... parameters) Get the count sql for this table using the given parameters.
static String	getCountSql(String tableName, SqlParameter... parameters) Get the count sql for a table with the given set of parameters.
abstract String	getCreateSql() Get the create sql for this table.
String	getDeleteSql(SqlParameter... parameters) Get the delete sql for this table using the given set of parameters.
String	getInsertSql(SqlParameter... parameters) Get the insert sql for this table using the given set of parameters.
static String	getInsertSql(String tableName, SqlParameter... parameters) Get the insert sql for a table with the given set of parameters
String	getQueryParameterizedSql(SqlParameter... parameters) Get the query sql for this table using the given set of parameters.

Methods inherited from class java.lang.Object

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

Constructor Detail

AbstractTable

public AbstractTable(String name)

Default constructor to create a table with the given name.

Parameters:

name - the name of the table

Method Detail

getCountSql

public static String getCountSql(String tableName,
                                 SqlParameter... parameters)

Get the count sql for a table with the given set of parameters.

Parameters:

tableName - the name of the table

parameters - the parameters to use for the count query

Returns:

the count sql for a table

getInsertSql

public static String getInsertSql(String tableName,
                                  SqlParameter... parameters)

Get the insert sql for a table with the given set of parameters

Parameters:

tableName - the name of the table

parameters - the insert parameters

Returns:

the insert sql for a table

getCountSql

public String getCountSql(SqlParameter... parameters)

Get the count sql for this table using the given parameters.

Parameters:

parameters - the parameters to use for the count query

Returns:

the count sql for this table

getCreateSql

public abstract String getCreateSql()

Get the create sql for this table.

Returns:

the create sql for this table

getDeleteSql

public String getDeleteSql(SqlParameter... parameters)

Get the delete sql for this table using the given set of parameters.

Parameters:

parameters - the parameters to use for the delete

Returns:

the delete sql for this table

getInsertSql

public String getInsertSql(SqlParameter... parameters)

Get the insert sql for this table using the given set of parameters.

Parameters:

parameters - the parameters to use in the insert

Returns:

the insert sql for this table

getQueryParameterizedSql

public String getQueryParameterizedSql(SqlParameter... parameters)

Get the query sql for this table using the given set of parameters.

Parameters:

parameters - the parameters to use in the query

Returns:

the query sql for this table