getMaxMessageSeq method

Future<int> getMaxMessageSeq(
  1. String channelID,
  2. int channelType
)

Implementation

Future<int> getMaxMessageSeq(String channelID, int channelType) async {
  String sql =
      "SELECT max(message_seq) message_seq FROM ${WKDBConst.tableMessage} WHERE channel_id=? AND channel_type=?";
  int messageSeq = 0;
  if (WKDBHelper.shared.getDB() == null) {
    return messageSeq;
  }
  List<Map<String, Object?>> list = await WKDBHelper.shared
      .getDB()!
      .rawQuery(sql, [channelID, channelType]);
  if (list.isNotEmpty) {
    dynamic data = list[0];
    messageSeq = WKDBConst.readInt(data, 'message_seq');
  }
  return messageSeq;
}