methods for deleting all DB tables

[mobile-ledger.git] / app / src / main / java / net / ktnx / mobileledger / dao / OptionDAO.java

diff --git a/app/src/main/java/net/ktnx/mobileledger/dao/OptionDAO.java b/app/src/main/java/net/ktnx/mobileledger/dao/OptionDAO.java
index f6ee035bcb2199cdedd2853656f84a10aa0634a3..41d6464b4936c85e96d6fc3a8a875510825a29c8 100644 (file)
--- a/app/src/main/java/net/ktnx/mobileledger/dao/OptionDAO.java
+++ b/app/src/main/java/net/ktnx/mobileledger/dao/OptionDAO.java
@@ -27,6 +27,8 @@ import androidx.room.Update;
 
 import net.ktnx.mobileledger.db.Option;
 
+import java.util.List;
+
 @Dao
 public abstract class OptionDAO extends BaseDAO<Option> {
     @Insert(onConflict = OnConflictStrategy.REPLACE)
@@ -38,9 +40,18 @@ public abstract class OptionDAO extends BaseDAO<Option> {
     @Delete
     public abstract void deleteSync(Option item);
 
+    @Delete
+    public abstract void deleteSync(List<Option> items);
+
+    @Query("DELETE from options")
+    public abstract void deleteAllSync();
+
     @Query("SELECT * FROM options WHERE profile_id = :profileId AND name = :name")
     public abstract LiveData<Option> load(long profileId, String name);
 
     @Query("SELECT * FROM options WHERE profile_id = :profileId AND name = :name")
     public abstract Option loadSync(long profileId, String name);
+
+    @Query("SELECT * FROM options WHERE profile_id = :profileId")
+    public abstract List<Option> allForProfileSync(long profileId);
 }