android.arch.persistence.room.Query Java Examples

@Query("SELECT mId as _id, " +
         "mDetails as suggest_text_1, " +
         "mId as suggest_intent_data_id " +
         "FROM earthquake " +
         "WHERE mDetails LIKE :query " +
         "ORDER BY mdate DESC")
public Cursor generateSearchSuggestions(String query);
 

@Query("DELETE FROM topic_detail WHERE id = :topicId")
void deleteTopicById(@NonNull String topicId);
 

@Query("SELECT * FROM AppPermission")
List<AppPermission> getAll();
 

@Query("select * from balance where type = 1")
List<BitsharesAsset> queryOrderBalance();
 

@Query("SELECT * FROM credentials")
public abstract List<PublicKeyCredentialSource> getAll();
 

@Query("SELECT * FROM earthquake ORDER BY mDate DESC")
List<Earthquake> loadAllEarthquakesBlocking();
 

@Query("SELECT * FROM `multiwallet` WHERE `coin` = :coin AND `address` = :address LIMIT 1")
Multiwallet findMultiwallet(String coin, String address);
 

@Query("SELECT * FROM StockPortfolioItem")
List<StockPortfolioItem> getPortfolioItems();
 

@Query("UPDATE Administrator SET first_name = :firstName, last_name = :lastName, username = :username WHERE uid = :uId")
void updateAdminById(String firstName, String lastName, String username, int uId);
 

@Query("SELECT * FROM credentials WHERE id = :id LIMIT 1")
public abstract PublicKeyCredentialSource getById(byte[] id);
 

@Query("select * from asset_object where asset_id = :strAssetId ")
BitsharesAssetObject queryAssetObjectById(String strAssetId);
 

@Query("DELETE FROM news Where id = :newsId")
void deleteNewsById(@NonNull String newsId);
 

@Query("SELECT * FROM Administrator WHERE uid IN (:AdministratorIds)")
List<Administrator> loadAllByIds(int[] AdministratorIds);
 

@Query("SELECT * FROM HoldCart WHERE holdCartId LIKE (:searchText)")
List<HoldCart> getSearchHoldCart(String searchText);
 

@Query("UPDATE users SET login_time=:loginTime WHERE username=:userName")
int updateLoginTime(long loginTime, String userName);
 

@Query("SELECT * FROM hoard")
public LiveData<List<Hoard>> monitorAllHoards();
 

@Query("SELECT * " +
         "FROM earthquake " +
         "WHERE mId = :id " +
         "LIMIT 1")
public LiveData<Earthquake> getEarthquake(String id);
 

@Query("SELECT * FROM StockPortfolioItem")
List<StockPortfolioItem> getPortfolioItems();
 

@Query("UPDATE Options SET option_name = :optionName, option_type = :optionType, option_values = :optionValues WHERE option_id = :oId")
void updateOptionsById(String optionName
        , String optionType
        , String optionValues
        , int oId);
 

@Query("DELETE FROM CashDrawerModel")
void delete();
 

@Query("SELECT * FROM BlockUrlProviders WHERE url = :url")
BlockUrlProvider getByUrl(String url);
 

@Query("SELECT * FROM AppInfo WHERE disabled = 0 ORDER BY adhellWhitelisted DESC, appName ASC")
LiveData<List<AppInfo>> getAllSortedByWhitelist();
 

@Query("SELECT * FROM BlockUrlProviders WHERE url = :url")
BlockUrlProvider getByUrl(String url);
 

@Query("SELECT * " +
         "FROM earthquake " +
         "WHERE mId = :id " +
         "LIMIT 1")
public LiveData<Earthquake> getEarthquake(String id);
 

@Query("delete from friend_contacts")
int delAll();
 

@Query("SELECT * FROM Currency WHERE code IN (:currencyCode)")
List<Currency> loadAllByIds(int[] currencyCode);
 

@Query("update friend_contacts set received_avatar=:receivedAvatar")
int setAllFriendReceivedAvatar(boolean receivedAvatar);
 

@Query("SELECT * FROM AppInfo WHERE (appName LIKE :str OR packageName LIKE :str) ORDER BY disabled DESC, appName ASC")
List<AppInfo> getAllAppsWithStrInNameDisabledOrder(String str);
 

@Query("SELECT * FROM consumedEntries")
List<ConsumedEntries> getAllConsumedEntries();
 

@Query("SELECT * FROM PolicyPackage")
LiveData<PolicyPackage> getAllLiveData();