Package com.saperion.query.fulltext

Class ContainsClauseConverterMSSQL

java.lang.Object

com.saperion.query.fulltext.ContainsClauseConverterMSSQL

public class ContainsClauseConverterMSSQL
extends 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, Map<String,String> fromEntityNames, String statement)	Creates the instance of the Util class ConvertJCRFullText2SQL.

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Details

ContainsClauseConverterMSSQL

public ContainsClauseConverterMSSQL(DDC definition,
 Map<String,String> fromEntityNames,
 String statement)

Creates the instance of the Util class ConvertJCRFullText2SQL.

Parameters:

definition -

fromEntityNames -

statement -

Method Details

containsToSQL

public String containsToSQL()
                     throws 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:

Exception - exception by the converting the contains clause to sql

fullTextContainsClauseConverter

protected String fullTextContainsClauseConverter(String incomingQuery)
                                          throws SaRMISystemException

Converts the fulltext clause.

Parameters:

incomingQuery - Incomming query

Returns:

Converted query

Throws:

SaRMISystemException - exception raised at converting the contains clause

convertColumnNames

protected String convertColumnNames(String incomingQuery)
                             throws SaRMISystemException

Throws:

SaRMISystemException

modifyColumnName

protected String modifyColumnName(String containsSubstring)