db.sql.api.impl.cmd.dbFun.Weekday 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;

import db.sql.api.Cmd;
import db.sql.api.DbType;
import db.sql.api.SqlBuilderContext;
import db.sql.api.impl.tookit.SqlConst;

import java.time.LocalDate;

public class Weekday extends BasicFunction {
    public Weekday(Cmd key) {
        super(null, key);
    }

    public static void main(String[] args) {
        System.out.println(LocalDate.parse("2023-10-11").getDayOfWeek().getValue());
    }

    @Override
    public StringBuilder functionSql(Cmd module, Cmd parent, SqlBuilderContext context, StringBuilder sqlBuilder) {
        sqlBuilder.append(SqlConst.WEEKDAY(context.getDbType()));
        if (context.getDbType() != DbType.SQL_SERVER) {
            sqlBuilder.append(SqlConst.BRACKET_LEFT);
        }

        this.key.sql(module, this, context, sqlBuilder);
        if (context.getDbType() == DbType.ORACLE || context.getDbType() == DbType.PGSQL || context.getDbType() == DbType.KING_BASE) {
            sqlBuilder.append(SqlConst.DELIMITER).append(" 'D'");
        }
        sqlBuilder.append(SqlConst.BRACKET_RIGHT);
        return sqlBuilder;
    }
}