org.eclipse.opencert.webapp.reports/src/org/eclipse/opencert/webapp/reports/dao/BaseRequirementDAO.java

/*******************************************************************************
 * Copyright (c) 2016 Parasoft.
 *
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v2.0
 * which accompanies this distribution, and is available at
 * https://www.eclipse.org/org/documents/epl-2.0/EPL-2.0.html
 *
 * SPDX-License-Identifier: EPL-2.0
 *
 * Contributors:
 *   Janusz Studzizba - initial API and implementation
 *   Dariusz Oszczedlowski - initial API and implementation
 *   Magdalena Gniewek - initial API and implementation
 *   Michal Wlodarczyk - initial API and implementation
 *******************************************************************************/
package org.eclipse.opencert.webapp.reports.dao;

import java.util.ArrayList;
import java.util.List;

import org.eclipse.emf.cdo.transaction.CDOTransaction;
import org.eclipse.emf.cdo.view.CDOQuery;
import org.eclipse.opencert.apm.baseline.baseline.BaseRequirement;
import org.eclipse.opencert.storage.cdo.CDOStorageUtil;
import org.eclipse.opencert.storage.cdo.executors.HttpRequestDrivenInTransactionExecutor;
import org.springframework.stereotype.Component;

@Component
public class BaseRequirementDAO {
	
	public BaseRequirement getBaseRequirement(final long baseRequirementUid) 
	{
        final List<BaseRequirement> result = new ArrayList<BaseRequirement>();
        
        new HttpRequestDrivenInTransactionExecutor()
        {
            @Override
            public void executeInTransaction(CDOTransaction cdoTransaction)
            {
                String baseRequirementSQL = "select * from baseline_baserequirement where cdo_id = '" + baseRequirementUid + "'" + CDOStorageUtil.getMandatoryCDOQuerySuffix();
                CDOQuery baseRequirementQuery = cdoTransaction.createQuery("sql", baseRequirementSQL);
                
                result.addAll(baseRequirementQuery.getResult(BaseRequirement.class));         
            }
        }.executeReadOnlyOperation();
        
        if (result.isEmpty()) {
        	return null;
        }
        return result.get(0);
	}
	
}