/* * The MIT License (MIT) * * Copyright (C) 2018-2019 Fabricio Barros Cabral * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to deal * in the Software without restriction, including without limitation the rights * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell * copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included * in all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE * SOFTWARE. */ package com.github.fabriciofx.cactoos.jdbc.sql; import com.github.fabriciofx.cactoos.jdbc.Param; import com.github.fabriciofx.cactoos.jdbc.Params; import com.github.fabriciofx.cactoos.jdbc.params.ParamsNamed; import java.util.LinkedList; import java.util.List; import java.util.regex.Matcher; import java.util.regex.Pattern; import org.cactoos.Scalar; import org.cactoos.Text; import org.cactoos.scalar.Sticky; import org.cactoos.text.FormattedText; /** * Parse named parameters in the SQL. * * @since 0.1 */ public final class SqlParsed implements Text { /** * SQL query. */ private final Scalar<String> sql; /** * Ctor. * @param sql SQL query * @param params SQL query parameters */ public SqlParsed(final String sql, final Param... params) { this(() -> sql, new ParamsNamed(params)); } /** * Ctor. * @param sql SQL query * @param params SQL query parameters */ public SqlParsed(final Text sql, final Param... params) { this(sql, new ParamsNamed(params)); } /** * Ctor. * @param sql SQL query * @param params SQL query parameters */ public SqlParsed(final Text sql, final Params params) { this.sql = new Sticky<>( () -> { final String str = sql.asString(); final List<String> names = new LinkedList<>(); final Pattern find = Pattern.compile("(?<!')(:[\\w]*)(?!')"); final Matcher matcher = find.matcher(str); while (matcher.find()) { names.add(matcher.group().substring(1)); } for (int idx = 0; idx < names.size(); ++idx) { if (!params.contains(names.get(idx), idx)) { throw new IllegalArgumentException( new FormattedText( "SQL parameter #%d is wrong or out of order", idx + 1 ).asString() ); } } return str.replaceAll(find.pattern(), "?"); } ); } @Override public String asString() throws Exception { return this.sql.value(); } }