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

    }
    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

  @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() );
    return sf == null ? null : sf.getReturnType( null, null );
  }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

    }
  }


  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

Examples of org.hibernate.dialect.function.SQLFunction

    }
  }


  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

Examples of org.hibernate.dialect.function.SQLFunction

  protected SQLFunction getFunction(CriteriaQuery criteriaQuery) {
    return getFunction( getFunctionName(), criteriaQuery );
  }


  protected SQLFunction getFunction(String functionName, CriteriaQuery criteriaQuery) {
    SQLFunction function = criteriaQuery.getFactory()
        .getSqlFunctionRegistry()
        .findSQLFunction( functionName );
    if ( function == null ) {
      throw new HibernateException( "Unable to locate mapping for function named [" + functionName + "]" );
    }

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

    return getFunction( criteriaQuery ).render( null, ARGS, criteriaQuery.getFactory() )
        + " as y" + position + '_';
  }


  protected SQLFunction getFunction(CriteriaQuery criteriaQuery) {
    SQLFunction function = criteriaQuery.getFactory()
        .getSqlFunctionRegistry()
        .findSQLFunction( "count" );
    if ( function == null ) {
      throw new HibernateException( "Unable to locate count function mapping" );
    }

View Full Code Here

Examples of org.hibernate.dialect.function.SQLFunction

      return true;
    }


    // otherwise, in order for this to be a function logically it has to be a function that does not
    // have arguments.  So try to assert that using the registry of known functions
    final SQLFunction function = context.getSqlFunctionRegistry().findSQLFunction( ast.getText() );
    if ( function == null ) {
      // no registered function, so we cannot know for certain
      return false;
    }
    else {
      // if function.hasParenthesesIfNoArguments() is true, then assume the node is not a function
      return ! function.hasParenthesesIfNoArguments();
    }
  }

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.