getMsgSeq method

Future<int> getMsgSeq(
  1. String channelID,
  2. int channelType,
  3. int oldestOrderSeq,
  4. int pullMode,
)

Implementation

Future<int> getMsgSeq(String channelID, int channelType, int oldestOrderSeq,
    int pullMode) async {
  String sql;
  int messageSeq = 0;
  if (pullMode == 1) {
    sql =
        "select message_seq from ${WKDBConst.tableMessage} where channel_id=? and channel_type=? and  order_seq>? and message_seq<>0 order by message_seq desc limit 1";
  } else {
    sql =
        "select message_seq from ${WKDBConst.tableMessage} where channel_id=? and channel_type=? and  order_seq<? and message_seq<>0 order by message_seq asc limit 1";
  }
  if (WKDBHelper.shared.getDB() == null) {
    return messageSeq;
  }
  List<Map<String, Object?>> list = await WKDBHelper.shared
      .getDB()!
      .rawQuery(sql, [channelID, channelType, oldestOrderSeq]);
  if (list.isNotEmpty) {
    dynamic data = list[0];
    messageSeq = WKDBConst.readInt(data, 'message_seq');
  }
  return messageSeq;
}