Examples of org.apache.derby.iapi.sql.dictionary.ViewDescriptor

Package org.apache.derby.iapi.sql.dictionary

Examples of org.apache.derby.iapi.sql.dictionary.ViewDescriptor

org.apache.derby.iapi.sql.dictionary.ViewDescriptor
This is the implementation of ViewDescriptor. Users of View descriptors should only use the following methods:
1. getUUID
2. setUUID
3. getViewText
4. setViewName
5. getCheckOptionType
6. getCompSchemaId
@version 0.1

    /* Resolve the view, if this is a view */
        if (tabDescr.getTableType() == TableDescriptor.VIEW_TYPE)
    {
      FromSubquery                fsq;
      ResultSetNode        rsn;
      ViewDescriptor        vd;
      CreateViewNode        cvn;
      SchemaDescriptor      compSchema;


      /* Get the associated ViewDescriptor so that we can get 
       * the view definition text.
       */
            vd = dataDictionary.getViewDescriptor(tabDescr);


      /*
      ** Set the default compilation schema to be whatever
      ** this schema this view was originally compiled against.
      ** That way we pick up the same tables no matter what
      ** schema we are running against.
      */
      compSchema = dataDictionary.getSchemaDescriptor(vd.getCompSchemaId(), null);


      compilerContext.pushCompilationSchema(compSchema);
  
      try
      {
    
        /* This represents a view - query is dependent on the ViewDescriptor */
        compilerContext.createDependency(vd);
  
        cvn = (CreateViewNode)
                  parseStatement(vd.getViewText(), false);


        rsn = cvn.getParsedQueryExpression();


        /* If the view contains a '*' then we mark the views derived column list
         * so that the view will still work, and return the expected results,

View Full Code Here

   * @exception StandardException    Thrown on error
   */
  private ViewDescriptor getViewDescriptorScan(TableDescriptor tdi)
    throws StandardException
  {
    ViewDescriptor      vd;
    DataValueDescriptor    viewIdOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSVIEWS_CATALOG_NUM);
    UUID          viewID = tdi.getUUID();


    /* Use viewIdOrderable in both start 
     * and stop position for scan. 
     */
    viewIdOrderable = getIDValueAsCHAR(viewID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, viewIdOrderable);


    vd = (ViewDescriptor)
          getDescriptorViaIndex(
            SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID,
            keyRow,
            (ScanQualifier [][]) null,
            ti,
            (TupleDescriptor) null,
            (List) null,
            false);


    if (vd != null)
    {
      vd.setViewName(tdi.getName());
    }
    return vd;
  }

View Full Code Here

    /* Resolve the view, if this is a view */
    if (tableDescriptor.getTableType() == TableDescriptor.VIEW_TYPE)
    {
      FromSubquery                fsq;
      ResultSetNode        rsn;
      ViewDescriptor        vd;
      CreateViewNode        cvn;
      SchemaDescriptor      compSchema;


      /* Get the associated ViewDescriptor so that we can get 
       * the view definition text.
       */
      vd = dataDictionary.getViewDescriptor(tableDescriptor);


      /*
      ** Set the default compilation schema to be whatever
      ** this schema this view was originally compiled against.
      ** That way we pick up the same tables no matter what
      ** schema we are running against.
      */
      compSchema = dataDictionary.getSchemaDescriptor(vd.getCompSchemaId(), null);


      compilerContext.pushCompilationSchema(compSchema);
  
      try
      {
    
        /* This represents a view - query is dependent on the ViewDescriptor */
        compilerContext.createDependency(vd);
  
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(vd != null,
            "vd not expected to be null for " + tableName);
        }


        cvn = (CreateViewNode)
                  parseStatement(vd.getViewText(), false);


        rsn = cvn.getParsedQueryExpression();


        /* If the view contains a '*' then we mark the views derived column list
         * so that the view will still work, and return the expected results,

View Full Code Here

          FormatableBitSet providingCols = td.getReferencedColumnMap();
          if (providingCols == null)
          {
            if (dep instanceof ViewDescriptor)
            {
              ViewDescriptor vd = (ViewDescriptor) dep;
              SchemaDescriptor compSchema;
              compSchema = dd.getSchemaDescriptor(vd.getCompSchemaId(), null);
              CompilerContext newCC = lcc.pushCompilerContext(compSchema);
              Parser  pa = newCC.getParser();


              // Since this is always nested inside another SQL
              // statement, so topLevel flag should be false
              CreateViewNode cvn = (CreateViewNode)pa.parseStatement(
                        vd.getViewText());


              // need a current dependent for bind
              newCC.setCurrentDependent(dep);
              cvn.bindStatement();
              ProviderInfo[] providerInfos = cvn.getProviderInfo();

View Full Code Here

   * @exception StandardException    Thrown on error
   */
  private ViewDescriptor getViewDescriptorScan(TableDescriptor tdi)
    throws StandardException
  {
    ViewDescriptor      vd;
    DataValueDescriptor    viewIdOrderable;
    TabInfoImpl          ti = getNonCoreTI(SYSVIEWS_CATALOG_NUM);
    UUID          viewID = tdi.getUUID();


    /* Use viewIdOrderable in both start 
     * and stop position for scan. 
     */
    viewIdOrderable = getIDValueAsCHAR(viewID);


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, viewIdOrderable);


    vd = (ViewDescriptor)
          getDescriptorViaIndex(
            SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID,
            keyRow,
            (ScanQualifier [][]) null,
            ti,
            (TupleDescriptor) null,
            (List) null,
            false);


    if (vd != null)
    {
      vd.setViewName(tdi.getName());
    }
    return vd;
  }

View Full Code Here

          FormatableBitSet providingCols = td.getReferencedColumnMap();
          if (providingCols == null)
          {
            if (dep instanceof ViewDescriptor)
            {
              ViewDescriptor vd = (ViewDescriptor) dep;
              SchemaDescriptor compSchema;
              compSchema = dd.getSchemaDescriptor(vd.getCompSchemaId(), null);
              CompilerContext newCC = lcc.pushCompilerContext(compSchema);
              Parser  pa = newCC.getParser();


              // Since this is always nested inside another SQL
              // statement, so topLevel flag should be false
              CreateViewNode cvn = (CreateViewNode)pa.parseStatement(
                        vd.getViewText());


              // need a current dependent for bind
              newCC.setCurrentDependent(dep);
              cvn.bindStatement();
              ProviderInfo[] providerInfos = cvn.getProviderInfo();

View Full Code Here

    /* Resolve the view, if this is a view */
    if (tableDescriptor.getTableType() == TableDescriptor.VIEW_TYPE)
    {
      FromSubquery                fsq;
      ResultSetNode        rsn;
      ViewDescriptor        vd;
      CreateViewNode        cvn;
      SchemaDescriptor      compSchema;


      /* Get the associated ViewDescriptor so that we can get 
       * the view definition text.
       */
      vd = dataDictionary.getViewDescriptor(tableDescriptor);


      /*
      ** Set the default compilation schema to be whatever
      ** this schema this view was originally compiled against.
      ** That way we pick up the same tables no matter what
      ** schema we are running against.
      */
      compSchema = dataDictionary.getSchemaDescriptor(vd.getCompSchemaId(), null);


      compilerContext.pushCompilationSchema(compSchema);
  
      try
      {
    
        /* This represents a view - query is dependent on the ViewDescriptor */
        compilerContext.createDependency(vd);
  
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(vd != null,
            "vd not expected to be null for " + tableName);
        }


        cvn = (CreateViewNode)
                  parseStatement(vd.getViewText(), false);


        rsn = cvn.getParsedQueryExpression();


        /* If the view contains a '*' then we mark the views derived column list
         * so that the view will still work, and return the expected results,

View Full Code Here

    /* Resolve the view, if this is a view */
    if (tableDescriptor.getTableType() == TableDescriptor.VIEW_TYPE)
    {
      FromTable          fsq;
      ResultSetNode        rsn;
      ViewDescriptor        vd;
      CreateViewNode        cvn;
      SchemaDescriptor      compSchema;
      SchemaDescriptor      prevCompSchema;


      /* Get the associated ViewDescriptor so that we can get 
       * the view definition text.
       */
      vd = dataDictionary.getViewDescriptor(tableDescriptor);


      /*
      ** Set the default compilation schema to be whatever
      ** this schema this view was originally compiled against.
      ** That way we pick up the same tables no matter what
      ** schema we are running against.
      */
      compSchema = dataDictionary.getSchemaDescriptor(vd.getCompSchemaId(), null);


      prevCompSchema = compilerContext.setCompilationSchema(compSchema);
  
      try
      {
    
        /* This represents a view - query is dependent on the ViewDescriptor */
        compilerContext.createDependency(vd);
  
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(vd != null,
            "vd not expected to be null for " + tableName);
        }
  
        /*
        ** Push a compiler context to parse the query text so that
        ** it won't clobber the current context.
        */
        LanguageConnectionContext lcc = getLanguageConnectionContext();
        CompilerContext newCC = lcc.pushCompilerContext();
        cvn = (CreateViewNode) 
                    QueryTreeNode.parseQueryText( 
                        newCC,
                        vd.getViewText(),
                        (DataValueDescriptor[])null,  // default params
                        lcc);


        lcc.popCompilerContext(newCC);

View Full Code Here

   * @exception StandardException    Thrown on error
   */
  private ViewDescriptor getViewDescriptorScan(TableDescriptor tdi)
    throws StandardException
  {
    ViewDescriptor      vd;
    DataValueDescriptor    viewIdOrderable;
    TabInfo          ti = getNonCoreTI(SYSVIEWS_CATALOG_NUM);
    UUID          viewID = tdi.getUUID();


    /* Use viewIdOrderable in both start 
     * and stop position for scan. 
     */
    viewIdOrderable = dvf.getCharDataValue(viewID.toString());


    /* Set up the start/stop position for the scan */
    ExecIndexRow keyRow = exFactory.getIndexableRow(1);
    keyRow.setColumn(1, viewIdOrderable);


    vd = (ViewDescriptor)
          getDescriptorViaIndex(
            SYSVIEWSRowFactory.SYSVIEWS_INDEX1_ID,
            keyRow,
            (ScanQualifier [][]) null,
            ti,
            (TupleDescriptor) null,
            (List) null,
            false);


    if (vd != null)
    {
      vd.setViewName(tdi.getName());
    }
    return vd;
  }

View Full Code Here

    /* Resolve the view, if this is a view */
    if (tableDescriptor.getTableType() == TableDescriptor.VIEW_TYPE)
    {
      FromTable          fsq;
      ResultSetNode        rsn;
      ViewDescriptor        vd;
      CreateViewNode        cvn;
      SchemaDescriptor      compSchema;
      SchemaDescriptor      prevCompSchema;


      /* Get the associated ViewDescriptor so that we can get 
       * the view definition text.
       */
      vd = dataDictionary.getViewDescriptor(tableDescriptor);


      /*
      ** Set the default compilation schema to be whatever
      ** this schema this view was originally compiled against.
      ** That way we pick up the same tables no matter what
      ** schema we are running against.
      */
      compSchema = dataDictionary.getSchemaDescriptor(vd.getCompSchemaId(), null);


      prevCompSchema = compilerContext.setCompilationSchema(compSchema);
  
      try
      {
    
        /* This represents a view - query is dependent on the ViewDescriptor */
        compilerContext.createDependency(vd);
  
        if (SanityManager.DEBUG)
        {
          SanityManager.ASSERT(vd != null,
            "vd not expected to be null for " + tableName);
        }
  
        /*
        ** Push a compiler context to parse the query text so that
        ** it won't clobber the current context.
        */
        LanguageConnectionContext lcc = getLanguageConnectionContext();
        CompilerContext newCC = lcc.pushCompilerContext();
        cvn = (CreateViewNode) 
                    QueryTreeNode.parseQueryText( 
                        newCC,
                        vd.getViewText(),
                        (DataValueDescriptor[])null,  // default params
                        lcc);


        lcc.popCompilerContext(newCC);

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

Related Classes of org.apache.derby.iapi.sql.dictionary.ViewDescriptor

org.apache.derby.iapi.sql.depend.DependencyManager

org.apache.derby.iapi.store.access.TransactionController

org.apache.derby.impl.sql.catalog.DataDictionaryImpl

org.apache.derby.impl.sql.catalog.SYSVIEWSRowFactory

org.apache.derby.impl.sql.compile.FromBaseTable

org.apache.derby.impl.sql.compile.TablePrivilegesNode

org.apache.derby.impl.sql.depend.BasicDependencyManager

org.apache.derby.impl.sql.execute.CreateViewConstantAction

org.apache.derby.impl.sql.execute.DropViewConstantAction

org.apache.derby.impl.sql.execute.TablePrivilegeInfo

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.