org.kawanfw.sql.api.util.StatementAnalyzerUtil Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aceql-http Show documentation

AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http. AceQL HTTP is provided with four client SDK: - The AceQL C# Client SDK allows to wrap the HTTP APIs using Microsoft SQL Server like calls in their code, just like they would for a local database. - The AceQL Java Client SDK allows to wrap the HTTP APIs using JDBC calls in their code, just like they would for a local database. - The AceQL Python Client SDK allows SQL calls to be encoded with standard unmodified DB-API 2.0 syntax

There is a newer version: 12.2

Show newest version

/*
 * Copyright (c)2022 KawanSoft S.A.S. All rights reserved.
 * 
 * Use of this software is governed by the Business Source License included
 * in the LICENSE.TXT file in the project's root directory.
 *
 * Change Date: 2026-11-01
 *
 * On the date above, in accordance with the Business Source License, use
 * of this software will be governed by version 2.0 of the Apache License.
 */
package org.kawanfw.sql.api.util;
/**
 * @author Nicolas de Pomereu
 *
 */

public class StatementAnalyzerUtil {

    /**
     * Replace fulltext with _fulltext_ because of a bug in JSQLParser.
     * @param sql	the sql query
     * @return	the sql query with fulltext replaced by _fulltext_ and FULLTEXT replaced by _FULLTEXT_
     */
    public static String fixForJsqlparser(final String sql) {

	if (sql == null) {
	    return null;
	}

	String theSql = sql;
	if (theSql.contains(" fulltext")) {
	    theSql = theSql.replace(" fulltext", " _fulltext_");
	}
	if (theSql.contains(" FULLTEXT")) {
	    theSql = theSql.replace(" FULLTEXT", " _FULLTEXT_");
	}
	if (theSql.contains("fulltext ")) {
	    theSql = theSql.replace("fulltext ", "_fulltext_ ");
	}
	if (theSql.contains("FULLTEXT ")) {
	    theSql = theSql.replace("FULLTEXT ", "_FULLTEXT_ ");
	}
	
	return theSql;
    }

}