X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fjava%2Fnet%2Fktnx%2Fmobileledger%2Fdao%2FPatternHeaderDAO.java;h=b4713d32f343e2a320a0dd08fd79cfe834878ee4;hb=d95839304defead7c7d605cab2e612f1227cbfed;hp=40659b5b4fa5d765bd66a569d29940981100576f;hpb=ac02090e6042d34afc00e2dde45e70f49e2dbedc;p=mobile-ledger.git

diff --git a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
index 40659b5b..b4713d32 100644
--- a/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
+++ b/app/src/main/java/net/ktnx/mobileledger/dao/PatternHeaderDAO.java
@@ -21,33 +21,33 @@ import androidx.lifecycle.LiveData;
 import androidx.room.Dao;
 import androidx.room.Delete;
 import androidx.room.Insert;
-import androidx.room.OnConflictStrategy;
 import androidx.room.Query;
+import androidx.room.Transaction;
 import androidx.room.Update;
 
-import net.ktnx.mobileledger.db.PatternHeader;
+import net.ktnx.mobileledger.db.PatternWithAccounts;
+import net.ktnx.mobileledger.db.TemplateHeader;
 
 import java.util.List;
 
 @Dao
 public interface PatternHeaderDAO {
-    @Insert(onConflict = OnConflictStrategy.REPLACE)
-    long insert(PatternHeader item);
+    @Insert()
+    long insert(TemplateHeader item);
 
     @Update
-    void update(PatternHeader... items);
+    void update(TemplateHeader... items);
 
     @Delete
-    void delete(PatternHeader item);
+    void delete(TemplateHeader item);
 
-    @Query("SELECT * FROM patterns")
-    LiveData<List<PatternHeader>> getPatterns();
+    @Query("SELECT * FROM patterns ORDER BY UPPER(name)")
+    LiveData<List<TemplateHeader>> getPatterns();
 
     @Query("SELECT * FROM patterns WHERE id = :id")
-    LiveData<PatternHeader> getPattern(Long id);
+    LiveData<TemplateHeader> getPattern(Long id);
 
-//    not useful for now
-//    @Transaction
-//    @Query("SELECT * FROM patterns")
-//    List<PatternWithAccounts> getPatternsWithAccounts();
+    @Transaction
+    @Query("SELECT * FROM patterns WHERE id = :id")
+    LiveData<PatternWithAccounts> getPatternWithAccounts(Long id);
 }