Package com.ibm.fhir.database.utils.query

Class FromClause

  • public class FromClause
extends java.lang.Object
    The FromClause SQL definition

    • Constructor Summary

      Constructors 
      Constructor Description
      FromClause()  

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      void addFrom​(Select sub, Alias alias)
      Add the sub-query as an item in the from list
      void addInnerJoin​(java.lang.String tableName, Alias alias, ExpNode joinOnPredicate)
      Add an inner join clause to the FROM items list
      void addLeftOuterJoin​(java.lang.String tableName, Alias alias, ExpNode joinOnPredicate)
      Add a left outer join clause to the FROM items list
      void addTable​(java.lang.String tableName)
      Add a table to the FROM items list
      void addTable​(java.lang.String tableName, Alias alias)
      Add a table to the FROM items list
      void addTable​(java.lang.String schemaName, java.lang.String tableName)
      Add a table without an alias.
      void addTable​(java.lang.String schemaName, java.lang.String tableName, Alias alias)
      Add a qualified schema.table with an alias.
      <T> T render​(StatementRenderer<T> renderer)
      Render this FROM clause using the given renderer
      java.lang.String toString()  

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • FromClause

        public FromClause()

    • Method Detail

      • addTable

        public void addTable​(java.lang.String schemaName,
                     java.lang.String tableName)
        Add a table without an alias. Tsk tsk.
        Parameters:
        schemaName - the schema qualifier for the table
        tableName - the table name

      • addTable

        public void addTable​(java.lang.String schemaName,
                     java.lang.String tableName,
                     Alias alias)
        Add a qualified schema.table with an alias.
        Parameters:
        schemaName - the schema qualifier for the table
        tableName - the table name
        alias - the alias to use in select expressions and join predicates

      • addTable

        public void addTable​(java.lang.String tableName,
                     Alias alias)
        Add a table to the FROM items list
        Parameters:
        tableName -
        alias -

      • addTable

        public void addTable​(java.lang.String tableName)
        Add a table to the FROM items list
        Parameters:
        tableName -
        alias -

      • addFrom

        public void addFrom​(Select sub,
                    Alias alias)
        Add the sub-query as an item in the from list
        Parameters:
        sub -
        alias -

      • toString

        public java.lang.String toString()
        Overrides:
        toString in class java.lang.Object

      • render

        public <T> T render​(StatementRenderer<T> renderer)
        Render this FROM clause using the given renderer
        Type Parameters:
        T -
        Parameters:
        renderer -
        Returns:

      • addInnerJoin

        public void addInnerJoin​(java.lang.String tableName,
                         Alias alias,
                         ExpNode joinOnPredicate)
        Add an inner join clause to the FROM items list
        Parameters:
        tableName -
        alias -
        joinOnPredicate -

      • addLeftOuterJoin

        public void addLeftOuterJoin​(java.lang.String tableName,
                             Alias alias,
                             ExpNode joinOnPredicate)
        Add a left outer join clause to the FROM items list
        Parameters:
        tableName -
        alias -
        joinOnPredicate -