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

}