Proyectos de Subversion Android Microlearning

package com.cesams.twogetskills.dao;


import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.Query;
import androidx.room.Update;

import com.cesams.twogetskills.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();

}