io.github.sinri.keel.mysql.statement.component.IfOperator Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of Keel Show documentation

A website framework with VERT.X for ex-PHP-ers, exactly Ark Framework Users.

The newest version!

package io.github.sinri.keel.mysql.statement.component;

import io.github.sinri.keel.core.TechnicalPreview;
import io.github.sinri.keel.mysql.Quoter;

import javax.annotation.Nonnull;
import javax.annotation.Nullable;

/**
 * If expr1 is TRUE (expr1 is not equal to 0 and expr1 IS NOT NULL), IF() returns expr2. Otherwise, it returns expr3.
 * {@code IF(expr1,expr2,expr3) }
 *
 * @since 3.0.19
 */
@TechnicalPreview(since = "3.0.19")
public class IfOperator {
    private String conditionExpression;
    private String expressionForNonEmpty;
    private String expressionForEmpty;

    public IfOperator() {

    }

    public IfOperator setConditionNumber(@Nonnull Number conditionNumber) {
        this.conditionExpression = String.valueOf(conditionNumber);
        return this;
    }

    public IfOperator setConditionExpression(@Nonnull String conditionExpression) {
        this.conditionExpression = conditionExpression;
        return this;
    }

    public IfOperator setNumberForNonEmpty(@Nullable Number numberForNonEmpty) {
        this.expressionForNonEmpty = String.valueOf(numberForNonEmpty);
        return this;
    }

    public IfOperator setStringForNonEmpty(@Nullable String stringForNonEmpty) {
        this.expressionForNonEmpty = new Quoter(stringForNonEmpty).toString();
        return this;
    }

    public IfOperator setNullForNonEmpty() {
        this.expressionForNonEmpty = "null";
        return this;
    }

    public IfOperator setExpressionForNonEmpty(@Nonnull String expressionForNonEmpty) {
        this.expressionForNonEmpty = expressionForNonEmpty;
        return this;
    }

    public IfOperator setNumberForEmpty(@Nullable Number numberForEmpty) {
        this.expressionForEmpty = String.valueOf(numberForEmpty);
        return this;
    }

    public IfOperator setStringForEmpty(@Nullable String stringForEmpty) {
        this.expressionForEmpty = new Quoter(stringForEmpty).toString();
        return this;
    }

    public IfOperator setNullForEmpty() {
        this.expressionForEmpty = "null";
        return this;
    }

    public IfOperator setExpressionForEmpty(@Nonnull String expressionForEmpty) {
        this.expressionForEmpty = expressionForEmpty;
        return this;
    }

    @Override
    public String toString() {
        return "IF(" + conditionExpression + "," + expressionForNonEmpty + "," + expressionForEmpty + ")";
    }
}