package com.people.room.dao;

import com.people.room.entity.MailBookingliveModel;

import java.util.List;

import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.OnConflictStrategy;
import androidx.room.Query;
import androidx.room.Update;

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

@Dao
public interface MailBookingLiveDao {

    @Query("DELETE FROM tb_mailbookinglive WHERE ids=:ids")
    void delete(int ids);
    /**
     * 根据keys删除数据
     * */
    @Query("DELETE FROM tb_mailbookinglive WHERE userId=:userId")
    void deleteByUserId(String userId);
    /**
     * 根据keys查询一条数据
     */
    @Query("SELECT * FROM tb_mailbookinglive WHERE keys=:keys AND userId=:userId")
    MailBookingliveModel queryByKey(String keys, String userId);

    /**
     * 根据用户查询已读
     */
    @Query("SELECT * FROM tb_mailbookinglive WHERE isread=:isread AND userId=:userId")
    List<MailBookingliveModel> queryReadByUserId(String userId, String isread);

    /**
     * 查询所有数据
     * @return
     */
    @Query("SELECT * FROM tb_mailbookinglive  WHERE userId=:userId")
    List<MailBookingliveModel> queryAllByUserId(String userId);

//    /**
//     * 查询所有数量
//     * @return
//     */
//    @Query("SELECT COUNT(*) FROM tb_mailbookinglive WHERE isread=:isread AND userId=:userId")
//    int getTotalCount(String userId,String isread);
//
//    @Query("SELECT COUNT(*) FROM tb_mailbookinglive")
//    int getTotalCount();
    /**
     * 插入/更新
     * */
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    void insertOrUpdate(MailBookingliveModel... models);

    /**
     * 更新
     * */
    @Update
    void update(MailBookingliveModel... models);

    /**
     * 更新
     * */
    @Query("UPDATE tb_mailbookinglive SET isread = :isread WHERE keys=:keys AND userId=:userId")
    void updateReadStateByKey(String keys, String userId, String isread);

    /**
     * 清空所有
     *
     */
    @Query("DELETE FROM tb_mailbookinglive")
    void clear();
}