Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

import androidx.room.Dao;

import androidx.room.Insert;

import androidx.room.Query;

import androidx.room.Update;

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

import java.util.List;

@Dao

public interface CompanyDao {

    @Query( "SELECT * FROM tb_companies ORDER BY name ")

    List<Company> selectAll();

    @Query("select * from tb_companies WHERE uuid = :uuid")

    Company selectByUuid(String uuid);

    @Insert

    void insert(Company company);

    @Update

    void update(Company company);

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

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_companies")

    void removeAll();

}