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 ORDER BY UPPER(name) NULLS FIRST")
- 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);
}