io.github.sinri.keel.mysql.statement.templated.TemplatedStatement 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.templated;

import javax.annotation.Nonnull;
import java.io.IOException;
import java.util.concurrent.atomic.AtomicReference;
import java.util.regex.Matcher;

import static io.github.sinri.keel.helper.KeelHelpersInterface.KeelHelpers;

/**
 * @since 3.0.8 Technical Preview
 */
public interface TemplatedStatement {
    static TemplatedReadStatement loadTemplateToRead(@Nonnull String templatePath) {
        try {
            byte[] bytes = KeelHelpers.fileHelper().readFileAsByteArray(templatePath, true);
            String sqlTemplate = new String(bytes);
            return new TemplatedReadStatement(sqlTemplate);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    static TemplatedModifyStatement loadTemplateToModify(@Nonnull String templatePath) {
        try {
            byte[] bytes = KeelHelpers.fileHelper().readFileAsByteArray(templatePath, true);
            String sqlTemplate = new String(bytes);
            return new TemplatedModifyStatement(sqlTemplate);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    String getSqlTemplate();

    TemplateArgumentMapping getArguments();

    default String build() {
        AtomicReference sqlRef = new AtomicReference<>(getSqlTemplate());

        getArguments().forEach((argumentName, argumentValue) -> {
            String s = sqlRef.get().replaceAll("\\{" + argumentName + "\\}", Matcher.quoteReplacement(argumentValue.toString()));
            sqlRef.set(s);
        });

        return sqlRef.get();
    }
}