//

 // Copyright (c) 2004, International Decision Systems

 /*

  * Copyright (c) 2004 International Decision Systems, Inc.  All Rights Reserved.

  *

  * By using this Software, You acknowledge that the Software is a valuable asset

  * and trade secret of either International Decision Systems, Inc. ("IDSI") or a

  * third party supplier of IDSI and constitutes confidential and proprietary

  * information.

  *

  * NEITHER IDSI NOR ANY AGENT OR PERSON ACTING FOR OR WITH IDSI HAS MADE OR DOES

  * MAKE ANY STATEMENTS, AFFIRMATIONS, REPRESENTATIONS OR WARRANTIES WHATSOEVER

  * TO YOU, WHETHER EXPRESS OR IMPLIED, AS TO THE SOFTWARE, THE QUALITY OR

  * CONDITION OF THE SOFTWARE, OR THE OPERATING CHARACTERISTICS OR RELIABILITY OF

  * THE SOFTWARE, OR ITS SUITABILITY FOR ANY GENERAL OR PARTICULAR PURPOSE, OR AS

  * TO ANY OTHER MATTER WHATSOEVER; ANY AND ALL OTHER WARRANTIES INCLUDING

  * WITHOUT LIMITATION ANY WARRANTIES IMPLIED BY LAW, SUCH AS THE IMPLIED

  * WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND TITLE,

  * USE AND NON-INFRINGEMENT; ARE HEREBY EXPRESSLY DISCLAIMED AND EXCLUDED.

 */

 package net.sourceforge.addam.impexp;

 import org.apache.tools.ant.BuildException;

 import java.io.BufferedReader;

 import java.io.File;

 import java.io.FileReader;

 import java.io.IOException;

 import java.util.ArrayList;

 import java.util.List;

 import java.util.StringTokenizer;

 /**

  * Provides a placeholder for SQL; used in TableImport as pre/post statements.

  * The SQL can be provided as a file, or as text embedded in the elements.

  *

  * @author TIM3

  * @since Aug 2, 2004

  */

 public class Script {

     private String separator = ";";

     private String text = "";

     private File file = null;

     /**

      * sets the string (usually a character) to separate multiple statements

      * defaults to ";"

      *

      * @param separator

      */

     void setStatementSeparator(String separator) {

         this.separator = separator;

     }

     /**

      * the text to be executed is read from the given file

      *

      * @param aFile

      */

     void setFile(File aFile) {

         this.file = aFile;

     }

     /**

      * adds to the SQL statement

      *

      * @param text

      */

     public void addText(String text) {

         if (this.file != null) {

             throw new BuildException("cannot provide character data when file already provided");

         }

         this.text = text;

     }

     /**

      * this is used to get the statements from the script

      *

      * @return

      */

     public List getStatements() {

         ArrayList list = new ArrayList();

         StringTokenizer tok = new StringTokenizer(this.getText(), separator);

         while (tok.hasMoreTokens()) {

             list.add(tok.nextToken());

         }

         return list;

     }

     private String getText() throws BuildException {

         if (text.length() == 0 && this.file != null) {

             StringBuffer buf = new StringBuffer();

             try {

                 BufferedReader reader = new BufferedReader(new FileReader(this.file));

                 for (String line = reader.readLine(); line != null;) {

                     if (!line.startsWith("--")) {

                         buf.append(line);

                     }

                 }

                 this.text = buf.toString();

             } catch (IOException e) {

                 throw new BuildException("unable to read file " + this.file, e);

             }

         }

         return text;

     }

 }