Proyectos de Subversion Android Microlearning - Nuevo Interface

Rev

Rev 19 | Ir a la última revisión | Autoría | Comparar con el anterior | Ultima modificación | Ver Log | 

package com.cesams.twogetskills.dao;

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

import com.cesams.twogetskills.entity.NotificationCenter;
import com.cesams.twogetskills.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 WHERE uuid = :uuid LIMIT 1")
    NotificationCenter selectNotificationByUuid(String uuid);

    @Insert
    void insert(NotificationCenter notificationCenter);

    @Update
    void update(NotificationCenter notificationCenter);

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

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

}