return result;
}
@Insert
- public abstract void insertSync(Transaction item);
+ public abstract long insertSync(Transaction item);
@Update
public abstract void updateSync(Transaction item);
@Delete
public abstract void deleteSync(Transaction item);
+ @Delete
+ public abstract void deleteSync(List<Transaction> items);
+
@Query("SELECT * FROM transactions")
public abstract LiveData<List<Transaction>> getAll();
// @Transaction
// @Query("SELECT * FROM patterns")
// List<PatternWithAccounts> getPatternsWithAccounts();
- @Query("SELECT * FROM transactions WHERE profile = :profileUUID AND id = :id")
- public abstract LiveData<Transaction> getById(@NonNull String profileUUID, long id);
+ @Query("SELECT * FROM transactions WHERE id = :id")
+ public abstract LiveData<Transaction> getById(long id);
@Query("SELECT DISTINCT description, CASE WHEN description_upper LIKE :term||'%%' THEN 1 " +
" WHEN description_upper LIKE '%%:'||:term||'%%' THEN 2 " +
"ORDER BY ordering, description_upper, rowid ")
public abstract List<DescriptionContainer> lookupDescriptionSync(@NonNull String term);
+ @Query("SELECT * from transactions WHERE profile_id = :profileId")
+ public abstract List<Transaction> allForProfileSync(long profileId);
+
static public class DescriptionContainer {
@ColumnInfo
public String description;