internal.spreadsheet.base.api.legacy.LegacySpreadSheetMoniker Maven / Gradle / Ivy

Go to download
/*
 * Copyright 2017 National Bank of Belgium
 *
 * Licensed under the EUPL, Version 1.1 or - as soon they will be approved
 * by the European Commission - subsequent versions of the EUPL (the "Licence");
 * You may not use this work except in compliance with the Licence.
 * You may obtain a copy of the Licence at:
 *
 * http://ec.europa.eu/idabc/eupl
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the Licence is distributed on an "AS IS" basis,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the Licence for the specific language governing permissions and
 * limitations under the Licence.
 */
package internal.spreadsheet.base.api.legacy;

import jdplus.toolkit.base.api.design.DemetraPlusLegacy;
import internal.spreadsheet.base.api.SpreadSheetParam;
import jdplus.spreadsheet.base.api.SpreadSheetBean;
import jdplus.toolkit.base.api.timeseries.TsMoniker;
import jdplus.toolkit.base.tsp.DataSet;
import jdplus.toolkit.base.tsp.DataSource;
import jdplus.toolkit.base.tsp.HasDataMoniker;
import jdplus.toolkit.base.tsp.legacy.LegacyFileId;
import jdplus.toolkit.base.tsp.util.DataSourcePreconditions;
import lombok.NonNull;

import java.io.File;
import java.util.Optional;

/**
 * @author Philippe Charles
 */
@DemetraPlusLegacy
@lombok.AllArgsConstructor(staticName = "of")
public final class LegacySpreadSheetMoniker implements HasDataMoniker {

    private final String providerName;
    private final SpreadSheetParam param;

    @Override
    public @NonNull TsMoniker toMoniker(@NonNull DataSource dataSource) throws IllegalArgumentException {
        DataSourcePreconditions.checkProvider(providerName, dataSource);
        throw new IllegalArgumentException("Not supported yet.");
    }

    @Override
    public @NonNull TsMoniker toMoniker(@NonNull DataSet dataSet) throws IllegalArgumentException {
        DataSourcePreconditions.checkProvider(providerName, dataSet);
        throw new IllegalArgumentException("Not supported yet.");
    }

    @Override
    public @NonNull Optional toDataSource(@NonNull TsMoniker moniker) throws IllegalArgumentException {
        DataSourcePreconditions.checkProvider(providerName, moniker);

        LegacyFileId id = LegacyFileId.parse(moniker.getId());
        return id != null ? Optional.of(toDataSource(new File(id.getFile()))) : Optional.empty();
    }

    @Override
    public @NonNull Optional toDataSet(@NonNull TsMoniker moniker) throws IllegalArgumentException {
        DataSourcePreconditions.checkProvider(providerName, moniker);

        LegacySpreadSheetId id = LegacySpreadSheetId.parse(moniker.getId());
        return id != null ? Optional.of(toDataSet(id)) : Optional.empty();
    }

    private DataSet toDataSet(LegacySpreadSheetId id) {
        DataSource source = toDataSource(new File(id.getFile()));
        if (id.isCollection()) {
            DataSet.Builder result = DataSet.builder(source, DataSet.Kind.COLLECTION);
            param.getSheetParam().set(result, cleanSheetName(id.getSheetName()));
            return result.build();
        }
        if (id.isSeriesByIndex()) {
            // not supported
            return null;
        }
        DataSet.Builder result = DataSet.builder(source, DataSet.Kind.SERIES);
        param.getSheetParam().set(result, cleanSheetName(id.getSheetName()));
        param.getSeriesParam().set(result, id.getSeriesName());
        return result.build();
    }

    private DataSource toDataSource(File file) {
        SpreadSheetBean bean = new SpreadSheetBean();
        bean.setFile(file);
        DataSource.Builder result = DataSource.builder(providerName, param.getVersion());
        param.set(result, bean);
        return result.build();
    }

    private static String cleanSheetName(String name) {
        // probably we should change the CharSet, but it is not very clear how and which one
        int l = name.lastIndexOf('$');
        if (l < 0) {
            return name;
        }
        name = name.substring(0, l);
        if (name.charAt(0) == '\'') {
            name = name.substring(1);
        }
        return name.replace('#', '.');
    }
}