WaskDatabaseManager

WaskDatabaseManager

Table

• replacement_histories

Colum

replacement_histories

• replacement_histories_id(INT) : auto update
• replace_date(STRING) : YYYY-MM-DD 형태의 교체 날짜
• replace_date_month(INT) : MM에 해당하는 "월" 정보의 정수 값

Repoitory

• public void getAll(LoadHistoriesCallback callback) : 모든 레코드 읽어오기
• public void getAll(int month, LoadHistoryCallback callback) : 입력한 월에 해당하는 레코드 읽어오기
• public void get(String date, GetHistoriesCallback callback) : 입력한 날짜에 해당하는 레코드 읽어오기
• public void insert(ReplacementHistoryEntity newReplacementHistory) : 전체 레코드 입력
• public void insert(String date) : 날짜만 입력
• public void delete(ReplacementHistoryEntity deleteReplacementHistory) : 특정 레코드 삭제
• public void delete(String date) : 특정 날짜를 가진 레코드를 삭제
• public void deleteAll() : 모든 레코드 삭제
• public void update(ReplacementHistoryEntity updatedReplacementHistory) : 특정 레코드 업데이트

Callback

public interface LoadHistoriesCallback {

    void onHistoriesLoaded(List<ReplacementHistory> histories);

    void onDataNotAvailable();
}

public interface GetHistoryCallback {

    void onTaskLoaded(ReplacementHistory history);

    void onDataNotAvailable();
}

Test

code

ReplacementHistoryRepository.LoadHistoriesCallback callback = new ReplacementHistoryRepository.LoadHistoriesCallback() {
            @Override
            public void onHistoriesLoaded(List<ReplacementHistory> histories) {
                Log.d(TAG, "onHistoriesLoaded: " + histories);
            }

            @Override
            public void onDataNotAvailable() {
                Log.d(TAG, "onHistoriesLoaded: data is null");
            }
        };

        replacementHistoryRepository = new ReplacementHistoryRepository(this);
        replacementHistoryRepository.deleteAll();
        replacementHistoryRepository.getAll(callback);
        replacementHistoryRepository.insert("2020-08-01");
        replacementHistoryRepository.insert("2020-08-22");
        replacementHistoryRepository.insert("2020-08-14");
        replacementHistoryRepository.insert("2020-08-12");
        replacementHistoryRepository.getAll(callback);
        replacementHistoryRepository.deleteAll();
        replacementHistoryRepository.insert("2020-08-14");
        replacementHistoryRepository.insert("2020-08-12");
        replacementHistoryRepository.delete("2020-08-12");
        replacementHistoryRepository.get("2020-08-14", new ReplacementHistoryRepository.GetHistoryCallback() {

            @Override
            public void onTaskLoaded(ReplacementHistory history) {
                history.setMonthOfReplaceDate(9);
                 replacementHistoryRepository.update(history);
                 replacementHistoryRepository.getAll(callback);
            }

            @Override
            public void onDataNotAvailable() {
                Log.d(TAG, "onDataNotAvailable: data is null");
            }
        });

result