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 java.util.List;
@Dao
public interface PatternHeaderDAO {
- @Insert(onConflict = OnConflictStrategy.REPLACE)
+ @Insert()
long insert(PatternHeader item);
@Update
@Delete
void delete(PatternHeader item);
- @Query("SELECT * FROM patterns ORDER BY UPPER(name) NULLS FIRST")
+ @Query("SELECT * FROM patterns ORDER BY UPPER(name)")
LiveData<List<PatternHeader>> getPatterns();
@Query("SELECT * FROM patterns WHERE id = :id")
LiveData<PatternHeader> 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);
}