Module databases/h2
Dialect implementation for H2 databases
See
Functions
- addSqlLimit(sqlBuf, limit)
- addSqlOffset(sqlBuf, offset)
- addSqlRange(sqlBuf, offset, limit)
- getSqlNextSequenceValue(sequenceName)
- hasSequenceSupport()
addSqlLimit (sqlBuf, limit)
Extends the SQL statement passed as argument with a limit restriction
Parameters
Array | sqlBuf | The SQL statement |
Limit | limit | The limit |
addSqlOffset (sqlBuf, offset)
Extends the SQL statement passed as argument with an offset restriction
Parameters
Array | sqlBuf | The SQL statement |
Number | offset | The offset |
addSqlRange (sqlBuf, offset, limit)
Extends the SQL statement passed as argument with a range restriction
Parameters
Array | sqlBuf | The SQL statement |
Number | offset | The offset |
Limit | limit | The limit |
getSqlNextSequenceValue (sequenceName)
Returns the SQL statement for retrieving the next value of a sequence
Parameters
String | sequenceName | The name of the sequence |
Returns
String | The SQL statement |