/*
 * Copyright (C) 2000 - 2026 Silverpeas
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * As a special exception to the terms and conditions of version 3.0 of
 * the GPL, you may redistribute this Program in connection with Free/Libre
 * Open Source Software ("FLOSS") applications as described in Silverpeas's
 * FLOSS exception.  You should have received a copy of the text describing
 * the FLOSS exception, and it is also available here:
 * "https://www.silverpeas.org/legal/floss_exception.html"
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */

package org.silverpeas.components.mydb.model;

import org.silverpeas.components.mydb.service.MyDBRuntimeException;
import org.silverpeas.kernel.util.StringUtil;

import java.math.BigDecimal;
import java.math.BigInteger;
import java.sql.Date;
import java.sql.JDBCType;
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Objects;

/**
 * The value of a field in a table row with its type (and associated type name) in the database.
 * @author mmoquillon
 */
public class TableFieldValue implements Comparable<TableFieldValue> {

  private Object value;
  private final int type;

  /**
   * Constructs a {@link TableFieldValue} instance from the specified value represented as a
   * {@link String} object and according to the specified SQL type (a value among
   * {@link java.sql.Types}). If the specified value
   * doesn't match the SQL type of this field value, then an {@link IllegalArgumentException}
   * exception is thrown.
   * @param value the {@link String} representation of a value. Null value shouldn't be null but the
   * String "null".
   * @param sqlType the SQL type as defined in {@link java.sql.Types}.
   * @return a {@link TableFieldValue} instance.
   */
  public static TableFieldValue fromString(final String value, int sqlType) {
    TableFieldValue tableFieldValue = new TableFieldValue(null, sqlType);
    tableFieldValue.update(value);
    return tableFieldValue;
  }

  /**
   * Constructs a new value of a field in a database table.
   * @see java.sql.Types for SQL type of the value.
   * @param value the value of the field
   * @param type the SQL type of the value
   */
  TableFieldValue(final Object value, final int type) {
    this.value = value;
    this.type = type;
  }

  /**
   * Gets the code of the SQL type of this value.
   * @see java.sql.Types for the available possible codes.
   * @return the SQL type of this value as defined in {@link java.sql.Types}.
   */
  public int getType() {
    return type;
  }

  /**
   * Is this value a text?
   * @return true if the type of this value is a text, false otherwise.
   */
  public boolean isText() {
    return SqlTypes.isText(this.type);
  }

  /**
   * Is this value an empty text?
   * @return true if this value is a text and it is empty. False otherwise.
   */
  public boolean isEmpty() {
    return isText() && toString().isEmpty();
  }

  /**
   * Updates this value with the textual representation of the new value. If the specified value
   * doesn't match the SQL type of this field value, then an {@link IllegalArgumentException}
   * exception is thrown.
   * @param value a {@link String} representation of the value. Null value shouldn't be null but the
   * String "null".
   */
  public void update(final String value) {
    if (value == null || value.equals("null")) {
      this.value = null;
    } else if (SqlTypes.isText(this.type)) {
      this.value = value;
    } else if (SqlTypes.isDate(this.type)) {
      try {
        this.value = Date.valueOf(value);
      } catch (IllegalArgumentException e) {
        throw new IllegalArgumentException("The date '" + value +
            "' is not in the database date escape format (yyyy-[m]m-[d]d)");
      }
    } else if (SqlTypes.isTime(this.type)) {
      this.value = Time.valueOf(value);
    } else if (SqlTypes.isTimestamp(this.type)) {
      this.value = Timestamp.valueOf(value);
    } else if (SqlTypes.isBoolean(this.type)) {
      this.value = StringUtil.getBooleanValue(value);
    } else if (SqlTypes.isBigInteger(this.type)) {
      this.value = BigInteger.valueOf(Long.parseLong(value));
    } else if (SqlTypes.isDecimal(this.type)) {
      this.value = BigDecimal.valueOf(Double.parseDouble(value));
    } else if (SqlTypes.isInteger(this.type)) {
      this.value = Integer.valueOf(value);
    } else if (SqlTypes.isFloat(this.type)) {
      this.value = Float.valueOf(value);
    } else if (SqlTypes.isDouble(this.type)) {
      this.value = Double.valueOf(value);
    }
  }

  @Override
  public boolean equals(final Object o) {
    if (this == o) {
      return true;
    }
    if (o == null || getClass() != o.getClass()) {
      return false;
    }
    final TableFieldValue that = (TableFieldValue) o;
    return Objects.equals(value, that.value) && Objects.equals(type, that.type);
  }

  @Override
  public int hashCode() {
    return Objects.hash(value, type);
  }

  /**
   * Compares this {@link TableFieldValue} with the specified one. The comparing is actually done
   * on the wrapped values themselves. If the wrapped values satisfy the {@link Comparable}
   * interface then the {@link Comparable#compareTo(Object)} method is used, otherwise both of them
   * are converted in {@link String} objects and these {@link String} instances are then compared
   * between themselves.
   * @param o another {@link TableFieldValue} with which this one is compared.
   * @return the comparing distance between the two {@link TableFieldValue} instances.
   */
  @Override
  public int compareTo(final TableFieldValue o) {
    if (this.type != o.type) {
      final String typeName = JDBCType.valueOf(this.type).getName();
      throw new MyDBRuntimeException(
          "The two table field values aren't of the same type: this is of type " + typeName +
              " whereas other if of type " + typeName);
    }
    final int compare;
    if (o.value == null && this.value == null) {
      compare = 0;
    } else if (o.value != null && this.value instanceof Comparable) {
      //noinspection unchecked,rawtypes
      compare = ((Comparable) this.value).compareTo(o.value);
    } else if (o.value == null) {
      return 1;
    } else if (this.value == null) {
      return -1;
    } else {
      compare = toString().compareTo(o.toString());
    }
    return compare;
  }

  /**
   * Converts this table field value to an SQL object as defined by its SQL type.
   * @return this value as an SQL object.
   */
  Object toSQLObject() {
    return value;
  }

  @Override
  public String toString() {
    return value == null ? "null" : value.toString();
  }

  public TableFieldValue getCopy() {
    return new TableFieldValue(value, type);
  }
}
