How to use predefined Strings inside Room Database query?

Viewed 332

Is it possible to use predefined Strings inside the Room Query? For instance:

@Query("delete from Bookmarks where listName != Constants.SOME_LIST_NAME")
void deleteAllBookmarks();

Just to be clear, I don't want to pass it as a parameter:

@Query("delete from Bookmarks where listName != :listName")
void deleteAllBookmarks(String listName);

and I don't want to hardcode it (it is used in more than one place):

@Query("delete from Bookmarks where listName != 'MyList'")
void deleteAllBookmarks();
1 Answers

Unsure if that's supported, someone can probably prove me wrong but until then... you know...

Assuming that SOME_LIST_NAME = "MyList" then you could just do:

@Query("delete from Bookmarks where listName != MyList")
void deleteAllBookmarks();
Related