Proyectos de Subversion Android Microlearning

package com.cesams.twogetskills.dao;

import androidx.room.Dao;

import androidx.room.Delete;

import androidx.room.Insert;

import androidx.room.Query;

import com.cesams.twogetskills.entity.UserLog;

import java.util.List;

@Dao

public interface UserLogDao {

    @Query("SELECT * FROM tb_user_logs ORDER BY added_on DESC, id DESC")

    List<UserLog> selectAll();

    @Query("SELECT * FROM tb_user_logs  WHERE user_uuid = :userUuid ORDER BY added_on DESC, id DESC")

    List<UserLog> selectAllByUserUuid(String userUuid);

    @Query("SELECT * FROM tb_user_logs WHERE user_uuid = :userUuid AND activity = :activity AND added_on = :addedOn")

    UserLog selectOneByUserUuidAndActivityAndAddedOn(String userUuid, String activity, String addedOn);

    @Insert

    void insert(UserLog userLog);

    @Query("DELETE FROM tb_user_logs WHERE id = :id")

    void remove(int id);

    @Query("DELETE FROM tb_user_logs where user_uuid != :userUuid")

    void removeAllUserUuidNotEqual(String userUuid);

    @Query("DELETE FROM tb_user_logs")

    void removeAll();

}