All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.arcadedb.query.sql.method.string.SQLMethodFormat Maven / Gradle / Ivy

There is a newer version: 24.11.1
Show newest version
/*
 * Copyright © 2021-present Arcade Data Ltd ([email protected])
 *
 * 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.
 *
 * SPDX-FileCopyrightText: 2021-present Arcade Data Ltd ([email protected])
 * SPDX-License-Identifier: Apache-2.0
 */
package com.arcadedb.query.sql.method.string;

import com.arcadedb.database.Identifiable;
import com.arcadedb.query.sql.executor.CommandContext;
import com.arcadedb.query.sql.executor.MultiValue;
import com.arcadedb.query.sql.method.AbstractSQLMethod;
import com.arcadedb.utility.DateUtils;

import java.util.*;

/**
 * @author Johann Sorel (Geomatys)
 * @author Luca Garulli (l.garulli--(at)--gmail.com)
 */
public class SQLMethodFormat extends AbstractSQLMethod {

  public static final String NAME = "format";

  public SQLMethodFormat() {
    super(NAME, 1, 2);
  }

  @Override
  public Object execute(final Object iThis, final Identifiable iRecord, final CommandContext iContext, Object ioResult, final Object[] iParams) {

    // TRY TO RESOLVE AS DYNAMIC VALUE
    String format = (String) getParameterValue(iRecord, iParams[0].toString());
    if (format == null)
      // USE STATIC ONE
      format = iParams[0].toString();

    if (format == null)
      throw new IllegalArgumentException("Format was null");

    if (isCollectionOfDates(ioResult)) {
      final List result = new ArrayList();
      final Iterator iterator = MultiValue.getMultiValueIterator(ioResult);

      while (iterator.hasNext())
        result.add(DateUtils.format(iterator.next(), format));

      return result;

    } else if (DateUtils.isDate(ioResult)) {
      return DateUtils.format(ioResult, format);
    }
    return ioResult != null ? String.format(format, ioResult) : null;
  }

  private boolean isCollectionOfDates(final Object ioResult) {
    if (MultiValue.isMultiValue(ioResult)) {
      final Iterator iterator = MultiValue.getMultiValueIterator(ioResult);
      while (iterator.hasNext()) {
        final Object item = iterator.next();
        if (item != null && !DateUtils.isDate(item)) {
          return false;
        }
      }
      return true;
    }
    return false;
  }
}