queryWithClientMsgNo method

Future<WKMsg?> queryWithClientMsgNo(
  1. String clientMsgNo
)

Implementation

Future<WKMsg?> queryWithClientMsgNo(String clientMsgNo) async {
  WKMsg? wkMsg;
  String sql =
      "select $messageCols,$extraCols from ${WKDBConst.tableMessage} LEFT JOIN ${WKDBConst.tableMessageExtra} ON ${WKDBConst.tableMessage}.message_id=${WKDBConst.tableMessageExtra}.message_id WHERE ${WKDBConst.tableMessage}.client_msg_no=?";
  if (WKDBHelper.shared.getDB() == null) {
    return wkMsg;
  }
  List<Map<String, Object?>> list =
      await WKDBHelper.shared.getDB()!.rawQuery(sql, [clientMsgNo]);
  if (list.isNotEmpty) {
    wkMsg = WKDBConst.serializeWKMsg(list[0]);
  }
  if (wkMsg != null) {
    wkMsg.reactionList =
        await ReactionDB.shared.queryWithMessageId(wkMsg.messageID);
  }
  return wkMsg;
}