Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

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

import com.cesams.twogetskills.inconcert.entity.NotificationCenter;
import com.cesams.twogetskills.inconcert.room.ResultCount;

import java.util.List;

@Dao
public interface NotificationCenterDao {

    @Query("SELECT COUNT(*) AS count FROM tb_notification")
    ResultCount getCountNotification();

    @Query("SELECT * FROM tb_notification")
    List<NotificationCenter> selectAllNotification();

    @Query("SELECT * FROM tb_notification group by date order by date DESC")
    List<NotificationCenter> selectAllNotificationOrderDay();

    @Query("SELECT * FROM tb_notification where date = :date")
    List<NotificationCenter> selectAllNotificationInDay(String date);

    @Query("SELECT * FROM tb_notification WHERE id = :id LIMIT 1")
    NotificationCenter selectNotificationByUuid(String id);

    @Insert
    void insert(NotificationCenter notificationCenter);

    @Update
    void update(NotificationCenter notificationCenter);

    @Query("DELETE FROM tb_notification WHERE id = :id")
    void removeNotificationByUuid(String id);

    @Query("DELETE FROM tb_notification")
    void removeAllnotifications();

}