androidx.room.Query Java Examples

@Query("select account.id as id, username,password,sessionResource,accountId from credentials join account on credentialsId = credentials.id where account.id=:id limit 1")
public abstract ListenableFuture<AccountWithCredentials> getAccountFuture(Long id);
 

@Query("SELECT * FROM " + GroupMessage.TABLE_NAME + " WHERE _id != :indexId AND data_hash = :hash LIMIT 1")
@Nullable GroupMessage getExistMessageAttachment(long indexId, String hash);
 

@Query("DELETE FROM Alarm")
void deleteAll();
 

@Query("SELECT * FROM " + GroupMessage.TABLE_NAME + " WHERE gid = " + " :gid" + " AND from_uid = :from_uid" + " AND content_type = 1" + " AND create_time >= :startTime" + " AND create_time <= :endTime")
List<GroupMessage> fetchMessagesBySenderAndPeriod(long gid, String from_uid, long startTime, long endTime);
 

@Query("update `query` set state=:newState where state=:oldState and id=:queryId")
abstract int updateQueryState(Long queryId, String newState, String oldState);
 

@Transaction
@Query("select id from email where threadId in (:threadIds)")
public abstract List<EmailWithMailboxes> getEmailsWithMailboxes(Collection<String> threadIds);
 

@Query("DELETE FROM Reminder")
void deleteAll();
 

@Query("delete from keyword_overwrite where threadId=:threadId")
protected abstract int deleteKeywordOverwritesByThread(String threadId);
 

@Query("select id,role,name from mailbox where role=:role limit 1")
public abstract ListenableFuture<MailboxWithRoleAndName> getMailboxFuture(Role role);
 

@Query("SELECT * FROM " + GroupLiveInfo.TABLE_NAME + " LIMIT 100 OFFSET :page")
List<GroupLiveInfo> queryByPage(int page);
 

@Query("delete from query_item_overwrite where threadId in (:threadIds)")
public abstract int deleteQueryOverwritesByThread(Collection<String> threadIds);
 

@Query("update mailbox set unreadThreads=:value where id=:id")
public abstract void updateUnreadThreads(String id, Long value);
 

@Query("SELECT * FROM " + DatabaseColumnConstant.VideoEntry.TABLE_NAME
        + " WHERE " + DatabaseColumnConstant.VideoEntry.COLUMN_CATEGORY
        + " = :category")
LiveData<List<VideoEntity>> loadVideoInSameCateogry(String category);
 

@Query("select id from mailbox where role in (:roles) order by role")
public abstract String[] getMailboxes(Role... roles);
 

@Query("delete from query_item_overwrite where executed=1 and queryId=:queryId")
abstract int deleteAllExecuted(Long queryId);
 

@Query("SELECT * FROM upload_image_table ORDER BY uploadTime DESC")
List<ImageEntity> getUploadedImage();
 

@Query(" select threadId from `query` join query_item on `query`.id = queryId where threadId not in(select thread.threadId from thread) and queryString=:queryString")
public abstract List<String> getMissingThreadIds(String queryString);
 

@Query("SELECT * FROM Alarm ORDER BY hour ASC, minute ASC")
List<Alarm> getAllSortedByTime();
 

@Query("select position,emailId from thread_item where threadId=:threadId order by position")
public abstract ListenableFuture<List<ExpandedPosition>> getAllPositions(String threadId);
 

@Query("update query_item set position=position+1 where queryId=:queryId and position>=:position ")
abstract int incrementAllPositionsFrom(Long queryId, Long position);
 

@Query("select id,parentId,name,sortOrder,unreadThreads,totalThreads,role from mailbox where role=:role limit 1")
public abstract MailboxOverviewItem getMailboxOverviewItem(Role role);
 

@Query("DELETE FROM Reminder WHERE id IN (:ids)")
void removeReminders(int... ids);
 

@Query("SELECT COUNT(*) FROM App")
int getNumberOfRows();
 

@Query("SELECT * FROM (SELECT * FROM illust_recmd_table ORDER BY time DESC LIMIT 20) ORDER BY time")
List<IllustRecmdEntity> getAll();
 

@Query("UPDATE Alarm SET enabled=:enabled WHERE `key` = :key")
void update(int key, boolean enabled);
 

@Query("select account.id as id, username,password,sessionResource,accountId from credentials join account on credentialsId = credentials.id order by lastSelectedAt desc limit 1")
public abstract ListenableFuture<AccountWithCredentials> getMostRecentlySelectedAccountFuture();
 

@Query("select emailId as id,position from `query` join query_item on `query`.id = queryId  where queryString=:queryString order by position desc limit 1")
abstract QueryStateWrapper.UpTo getUpTo(String queryString);
 

@Query("select * from `query` where queryString=:queryString")
abstract QueryEntity getQueryEntity(String queryString);
 

@Query("select id,role,name from mailbox where role=:role limit 1")
public abstract MailboxWithRoleAndName getMailbox(Role role);
 

@Query("delete from thread")
abstract void deleteAllThread();