001/*
002 *  Copyright 2019 Anyware Services
003 *
004 *  Licensed under the Apache License, Version 2.0 (the "License");
005 *  you may not use this file except in compliance with the License.
006 *  You may obtain a copy of the License at
007 *
008 *      http://www.apache.org/licenses/LICENSE-2.0
009 *
010 *  Unless required by applicable law or agreed to in writing, software
011 *  distributed under the License is distributed on an "AS IS" BASIS,
012 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013 *  See the License for the specific language governing permissions and
014 *  limitations under the License.
015 */
016package org.ametys.odf.ose.db.column;
017
018import java.sql.Types;
019import java.util.ArrayList;
020import java.util.List;
021
022import org.ametys.odf.ose.db.parameter.ValuedQueryParameter;
023import org.ametys.runtime.config.Config;
024
025/**
026 * This column is only used in the SRC_* view to reference the right source from the SOURCE table.
027 */
028public class SourceIdColumn implements Column
029{
030    @Override
031    public String getColumnDescription()
032    {
033        return null;
034    }
035
036    @Override
037    public String getViewDescription()
038    {
039        return "(SELECT SRC.ID FROM SOURCE SRC WHERE SRC.CODE = :SOURCE_CODE) AS SOURCE_ID";
040    }
041
042    @Override
043    public List<ValuedQueryParameter> getViewParameters()
044    {
045        List<ValuedQueryParameter> parameters = new ArrayList<>();
046        parameters.add(new ValuedQueryParameter("SOURCE_CODE", Config.getInstance().getValue("ose.source.code"), Types.VARCHAR));
047        return parameters;
048    }
049}