public class PublicKeys extends AbstractTable
Modifier and Type | Field and Description |
---|---|
static String |
ACTIVE_COLUMN_NAME
The name of the active column.
|
static String |
KEY_BLOB_COLUMN_NAME
The name of the key blob column.
|
static String |
KEY_INDEX_COLUMN_NAME
The name of the key index column.
|
static String |
KEY_TYPE_COLUMN_NAME
The name of the key type column.
|
static String |
USER_ID_COLUMN_NAME
The name of the user id column.
|
Constructor and Description |
---|
PublicKeys()
Default constructor.
|
Modifier and Type | Method and Description |
---|---|
ParameterizedSql |
getCountSql(UUID userId,
Integer index,
KeyType type,
Boolean active) |
String |
getCreateSql()
Get the create sql for this table.
|
ParameterizedSql |
getDeleteSql(UUID userId,
Integer index,
KeyType type,
Boolean active)
Get the delete sql for this table using the given parameters.
|
ParameterizedSql |
getInsertSql(UUID userId,
int index,
KeyType type,
boolean active,
byte[] key)
Get the insert sql for this table using the given parameters.
|
ParameterizedSql |
getQuerySql(UUID userId,
Integer index,
KeyType type,
Boolean active)
Get the query sql for this table using the given parameters.
|
ParameterizedSql |
getUpdateSql(UUID userId,
int index,
KeyType type,
boolean active,
byte[] key)
Get the update sql for this table using the given parameters.
|
getCountSql, getCountSql, getDeleteSql, getInsertSql, getInsertSql, getQueryParameterizedSql
public static final String ACTIVE_COLUMN_NAME
public static final String KEY_BLOB_COLUMN_NAME
public static final String KEY_INDEX_COLUMN_NAME
public static final String KEY_TYPE_COLUMN_NAME
public static final String USER_ID_COLUMN_NAME
public ParameterizedSql getCountSql(UUID userId, Integer index, KeyType type, Boolean active)
public String getCreateSql()
getCreateSql
in class AbstractTable
public ParameterizedSql getDeleteSql(UUID userId, Integer index, KeyType type, Boolean active)
userId
- the userId of the records to delete - set null if not neededindex
- the index of the records to delete - set null if not neededtype
- the type of the records to delete - set null if not neededactive
- the active state of the records to delete - set null if not neededParameterizedSql
object with the sql and parameters for the deletepublic ParameterizedSql getInsertSql(UUID userId, int index, KeyType type, boolean active, byte[] key)
userId
- the userId of the records to insert - set null if not neededindex
- the index of the records to insert - set null if not neededtype
- the type of the records to insert - set null if not neededactive
- the active state of the records to insert - set null if not neededkey
- the key blob of the records to insert - set null if not neededParameterizedSql
object with the sql and parameters for the insertpublic ParameterizedSql getQuerySql(UUID userId, Integer index, KeyType type, Boolean active)
userId
- the userId of the records to query - set null if not neededindex
- the index of the records to query - set null if not neededtype
- the type of the records to query - set null if not neededactive
- the active state of the records to query - set null if not neededParameterizedSql
object with the sql and parameters for the querypublic ParameterizedSql getUpdateSql(UUID userId, int index, KeyType type, boolean active, byte[] key)
userId
- the userId of the records to update - set null if not neededindex
- the index of the records to update - set null if not neededtype
- the type of the records to update - set null if not neededactive
- the active state of the records to update - set null if not neededkey
- the key blob of the records to insert - set null if not neededParameterizedSql
object with the sql and parameters for the updateCopyright © 2021. All rights reserved.