seecoder-devcloud/web/src/main/java/seecoder/devcloud/web/dao/user/GroupMemberMapper.java

package seecoder.devcloud.web.dao.user;

import org.apache.ibatis.annotations.*;
import seecoder.devcloud.web.model.po.user.Group;
import seecoder.devcloud.web.model.po.user.User;

import java.util.List;

/**
 * @author PuHong Weng
 * @date 2021/3/4
 * @description:
 */
@Mapper
public interface GroupMemberMapper {

    @Insert("insert into group_member (group_id,user_id) values (#{groupId}, #{userId}) ")
    int insert(@Param("groupId") int groupId,@Param("userId") int userId);

    @Delete("delete from group_member where group_id = #{groupId} and user_id = #{userId}")
    int delete(@Param("groupId") int groupId,@Param("userId")  int userId);

    @Select("select user_id from group_member where group_id = #{groupId}")
    List<Integer> selectUserIdsByGroupId(int groupId);

    @Select("select group_id from group_member where user_id = #{userId}")
    List<Integer> selectGroupIdsByUserId(int groupId);

    @Select("select u.* from group_member gm, user u where u.id = gm.user_id and gm.group_id = #{groupId}")
    List<User> selectUsersByGroupId(int groupId);

    @Select("select g.* from group_member gm, group g where g.id = gm.group_id and gm.userId = #{userId}")
    List<Group> selectGroupsByUserId(int userId);

}