MongoPlus使用总结

sql查询

java

LambdaQueryWrapper<WecomFriend> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(WecomFriend::getDeleted, false);
// 注意and和or的位置
queryWrapper.and(wrapper -> wrapper
                .in(WecomFriend::getWorkId, data.getWorkIds()).or()
                .in(WecomFriend::getCrackFriendId, data.getWechatUserIds()));
List<WecomFriend> wecomFriends = mapper.selectList(queryWrapper);
// select * from friend where deleted=0 AND (workId in ('a', 'b') OR crackFriendId in ('a', 'b'))

踩坑

org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 3
	at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectOne(BaseMapper.java:338)
	at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)

企微拉群后破解ID自动填充

群名称不一致问题(限制长度，模糊匹配前段)

MongoPlus使用总结 ​

MongoPlus使用总结