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();

}