queryWithMessageIds method

Future<List<WKMsg>> queryWithMessageIds(
  1. List<String> messageIds
)

Implementation

Future<List<WKMsg>> queryWithMessageIds(List<String> messageIds) async {
  String sql =
      "select $messageCols,$extraCols from ${WKDBConst.tableMessage} LEFT JOIN ${WKDBConst.tableMessageExtra} ON ${WKDBConst.tableMessage}.message_id=${WKDBConst.tableMessageExtra}.message_id WHERE ${WKDBConst.tableMessage}.message_id in (${WKDBConst.getPlaceholders(messageIds.length)})";
  List<WKMsg> list = [];
  if (WKDBHelper.shared.getDB() == null) {
    return list;
  }
  List<Map<String, Object?>> results =
      await WKDBHelper.shared.getDB()!.rawQuery(sql, messageIds);
  if (results.isNotEmpty) {
    for (Map<String, Object?> data in results) {
      list.add(WKDBConst.serializeWKMsg(data));
    }
  }
  return list;
}