MultipazProject

multipaz/org.multipaz.storage.base/SqlStatementMaker

SqlStatementMaker

class SqlStatementMaker(val spec: StorageTableSpec, val textType: String, val blobType: String, val longType: String, val useReturningClause: Boolean, collationCharset: String?)

Constructors

SqlStatementMaker

constructor(spec: StorageTableSpec, textType: String, blobType: String, longType: String, useReturningClause: Boolean, collationCharset: String?)

Properties

val blobType: String

createTableStatement

val createTableStatement: String

deleteAllInPartitionStatement

val deleteAllInPartitionStatement: String

deleteAllStatement

val deleteAllStatement: String

deleteOrUpdateCheckStatement

val deleteOrUpdateCheckStatement: String

deleteStatement

val deleteStatement: String

val getStatement: String

insertStatement

val insertStatement: String

val longType: String

purgeExpiredStatement

val purgeExpiredStatement: String

purgeExpiredWithIdStatement

val purgeExpiredWithIdStatement: String

val spec: StorageTableSpec

val tableName: String

val textType: String

updateStatement

val updateStatement: String

updateWithExpirationStatement

val updateWithExpirationStatement: String

useReturningClause

val useReturningClause: Boolean

Functions

conditionWithExpiration

fun conditionWithExpiration(nowSeconds: Long): String

SQL condition for the record with an id, a partition (if needed) and with expiration check (if needed) already injected.

enumerateConditionWithExpiration

fun enumerateConditionWithExpiration(nowSeconds: Long): String

SQL condition for the record with an id, a partition (if needed) and with expiration check (if needed) already injected.

enumerateStatement

fun enumerateStatement(withData: Boolean): String

enumerateWithLimitStatement

fun enumerateWithLimitStatement(withData: Boolean): String

purgeExpiredWithIdCondition

fun purgeExpiredWithIdCondition(timeSeconds: Long): String

SQL condition for the expired record with an id, and a partition (if needed).