JooqChainProcessRepository.java

/*
 *    Constellation - An open source and standard compliant SDI
 *    http://www.constellation-sdi.org
 *
 * Copyright 2014 Geomatys.
 *
 * 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
 *
 *      http://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.constellation.database.impl.repository;

import static org.constellation.database.api.jooq.Tables.CHAIN_PROCESS;

import java.util.List;

import org.constellation.database.api.jooq.tables.pojos.ChainProcess;
import org.constellation.database.api.jooq.tables.records.ChainProcessRecord;
import org.constellation.database.api.repository.ChainProcessRepository;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author Guilhem Legal (Geomatys)
 */
@Component

public class JooqChainProcessRepository extends AbstractJooqRespository<ChainProcessRecord, ChainProcess> implements ChainProcessRepository {
    
    public JooqChainProcessRepository() {
        super(ChainProcess.class, CHAIN_PROCESS);
    }
    
    public List<ChainProcess> findAll() {
        return dsl.select().from(CHAIN_PROCESS).fetchInto(ChainProcess.class);
    }

    @Override
    @Transactional(propagation = Propagation.MANDATORY)
    public ChainProcess create(ChainProcess chain) {
        ChainProcessRecord newRecord = dsl.newRecord(CHAIN_PROCESS);
        newRecord.from(chain);
        newRecord.store();
        return newRecord.into(ChainProcess.class);
    }

    @Override
    @Transactional(propagation = Propagation.MANDATORY)
    public int delete(int id) {
        return dsl.delete(CHAIN_PROCESS).where(CHAIN_PROCESS.ID.eq(id)).execute();
    }

    @Override
    @Transactional(propagation = Propagation.MANDATORY)
    public int delete(String auth, String code) {
        return dsl.delete(CHAIN_PROCESS).where(CHAIN_PROCESS.AUTH.eq(auth)).and(CHAIN_PROCESS.CODE.eq(code)).execute();
    }

    @Override
    public ChainProcess findOne(String auth, String code) {
        return dsl.select().from(CHAIN_PROCESS).where(CHAIN_PROCESS.AUTH.eq(auth)).and(CHAIN_PROCESS.CODE.eq(code)).fetchOneInto(ChainProcess.class);
    }
}