getNextUsedTs method
Implementation
Future<int> getNextUsedTs(int aboveTs) async {
String sql = " SELECT water_ts " + " FROM " + tableName;
if (aboveTs != null) {
sql += " WHERE water_ts > " + aboveTs.toString();
}
sql += " LIMIT 1";
RawTableData rawTableData;
try {
rawTableData =
await transaction.getConnection().query(sql, FieldData.wee(table_id));
} on SqlException catch (e) {
throw SqlException(e.sqlExceptionEnum,
cause: e.cause,
sql: sql,
json: "{ tableName:'$tableName', index:'$getIndex' }");
}
late int ts;
try {
ts = rawTableData.getRawField(0, 0) as int;
} on RangeError catch (e) {
print(e);
}
return ts;
}