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.Sync;

import java.util.List;

@Dao
public interface SyncDao {

    @Query("SELECT * FROM tb_sync LIMIT 20")
    List<Sync> selectBatch();

    @Query("SELECT * FROM tb_sync WHERE type = :type LIMIT 1")
    Sync selectOneByType(int type);

    @Insert
    void insert(Sync sync);

    @Query("DELETE FROM tb_sync WHERE id = :id")
    void remove(Long id);

}