Package com.firebolt.jdbc.statement

Class StatementUtil

java.lang.Object
com.firebolt.jdbc.statement.StatementUtil
public class StatementUtil extends Object

  • Constructor Details

    • StatementUtil

      public StatementUtil()

  • Method Details

    • isQuery

      public static boolean isQuery(String cleanSql)
      Returns true if the statement is a query (eg: SELECT, SHOW).
      Parameters:
      cleanSql - the clean sql (sql statement without comments)
      Returns:
      true if the statement is a query (eg: SELECT, SHOW).

    • extractParamFromSetStatement

      public Optional<Map.Entry<String,String>> extractParamFromSetStatement(@NonNull @NonNull String cleanSql, String sql)
      Extracts parameter from statement (eg: SET x=y)
      Parameters:
      cleanSql - the clean version of the sql (sql statement without comments)
      sql - the sql statement
      Returns:
      an optional parameter represented with a pair of key/value

    • parseToStatementInfoWrappers

      public List<StatementInfoWrapper> parseToStatementInfoWrappers(String sql)
      Parse the sql statement to a list of StatementInfoWrapper
      Parameters:
      sql - the sql statement
      Returns:
      a list of StatementInfoWrapper

    • parseToRawStatementWrapperNative

      public RawStatementWrapper parseToRawStatementWrapperNative(String sql)
      Parse sql statement to a RawStatementWrapper. The method construct the RawStatementWrapper by splitting it in a list of sub-statements (supports multi-statements)
      Parameters:
      sql - the sql statement
      Returns:
      a list of StatementInfoWrapper

    • parseToRawStatementWrapper

      public RawStatementWrapper parseToRawStatementWrapper(String sql, PreparedStatementParamStyle paramStyle)

    • getParamMarketsPositions

      public Map<Integer,Integer> getParamMarketsPositions(String sql, PreparedStatementParamStyle paramStyle)
      Returns the positions of the params markers
      Parameters:
      sql - the sql statement
      Returns:
      the positions of the params markers

    • getParamMarketsPositionsNative

      public Map<Integer,Integer> getParamMarketsPositionsNative(String sql)

    • extractDbNameAndTableNamePairFromCleanQuery

      public Map.Entry<Optional<String>,Optional<String>> extractDbNameAndTableNamePairFromCleanQuery(String cleanSql)
      Extract the database name and the table name from the cleaned sql query
      Parameters:
      cleanSql - the clean sql query
      Returns:
      the database name and the table name from the sql query as a pair

    • replaceParameterMarksWithValues

      public static List<StatementInfoWrapper> replaceParameterMarksWithValues(@NonNull @NonNull Map<Integer,Object> params, @NonNull @NonNull String sql)
      Returns a list of StatementInfoWrapper containing sql statements constructed with the sql statement and the parameters provided
      Parameters:
      params - the parameters
      sql - the sql statement
      Returns:
      a list of sql statements containing the provided parameters

    • replaceParameterMarksWithValues

      public List<StatementInfoWrapper> replaceParameterMarksWithValues(@NonNull @NonNull Map<Integer,Object> params, @NonNull @NonNull RawStatementWrapper rawStatement)
      Returns a list of StatementInfoWrapper containing sql statements constructed with the RawStatementWrapper and the parameters provided
      Parameters:
      params - the parameters
      rawStatement - the rawStatement
      Returns:
      a list of sql statements containing the provided parameters

    • prepareFbNumericStatement

      public static List<StatementInfoWrapper> prepareFbNumericStatement(@NonNull @NonNull Map<Integer,Object> params, @NonNull @NonNull RawStatementWrapper rawStatement)
      Returns a list of StatementInfoWrapper containing sql statements from the RawStatementWrapper with the parameters provided in the StatementInfoWrapper queryParameters String
      Parameters:
      params - the parameters
      rawStatement - the rawStatement
      Returns:
      a list of sql statements containing the provided parameters inside the queryParameters String