getDeletedCount method

Future<int> getDeletedCount(
  1. int minMessageSeq,
  2. int maxMessageSeq,
  3. String channelID,
  4. int channelType,
)

Implementation

Future<int> getDeletedCount(int minMessageSeq, int maxMessageSeq,
    String channelID, int channelType) async {
  String sql =
      "select count(*) num from ${WKDBConst.tableMessage} where channel_id=? and channel_type=? and message_seq>? and message_seq<? and is_deleted=1";
  int num = 0;
  if (WKDBHelper.shared.getDB() == null) {
    return num;
  }
  List<Map<String, Object?>> list = await WKDBHelper.shared
      .getDB()!
      .rawQuery(sql, [channelID, channelType, minMessageSeq, maxMessageSeq]);
  if (list.isNotEmpty) {
    dynamic data = list[0];
    num = WKDBConst.readInt(data, 'num');
  }
  return num;
}