getNextUsedTs method

Future<int> getNextUsedTs(
  1. int aboveTs
)

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;
}