Package com.saperion.query.fulltext

Class ContainsClauseConverterMSSQL

  • public class ContainsClauseConverterMSSQL
extends java.lang.Object
    Util class that converts the given jcr query with a contains clause to SQL contains statement.


    In order to get the list of the SQL CONTAINS clauses, instantiate the ConvertJCRFullText2SQL instance with the jcr query string and call the containsToSQL() method;
    Author:
    lav

    • Constructor Summary

      Constructors 
      Constructor Description
      ContainsClauseConverterMSSQL​(DDC definition, java.util.Map<java.lang.String,​java.lang.String> fromEntityNames, java.lang.String statement)
      Creates the instance of the Util class ConvertJCRFullText2SQL.

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      java.lang.String containsToSQL()
      performs a convertion from the jcr's contains statement to the SQL CONTAINS statement.
      protected java.lang.String convertColumnNames​(java.lang.String incomingQuery)  
      protected java.lang.String fullTextContainsClauseConverter​(java.lang.String incomingQuery)
      Converts the fulltext clause.
      protected java.lang.String modifyColumnName​(java.lang.String containsSubstring)  

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • Constructor Detail

      • ContainsClauseConverterMSSQL

        public ContainsClauseConverterMSSQL​(DDC definition,
                                    java.util.Map<java.lang.String,​java.lang.String> fromEntityNames,
                                    java.lang.String statement)
        Creates the instance of the Util class ConvertJCRFullText2SQL.
        Parameters:
        definition -
        fromEntityNames -
        statement -

    • Method Detail

      • containsToSQL

        public java.lang.String containsToSQL()
                               throws java.lang.Exception
        performs a convertion from the jcr's contains statement to the SQL CONTAINS statement. (Works with java regular expressions).
        Returns:
        the SQL statement which has been translated from the incoming jcr query
        Throws:
        java.lang.Exception - exception by the converting the contains clause to sql

      • fullTextContainsClauseConverter

        protected java.lang.String fullTextContainsClauseConverter​(java.lang.String incomingQuery)
                                                    throws SaRMISystemException
        Converts the fulltext clause.
        Parameters:
        incomingQuery - Incomming query
        Returns:
        Converted query
        Throws:
        SaRMISystemException - exception raised at converting the contains clause

      • modifyColumnName

        protected java.lang.String modifyColumnName​(java.lang.String containsSubstring)