com.absio.database.table

Class Accesses

java.lang.Object

com.absio.database.table.AbstractTable

com.absio.database.table.Accesses

public class Accesses
extends AbstractTable

The represents a table for storing Access that are a part of Metadata which is stored in Containers.

Field Summary

Fields

Modifier and Type	Field and Description
static String	CONTAINER_ID_COLUMN_NAME The name of the container id column.
static String	CREATED_AT_COLUMN_NAME The name of the created at column.
static String	CREATED_BY_COLUMN_NAME The name of the created by column.
static String	EXPIRES_AT_COLUMN_NAME The name of the expires at column.
static String	KEY_BLOB_COLUMN_NAME The name of the key blob column.
static String	MODIFIED_AT_COLUMN_NAME The name of the modified at column.
static String	MODIFIED_BY_COLUMN_NAME The name of the modified by column.
static String	PERMISSIONS_COLUMN_NAME The name of the permission column.
static String	USER_ID_COLUMN_NAME The name of the user id column.

Constructor Summary

Constructors

Constructor and Description
Accesses() Default constructor.

Method Summary

Modifier and Type	Method and Description
ParameterizedSql	getCountSql(UUID userId, UUID containerId) Get the count SQL for the given userId and containerId.
String	getCreateSql() Get the create SQL for the table.
ParameterizedSql	getDeleteSql(UUID userId, UUID containerId) Get the delete SQL for the table with the give container id.
ParameterizedSql	getInsertSql(Access access) Get the insert SQL for the table using the given Access.
ParameterizedSql	getQuerySql(UUID userId, UUID containerId) Get the query SQL for the user id and container id.
ParameterizedSql	getUpdateSql(Access access) Get the update SQL for the table using the given Access.

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

CONTAINER_ID_COLUMN_NAME

public static final String CONTAINER_ID_COLUMN_NAME

The name of the container id column.

See Also:

Constant Field Values

CREATED_AT_COLUMN_NAME

public static final String CREATED_AT_COLUMN_NAME

The name of the created at column.

See Also:

Constant Field Values

CREATED_BY_COLUMN_NAME

public static final String CREATED_BY_COLUMN_NAME

The name of the created by column.

See Also:

Constant Field Values

EXPIRES_AT_COLUMN_NAME

public static final String EXPIRES_AT_COLUMN_NAME

The name of the expires at column.

See Also:

Constant Field Values

KEY_BLOB_COLUMN_NAME

public static final String KEY_BLOB_COLUMN_NAME

The name of the key blob column.

See Also:

Constant Field Values

MODIFIED_AT_COLUMN_NAME

public static final String MODIFIED_AT_COLUMN_NAME

The name of the modified at column.

See Also:

Constant Field Values

MODIFIED_BY_COLUMN_NAME

public static final String MODIFIED_BY_COLUMN_NAME

The name of the modified by column.

See Also:

Constant Field Values

PERMISSIONS_COLUMN_NAME

public static final String PERMISSIONS_COLUMN_NAME

The name of the permission column.

See Also:

Constant Field Values

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

Accesses

public Accesses()

Default constructor.

Method Detail

getCountSql

public ParameterizedSql getCountSql(UUID userId,
                                    UUID containerId)

Get the count SQL for the given userId and containerId. If both are null the count SQL for the table is returned.

Parameters:

userId - the userID to count or null to count all records

containerId - the containerId to count or null to count all records

Returns:

the count SQL

getCreateSql

public String getCreateSql()

Get the create SQL for the table.

Specified by:

getCreateSql in class AbstractTable

Returns:

the create SQL for the table

getDeleteSql

public ParameterizedSql getDeleteSql(UUID userId,
                                     UUID containerId)

Get the delete SQL for the table with the give container id. If the container id is null, the delete sql to remove all rows is returned.

Parameters:

userId - the user's access to delete

containerId - the container's access to delete

Returns:

the delete SQL for the table

getInsertSql

public ParameterizedSql getInsertSql(Access access)

Get the insert SQL for the table using the given Access.

NOTE: the access, access container id and access user id must all be defined

Parameters:

access - the access to insert

Returns:

the insert SQL for the table

Throws:

IllegalArgumentException - if any of the required values are null

getQuerySql

public ParameterizedSql getQuerySql(UUID userId,
                                    UUID containerId)

Get the query SQL for the user id and container id. If the user id and container id are null the SQL will return all rows from the table.

Parameters:

userId - the user id to query

containerId - the container id to query

Returns:

the query SQL

getUpdateSql

public ParameterizedSql getUpdateSql(Access access)

Get the update SQL for the table using the given Access.

NOTE: the access, access container id and access user id must all be defined

Parameters:

access - the access to update

Returns:

the update SQL for the table

Throws:

IllegalArgumentException - if any of the required values are null