How to get the row count of Room database in android?

Question

I'm following the practice of having a Repository and a Dao and so on. I was trying to get the row count in my database repository by having a function

int getNumFiles() {
    List<AFile> lst = files.getValue();  // files is of type LiveData<List<AFile>> files;
    if (lst == null) {
        return 0;
    } else {
        return lst.size();
    }
}

But lst always evaluates to null. I guess it has something to do with me not being allowed to query the DB from the UI thread or something? Should I implement it like one implements adding or deleting an element? In other words have a function in the Dao which is called via an AsyncTask in the Database repository? I'm confused about how to do this very simple thing.

There is this answer which shows what one would write in the Dao to find out the number of rows, but it does not explain how the repository should call this.

Answer 1

Room database Count Table Row

@Query("SELECT COUNT(column_name) FROM tableName")
LiveData<Integer> getRowCount();