com.google.code.plsqlmaven.plsql.PlSqlTemplateMojo.groovy Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of plsql-maven-plugin Show documentation
The newest version!
package com.google.code.plsqlmaven.plsql

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

/**
 * Quickstart goal to create PL/SQL source files
 *
 * @goal template
 *
 */
public class PlSqlTemplateMojo
    extends PlSqlMojo
{
    
   /**
    * Type of the object to be created (eg function,procedure,package)
    * @since 1.0
    * @parameter expression="${type}"
    * @required
    */
   private String type;

   /**
    * Name of the object to be created (eg myprc)
    * @since 1.0
    * @parameter expression="${name}"
    * @required
    */
   private String name;

    void execute()
    {
        if (sql) // if the user gave us a connection
        try
        {
            connectToDatabase()
            
            sql.eachRow("select object_type from user_objects where object_name = upper(${name})")
            {
                fail("A ${it.object_type} already exists with this name")
            }
            
            disconnectFromDatabase()
        }
        catch (Error e)
        {
            // ignore if no error found
        }
        
        ant.mkdir(dir: sourceDir)
        
        name= name.toLowerCase();
        type= type.toLowerCase();
        
        def ext= plsqlUtils.getTypeExt(type)
        def templatePath= 'com/google/code/plsqlmaven/templates/'+type+".${ext}"+PLSQL_EXTENSION;
        
        if (! ((type =~ /^package/) || (type =~ /^type/)))
        {
           def type_dir= get_dir(sourceDir, type)
           def target_file= new File(type_dir, name+".${ext}"+PLSQL_EXTENSION)
           target_file << getTemplate(templatePath,['name': name])
           log.info "created ${type}: "+target_file.absolutePath
        }
        else
        {
           def type_dir= get_dir(sourceDir, type.split()[0])
           def odir= get_dir(type_dir, name)
           def target_file= new File(odir, name+".${ext}"+PLSQL_EXTENSION)
           target_file << getTemplate(templatePath,['name': name])
           log.info("created ${type}: "+target_file.absolutePath)
           ext= plsqlUtils.getTypeExt(type+' body')
           templatePath= 'com/google/code/plsqlmaven/templates/'+type+".${ext}"+PLSQL_EXTENSION;
           target_file= new File(odir, name+".${ext}"+PLSQL_EXTENSION)
           target_file << getTemplate(templatePath,['name': name])
           log.info("created ${type} body: "+target_file.absolutePath)
        }
        
    }
    
}