How to apply conditions in room database?

Question

I'm using a room database for saving some apps details in a table. And getting live data.

But I'm unable to use conditions.

@Query("SELECT * FROM apps WHERE parent LIKE: parent")
    LiveData<List<App>> getAllApp(String parent);

Here is the condition I'm trying to use in DAO. But I can't figure, where should I pass the parameter in REPOSITORY and VIEWNODEL class;

Please help me. May be my question is not that clear but please help me.

Thank but. I can't pass the parameter (parent) from my acting class. — kish0n, Jul 09 '20 at 13:32
You're using AndroidViewModel so you need custom ViewModelFactory in order to pass parameter. Check [this](https://stackoverflow.com/questions/46283981/android-viewmodel-additional-arguments) — M D, Jul 09 '20 at 13:40

score 0 · Answer 1 · edited Jul 10 '20 at 03:14

public class AppRepository {

    private AppDao appDao;
    private LiveData<List<App>> appLiveData;


    AppRepository(Application application){
        Database database = Database.getDatabase(application);
        appDao = database.appDao();
        appLiveData = appDao.getAllApp();
    }


    LiveData<List<App>> getAllApp(){
        return appLiveData;
    }

    void insert(App app){
        Database.writer.execute(() ->{
            appDao.insert(app);
        });
    }

    void delete(App app){
        Database.writer.execute(() ->{
            appDao.delete(app);
        });
    }
}

public class AppViewModel extends AndroidViewModel {

    private AppRepository repository;
    private LiveData<List<App>> appLiveData;

    public AppViewModel(@NonNull Application application) {
        super(application);

        repository = new AppRepository(application);
        appLiveData = repository.getAllApp();
    }

    public LiveData<List<App>> getAllApp( ){
        return appLiveData;
    }

    public void insert(App app){
        repository.insert(app);
    }

    private void delete(App app){
        repository.delete(app);
    }
}

This would be a better answer if you explained how the code you provided answers the question. — pppery, Jul 10 '20 at 03:15

How to apply conditions in room database?

1 Answers1