Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

import androidx.room.Dao;

import androidx.room.Insert;

import androidx.room.OnConflictStrategy;

import androidx.room.Query;

import androidx.room.Update;

import com.cesams.twogetskills.inconcert.entity.Topic;

import com.cesams.twogetskills.inconcert.room.ResultCount;

import java.util.List;

@Dao

public interface TopicDao {

    @Query( "SELECT * FROM tb_topics WHERE uuid = :uuid LIMIT 1")

    Topic selectByUuid(String uuid);

    @Query("SELECT COUNT(*) AS count FROM tb_topics WHERE company_uuid = :companyUuid")

    ResultCount selectTotalByCompanyId(String companyUuid);

    @Query("SELECT * FROM tb_topics WHERE company_uuid = :companyUuid ORDER BY position, name")

    List<Topic> selectAllByCompanyUuid(String companyUuid);

    @Query("SELECT * FROM tb_topics ORDER BY position, name")

    List<Topic> selectAll();

    @Insert(onConflict = OnConflictStrategy.REPLACE)

    void insert(Topic topic);

    @Update

    void update(Topic topic);

    @Query("DELETE FROM tb_topics WHERE uuid = :uuid ")

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_topics")

    void removeAll();

}