package com.people.room.dao;

import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.OnConflictStrategy;
import androidx.room.Query;
import com.people.room.entity.LaunchAdModel;
import java.util.List;

/**
 * 开机屏广告dao
 * @author baozhaoxin
 * @version [V1.0.0, 2023/10/31]
 * @since V1.0.0
 */
@Dao
public interface LaunchAdDao {
    /**
     * 插入models
     * @param models
     */
    @Insert(onConflict = OnConflictStrategy.REPLACE)
    void insert(LaunchAdModel... models);

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

    /**
     * 根据advid删除数据
     * */
    @Query("DELETE FROM tb_launch_adv WHERE advId=:advId")
    void deleteByAdvId(int advId);

    /**
     * 查所有数据
     * @return
     */
    @Query("SELECT * FROM tb_launch_adv")
    List<LaunchAdModel> getAll();

    /**
     * 根据advId获取数据
     * */
    @Query("SELECT * FROM tb_launch_adv WHERE advId=:advId")
    LaunchAdModel getByAdvId(String advId);

}