package com.people.room.dao;

import androidx.room.Dao;
import androidx.room.Delete;
import androidx.room.Insert;
import androidx.room.Query;
import androidx.room.Update;
import com.people.room.entity.UserEntity;
import java.util.List;

/**
 * java类作用描述
 *
 * @author baozhaoxin
 * @version [V1.0.0, 2023/3/18]
 * @since V1.0.0
 */

@Dao
public interface UserDao {

    @Query("SELECT * FROM user_db")
    List<UserEntity> getAll();

    @Insert
    void insertAll(UserEntity... users);

    @Delete
    void delete(UserEntity user);

    @Update
    void updateUsers(UserEntity... users);

    /**
     * 查询返回数据库中的所有 UserEntity 对象
     * @return
     */
    @Query("SELECT * FROM user_db")
    UserEntity[] loadAllUsers();

    /**
     *
     * @param userIds
     * @return
     */
    @Query("SELECT * FROM user_db WHERE ids IN (:userIds)")
    List<UserEntity> loadAllByIds(int[] userIds);
}