Android Room Fetch data with dynamic table name

Question

Is it possible to fetch data by passing the table name as a parameter? Something like this.

@Query("SELECT id, name from :tableName")
fun getData(tableName: String): List<RandomModel>

Answer 1

Try this

@Dao
interface RawDao {
 @RawQuery
 List<RandomModel> getData(SupportSQLiteQuery query);
}

 SimpleSQLiteQuery query = new SimpleSQLiteQuery("SELECT * FROM "+ tablename);
 List<RandomModel> models = rawDao.getUserViaQuery(query);

Answer 2

I think Room does not support dynamic tableName.

We have two ways:

1-In DAO, we can replace tableName with the actual table name, as defined on the model @Entity

2-We can use @RawQuery like this :

@Dao
 interface RawDao {
     @RawQuery
     User getUserViaQuery(SupportSQLiteQuery query);
 }
 SimpleSQLiteQuery query = new SimpleSQLiteQuery("SELECT * FROM User WHERE id = ? LIMIT 1",
         new Object[]{userId});
 User user2 = rawDao.getUserViaQuery(query);

You can study more at this