Examples of org.hibernate.dialect.function.SQLFunction

org.hibernate.dialect.function.SQLFunction
Provides support routines for the HQL functions as used in the various SQL Dialects Provides an interface for supporting various HQL functions that are translated to SQL. The Dialect and its sub-classes use this interface to provide details required for processing of the function. @author David Channon


    cleanup();
  }


  public void testGetMultiColumnSameNameAsNoArgFunctionHQL() throws Exception {
    SQLFunction function =
        ( ( SessionFactoryImplementor ) getSessions() ).getSqlFunctionRegistry().findSQLFunction( "current_date" );
    if ( function == null || function.hasParenthesesIfNoArguments() ) {
      reportSkip( "current_date reuires ()", "tests noarg function that does not require ()" );
      return;
    }


    Session s = openSession();

View Full Code Here


    cleanup();
  }


  public void testGetMultiColumnSameNameAsNoArgFunctionCriteria() {
    SQLFunction function =
        ( ( SessionFactoryImplementor ) getSessions() ).getSqlFunctionRegistry().findSQLFunction( "current_date" );
    if ( function == null || function.hasParenthesesIfNoArguments() ) {
      reportSkip( "current_date reuires ()", "tests noarg function that does not require ()" );
      return;
    }


    Session s = openSession();

View Full Code Here


    cleanup();
  }


  public void testNoArgFcnAndColumnSameNameAsNoArgFunctionHQL() {
    SQLFunction function =
        ( ( SessionFactoryImplementor ) getSessions() ).getSqlFunctionRegistry().findSQLFunction( "current_date" );
    if ( function == null || function.hasParenthesesIfNoArguments() ) {
      reportSkip( "current_date reuires ()", "tests noarg function that does not require ()" );
      return;
    }


    Session s = openSession();

View Full Code Here

    }
  }


  protected void beginFunctionTemplate(AST m, AST i) {
    MethodNode methodNode = ( MethodNode ) m;
    SQLFunction template = methodNode.getSQLFunction();
    if ( template == null ) {
      // if template is null we just write the function out as it appears in the hql statement
      super.beginFunctionTemplate( m, i );
    }
    else {

View Full Code Here

    }
  }


  protected void endFunctionTemplate(AST m) {
    MethodNode methodNode = ( MethodNode ) m;
    SQLFunction template = methodNode.getSQLFunction();
    if ( template == null ) {
      super.endFunctionTemplate( m );
    }
    else {
      // this function has a template -> restore output, apply the template and write the result out
      FunctionArguments functionArguments = ( FunctionArguments ) writer;   // TODO: Downcast to avoid using an interface?  Yuck.
      writer = ( SqlWriter ) outputStack.removeFirst();
      out( template.render( functionArguments.getArgs(), sessionFactory ) );
    }
  }

View Full Code Here

    AST child = ast.getFirstChild();
    assert "{param list}".equals(  child.getText() );
    child = child.getFirstChild();


    final String functionName = ast.getText();
    final SQLFunction function = context.getSqlFunctionRegistry().findSQLFunction( functionName );
    if ( function == null ) {
      String text = functionName;
      if ( child != null ) {
        text += '(';
        while ( child != null ) {
          text += child.getText();
          child = child.getNextSibling();
          if ( child != null ) {
            text += ", ";
          }
        }
        text += ')';
      }
      return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, text );
    }
    else {
      ArrayList expressions = new ArrayList();
      while ( child != null ) {
        expressions.add( child.getText() );
        child = child.getNextSibling();
      }
      final String text = function.render( expressions, context.getSessionFactory() );
      return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, text );
    }
  }

View Full Code Here

    // checking for "(" is currently redundant because it is checked before getting here;
    // doing the check anyhow, in case that earlier check goes away;
    if ( "(".equals( nextToken ) ) {
      return true;
    }
    SQLFunction function = functionRegistry.findSQLFunction(lcToken);
    if ( function == null ) {
      // lcToken does not refer to a function
      return false;
    }
    // if function.hasParenthesesIfNoArguments() is true, then assume
    // lcToken is not a function (since it is not followed by '(')
    return ! function.hasParenthesesIfNoArguments();
  }

View Full Code Here

  @Override
    protected void beginFunctionTemplate(AST node, AST nameNode) {
    // NOTE for AGGREGATE both nodes are the same; for METHOD the first is the METHOD, the second is the
    //     METHOD_NAME
    FunctionNode functionNode = ( FunctionNode ) node;
    SQLFunction sqlFunction = functionNode.getSQLFunction();
    if ( sqlFunction == null ) {
      // if SQLFunction is null we just write the function out as it appears in the hql statement
      super.beginFunctionTemplate( node, nameNode );
    }
    else {

View Full Code Here

  }


  @Override
    protected void endFunctionTemplate(AST node) {
    FunctionNode functionNode = ( FunctionNode ) node;
    SQLFunction sqlFunction = functionNode.getSQLFunction();
    if ( sqlFunction == null ) {
      super.endFunctionTemplate( node );
    }
    else {
      final Type functionType = functionNode.getFirstArgumentType();
      // this function has a registered SQLFunction -> redirect output and catch the arguments
      FunctionArguments functionArguments = ( FunctionArguments ) writer;
      writer = outputStack.removeFirst();
      out( sqlFunction.render( functionType, functionArguments.getArgs(), sessionFactory ) );
    }
  }

View Full Code Here

   * @param functionName The name of the function to locate
   * @return The sql function.
   * @throws QueryException Indicates no matching sql functions could be found.
   */
  private SQLFunction requireSQLFunction(String functionName) {
    SQLFunction f = findSQLFunction( functionName );
    if ( f == null ) {
      throw new QueryException( "Unable to find SQL function: " + functionName );
    }
    return f;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hibernate.dialect.function.SQLFunction

org.hibernate.criterion.AggregateProjection

org.hibernate.criterion.RowCountProjection

org.hibernate.hql.ast.SqlGenerator

org.hibernate.hql.ast.tree.IdentNode

org.hibernate.hql.ast.util.SessionFactoryHelper

org.hibernate.hql.internal.ast.SqlGenerator

org.hibernate.hql.internal.ast.tree.IdentNode

org.hibernate.hql.internal.ast.util.SessionFactoryHelper

org.hibernate.sql.ordering.antlr.OrderByFragmentParser

org.hibernate.sql.Template

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.