/*
 * Copyright (C) 2013 Jan Pokorsky
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */
package cz.cas.lib.proarc.common.dao.empiredb;

import cz.cas.lib.proarc.common.dao.BatchItemDao;
import cz.cas.lib.proarc.common.dao.BatchItem;
import cz.cas.lib.proarc.common.dao.empiredb.ProarcDatabase.BatchItemTable;
import java.sql.Timestamp;
import java.util.Collections;
import java.util.List;
import org.apache.empire.data.bean.BeanResult;
import org.apache.empire.db.DBCommand;
import org.apache.empire.db.DBRecord;

/**
 *
 * @author Jan Pokorsky
 */
public class EmpireBatchItemDao extends EmpireDao implements BatchItemDao {

    private final BatchItemTable table;

    public EmpireBatchItemDao(ProarcDatabase db) {
        super(db);
        this.table = db.tableBatchItem;
    }

    @Override
    public BatchItem create() {
        return new BatchItem();
    }

    @Override
    public void update(BatchItem item) {
        DBRecord dbr = new DBRecord();
        try {
            if (item.getId() == null) {
                dbr.create(table);
                Timestamp now = new Timestamp(System.currentTimeMillis());
                item.setTimestamp(now);
            } else {
                dbr.read(table, item.getId(), getConnection());
            }
            dbr.setBeanValues(item);
            dbr.update(getConnection());
            dbr.getBeanProperties(item);
        } finally {
            dbr.close();
        }
    }

    @Override
    public BatchItem find(int id) {
        DBRecord dbr = new DBRecord();
        try {
            dbr.read(table, id, getConnection());
            BatchItem item = new BatchItem();
            dbr.getBeanProperties(item);
            return item;
        } finally {
            dbr.close();
        }
    }

    @Override
    public List<BatchItem> find(int batchId, String pid, String dsId, String state, String type) {
        BeanResult<BatchItem> result = new BeanResult<BatchItem>(BatchItem.class, table);
        DBCommand cmd = result.getCommand();
        cmd.where(table.batchId.is(batchId));
        if (pid != null) {
            cmd.where(table.pid.is(pid));
        }

        if (dsId != null) {
            cmd.where(table.dsId.is(dsId));
        }
        if (state != null) {
            cmd.where(table.state.is(state));
        }
        if (type != null) {
            cmd.where(table.type.is(type));
        }
        cmd.orderBy(table.timestamp);
        result.fetch(getConnection());
        return Collections.unmodifiableList(result);
    }

    @Override
    public void removeItems(int batchId) {
        DBCommand cmd = db.createCommand();
        cmd.where(table.batchId.is(batchId));
        db.executeDelete(table, cmd, getConnection());
    }

}