@Delete
public abstract void deleteSync(List<Account> items);
+ @Query("DELETE FROM accounts")
+ public abstract void deleteAllSync();
+
@Query("SELECT * FROM accounts WHERE profile_id=:profileId ORDER BY name")
public abstract LiveData<List<Account>> getAll(long profileId);
public abstract List<AccountNameContainer> lookupNamesInProfileByNameSync(long profileId,
@NonNull String term);
+ @Transaction
@Query("SELECT * FROM accounts " +
"WHERE profile_id=:profileId AND name_upper LIKE '%%'||:term||'%%' " +
"ORDER BY CASE WHEN name_upper LIKE :term||'%%' THEN 1 " +
" WHEN name_upper LIKE '%% '||:term||'%%' THEN 3 " +
" ELSE 9 END, name_upper, rowid ")
public abstract List<AccountWithAmounts> lookupWithAmountsInProfileByNameSync(long profileId,
- @NonNull
- String term);
+ @NonNull String term);
@Query("SELECT DISTINCT name, CASE WHEN name_upper LIKE :term||'%%' THEN 1 " +
" WHEN name_upper LIKE '%%:'||:term||'%%' THEN 2 " +