com.absio.database.table

Class Users

java.lang.Object

com.absio.database.table.AbstractTable

com.absio.database.table.Users

public class Users
extends AbstractTable

This class represents the Users table. It has the logic for producing all relevant SQL for inserting, updating deleting and reading from the table.

Field Summary

Fields

Modifier and Type	Field and Description
static String	USER_ID_COLUMN_NAME The name of the user id column.

Constructor Summary

Constructors

Constructor and Description
Users() Default constructor.

Method Summary

Modifier and Type	Method and Description
ParameterizedSql	getCountSql(UUID userId) Get the count sql for a given user id.
String	getCreateSql() Get the create sql for this table.
ParameterizedSql	getDeleteSql(UUID userId) Get the delete sql for a given user id.
ParameterizedSql	getInsertSql(UUID userId) Get the insert sql for a given user id.
ParameterizedSql	getQuerySql(UUID userId) Get the query for a given user id.

Methods inherited from class com.absio.database.table.AbstractTable

getCountSql, getCountSql, getDeleteSql, getInsertSql, getInsertSql, getQueryParameterizedSql

Methods inherited from class java.lang.Object

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

Field Detail

USER_ID_COLUMN_NAME

public static final String USER_ID_COLUMN_NAME

The name of the user id column.

See Also:

Constant Field Values

Constructor Detail

Users

public Users()

Default constructor.

Method Detail

getCountSql

public ParameterizedSql getCountSql(UUID userId)

Get the count sql for a given user id. If null is used a count for all records will be returned.

Parameters:

userId - the user's id to check for existence

Returns:

the count sql

getCreateSql

public String getCreateSql()

Get the create sql for this table.

Specified by:

getCreateSql in class AbstractTable

Returns:

the create sql for this table

getDeleteSql

public ParameterizedSql getDeleteSql(UUID userId)

Get the delete sql for a given user id. If null is used a delete for all records will be returned.

Parameters:

userId - the user's id to delete

Returns:

the ParameterizedSql object with the sql and parameters for the delete

getInsertSql

public ParameterizedSql getInsertSql(UUID userId)

Get the insert sql for a given user id.

Parameters:

userId - the user's id to insert - this is required

Returns:

the ParameterizedSql object with the sql and parameters for the insert

Throws:

IllegalArgumentException - thrown if userId is null

getQuerySql

public ParameterizedSql getQuerySql(UUID userId)

Get the query for a given user id. If null is used a query for all records will be returned.

Parameters:

userId - the user's id to query

Returns:

the ParameterizedSql object with the sql and parameters for the query