db.sql.api.impl.cmd.dbFun.mysql.JsonContains Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of mybatis-mp-sql-api-impl Show documentation

There is a newer version: 1.7.6-RC2

Show newest version

package db.sql.api.impl.cmd.dbFun.mysql;

import db.sql.api.Cmd;
import db.sql.api.SqlBuilderContext;
import db.sql.api.impl.cmd.dbFun.BasicFunction;
import db.sql.api.impl.tookit.SqlConst;

import java.io.Serializable;

public class JsonContains extends BasicFunction {

    private final Serializable containValue;

    private final String path;

    public JsonContains(Cmd key, Serializable containValue) {
        this(key, containValue, null);
    }


    public JsonContains(Cmd key, Serializable containValue, String path) {
        super(SqlConst.JSON_CONTAINS, key);
        this.containValue = containValue;
        this.path = path;
    }

    @Override
    public StringBuilder functionSql(Cmd module, Cmd parent, SqlBuilderContext context, StringBuilder sqlBuilder) {
        sqlBuilder.append(operator).append(SqlConst.BRACKET_LEFT);
        ;
        this.key.sql(module, this, context, sqlBuilder);
        sqlBuilder.append(SqlConst.DELIMITER);
        if (containValue instanceof Number) {
            sqlBuilder.append(SqlConst.SINGLE_QUOT);
            sqlBuilder.append(containValue);
            sqlBuilder.append(SqlConst.SINGLE_QUOT);
        } else {
            new JsonQuote(containValue).sql(module, this, context, sqlBuilder);
        }

        if (path != null) {
            sqlBuilder.append(SqlConst.DELIMITER);
            sqlBuilder.append(SqlConst.SINGLE_QUOT);
            sqlBuilder.append(path);
            sqlBuilder.append(SqlConst.SINGLE_QUOT);
        }
        sqlBuilder.append(SqlConst.BRACKET_RIGHT);
        return sqlBuilder;
    }
}