Examples of SQLFunction

org.apache.torque.util.functions.SQLFunction
Define the basic methods that classes that support SQL Functions need to implement for Classes that use them. This is intended to allow code to be written before functions are fully integrated with the DBAdaptors. As well as allowing for functions to expand as needed. @author Greg Monroe @version $Id: SQLFunction.java 1448414 2013-02-20 21:06:35Z tfischer $
org.eigenbase.sql.SqlFunction
A SqlFunction is a type of operator which has conventional function-call syntax.
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
org.springframework.jdbc.object.SqlFunction
SQL "function" wrapper for a query that returns a single row of results. The default behavior is to return an int, but that can be overridden by using the constructor with an extra return type parameter.
Intended to use to call SQL functions that return a single result using a query like "select user()" or "select sysdate from dual". It is not intended for calling more complex stored functions or for using a CallableStatement to invoke a stored procedure or stored function. Use StoredProcedure or SqlCall for this type of processing.
This is a concrete class, which there is often no need to subclass. Code using this package can create an object of this type, declaring SQL and parameters, and then invoke the appropriate run method repeatedly to execute the function. Subclasses are only supposed to add specialized run methods for specific parameter and return types.
Like all RdbmsOperation objects, SqlFunction objects are thread-safe. @author Rod Johnson @author Juergen Hoeller @author Jean-Pierre Pawlak @see org.springframework.jdbc.object.StoredProcedure

Examples of org.hibernate.dialect.function.SQLFunction

      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( null, expressions, context.getSessionFactory() );
      return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, text );
    }
  }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

  @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

Examples of org.hibernate.dialect.function.SQLFunction

  }


  @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

Examples of org.hibernate.dialect.function.SQLFunction

    }
    FromElement fe = getFromElement();
    if ( fe != null ) {
      return fe.getDataType();
    }
    SQLFunction sf = getWalker().getSessionFactoryHelper().findSQLFunction( getText() );
    if ( sf != null ) {
      return sf.getReturnType( null, getWalker().getSessionFactoryHelper().getFactory() );
    }
    return null;
  }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

    // 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

Examples of org.hibernate.dialect.function.SQLFunction

    // 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.hasArguments() and function.hasParenthesesIfNoArguments() is true,
    // then assume that lcToken is not a function, since it is not followed by "(";
    // can't seem to use function.hasParenthesesIfNoArguments() alone because
    // function definitions may return true if "()" is optional when there are no arguments.
    return function.hasArguments() && function.hasParenthesesIfNoArguments() ? false : true;
  }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

    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( null, expressions, context.getSessionFactory() );
      return getASTFactory().create( OrderByTemplateTokenTypes.IDENT, text );
    }
  }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

    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

Examples of org.hibernate.dialect.function.SQLFunction


  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

Examples of org.hibernate.dialect.function.SQLFunction

    }
  }


  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

0 1 2 3 4 5

TOP

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.