org.ehrbase.dao.access.jooq.CompositionHistoryAccess Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of service Show documentation
There is a newer version: 2.12.0
/*
 * Copyright (c) 2019 vitasystems GmbH and Hannover Medical School.
 *
 * This file is part of project EHRbase
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.ehrbase.dao.access.jooq;

import static org.ehrbase.jooq.pg.Tables.COMPOSITION_HISTORY;

import java.sql.Timestamp;
import java.time.OffsetDateTime;
import java.util.AbstractMap;
import java.util.UUID;
import org.ehrbase.dao.access.interfaces.I_CompositionHistoryAccess;
import org.ehrbase.dao.access.interfaces.I_DomainAccess;
import org.ehrbase.dao.access.support.DataAccess;
import org.ehrbase.dao.access.util.TransactionTime;
import org.ehrbase.jooq.pg.tables.records.CompositionHistoryRecord;
import org.jooq.Condition;
import org.jooq.Result;

/**
 * Stripped down DAO to perform some `*_history` table related actions. Composition access handling in general is
 * done through the {@link CompositionAccess} class.
 */
public class CompositionHistoryAccess extends DataAccess implements I_CompositionHistoryAccess {

    private CompositionHistoryRecord record;

    public CompositionHistoryAccess(I_DomainAccess domainAccess, Short sysTenant) {
        super(domainAccess);
        this.record = domainAccess.getContext().newRecord(COMPOSITION_HISTORY);
        this.record.setSysTenant(sysTenant);
    }

    @Override
    public DataAccess getDataAccess() {
        return this;
    }

    @Override
    public UUID commit(Timestamp transactionTime) {
        record.setSysTransaction(transactionTime);
        return commit();
    }

    @Override
    public UUID commit() {
        if (this.record.getSysTransaction() == null) {
            this.record.setSysTransaction(TransactionTime.millis());
            this.record.setSysPeriod(new AbstractMap.SimpleEntry<>(OffsetDateTime.now(), null));
        }
        if (record.insert() == 1) return record.getId();
        else return null;
    }

    @Override
    public Boolean update(Timestamp transactionTime) {
        return null; // TODO
    }

    @Override
    public Boolean update(Timestamp transactionTime, boolean force) {
        return null; // TODO
    }

    @Override
    public Boolean update() {

        // manually constructing an update query, because _history tables aren't of type UpdatableRecord, because table
        // has no PK
        // two conditions: same ID and timestamp
        int num = this.getContext()
                .update(COMPOSITION_HISTORY)
                .set(this.record)
                .where(COMPOSITION_HISTORY
                        .ID
                        .eq(this.record.getId())
                        .and(COMPOSITION_HISTORY.SYS_TRANSACTION.eq(this.record.getSysTransaction())))
                .execute();

        return num >= 1;
    }

    @Override
    public Boolean update(Boolean force) {
        return null; // TODO
    }

    @Override
    public Integer delete() {
        Condition condition = COMPOSITION_HISTORY
                .ID
                .eq(record.getId())
                .and(COMPOSITION_HISTORY.SYS_TRANSACTION.eq(record.getSysTransaction()));

        return getContext().delete(COMPOSITION_HISTORY).where(condition).execute();
    }

    public static I_CompositionHistoryAccess retrieveByVersion(
            I_DomainAccess domainAccess, UUID compositionId, int version) {
        return retrieveByIdx(domainAccess, compositionId, version);
    }

    public static I_CompositionHistoryAccess retrieveLatest(I_DomainAccess domainAccess, UUID compositionId) {
        return retrieveByIdx(domainAccess, compositionId, 0);
    }

    private static I_CompositionHistoryAccess retrieveByIdx(I_DomainAccess domainAccess, UUID compositionId, int idx) {
        Result historyRecordsRes = domainAccess
                .getContext()
                .selectFrom(COMPOSITION_HISTORY)
                .where(COMPOSITION_HISTORY.ID.eq(compositionId))
                .orderBy(
                        idx == 0
                                ? COMPOSITION_HISTORY.SYS_TRANSACTION.desc()
                                : COMPOSITION_HISTORY.SYS_TRANSACTION.asc())
                .fetch();

        if (historyRecordsRes.isEmpty()) return null;

        CompositionHistoryRecord rec = historyRecordsRes.get(idx == 0 ? idx : idx - 1);

        I_CompositionHistoryAccess historyAccess = new CompositionHistoryAccess(domainAccess, rec.getSysTenant());
        historyAccess.setRecord(rec);
        return historyAccess;
    }

    @Override
    public void setRecord(CompositionHistoryRecord record) {
        this.record = record;
    }

    @Override
    public CompositionHistoryRecord getRecord() {
        return this.record;
    }

    @Override
    public void setInContribution(UUID contribution) {
        this.record.setInContribution(contribution);
    }

    @Override
    public void setHasAudit(UUID audit) {
        this.record.setHasAudit(audit);
    }

    @Override
    public Timestamp getSysTransaction() {
        return record == null ? null : record.getSysTransaction();
    }

    @Override
    public UUID getContributionId() {
        return record == null ? null : record.getInContribution();
    }

    @Override
    public UUID getId() {
        return record == null ? null : record.getId();
    }
}