com.google.code.plsqlmaven.oraddl.helpers.ViewHelper.groovy Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of oraddl-helpers Show documentation
There is a newer version: 1.11
package com.google.code.plsqlmaven.oraddl.helpers

/*
 * Copyright 2001-2005 The Apache Software Foundation.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import groovy.sql.Sql

class ViewHelper extends OraDdlHelper
{
      public ViewHelper(sql,log,username)
      {
          super(sql,log,username);
      }

      public boolean extract(name,xml)
      {
           sql.eachRow("select * from user_views a where view_name = upper(${name})")
           {
              def view= it.toRowResult()
              xml.view('name': xid(view.view_name))
              {
                  xml.columns()
                  {
                      sql.eachRow("select * from user_tab_columns a where table_name = upper(${name}) order by column_id")
                      {
                         def col= it.toRowResult()
                         
                         xml.column('name': xid(col.column_name))
                      }
                  }
    
                 xml.text('') 
                 {
                      out.print("")
                 }
              }
           }
           
           return true
      }
      
      public boolean exists(view)
      {
           def exists= false;
           sql.eachRow("select 1 from user_views where view_name= upper(${oid(view.'@name',false)})")
           { exists= true }
           
           return exists;
      }
   
      public create(view)
      {
          def ddl= "create "+(view.'@force'=='true' ? 'force' : '')+" view ${oid(view.'@name')} "+'('+view.columns.column.collect{ col-> oid(col.'@name') }.join(',')+')'+" as ${view.text.text()}";
          
          return [
                          type: 'create_view',
                           ddl: ddl,
                   privMessage: "You need to: grant create view to ${username}"
                 ];

      }
      
      public drop(view)
      {
          return [
                          type: 'create_view',
                           ddl: "drop view ${oid(view.'@name')}",
                   privMessage: "You need to: grant drop view to ${username}"
                 ];

      }

      public detectChanges(source,target)
      {
          def changes= []
          
          def recreate_view=
          {
              changes << drop(source)
              changes << create(target)
              
          }
          
          
          if (!cmp(source.text.text(),target.text.text())
              || source.columns.column.size()!=target.columns.column.size())
            recreate_view();
          else
          {
              def equals= true;
              
              source.columns.column.eachWithIndex
              {
                    sourceCol, index -> 
                    
                    def targetCol= target.columns.column[index]; 
                    
                    if (!cmp(sourceCol,targetCol,'name'))
                    {
                      equals= false
                      return
                    }
              }
              
              if (!equals)
                recreate_view();
          }
          
          return changes
      }
      
}