/*

  * 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.ddlrun.custom;

 import java.sql.Connection;

 import java.sql.PreparedStatement;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import net.sourceforge.addam.ddlrun.utils.StartFolderRetriever;

 /**

  * ENTER A DESCRIPTION HERE

  *

  * @author TIM3

  * @since Sep 16, 2005

  * @todo make folder SQL configurable

  */

 public class IDSStartFolderRetriever implements StartFolderRetriever {

     // todo make this configurable

     public static final String GET_START_FOLDER_SQL = "SELECT VRS_START_FOLDER FROM VERSION WHERE VRS_TYPE='PF'";

     public IDSStartFolderRetriever(Connection conn) {

         this.connection = conn;

     }

     public String getStartFolder() {

         PreparedStatement versionStatement = null;

         String version;

         try {

             versionStatement = connection.prepareStatement(GET_START_FOLDER_SQL);

             ResultSet results = versionStatement.executeQuery();

             if (results.next()) {

                 version = results.getString(1);

             } else {

                 throw new SQLException("no results returned for " + GET_START_FOLDER_SQL);

             }

         } catch (SQLException e) {

             throw new RuntimeException("unable to retrieve start folder", e);

         }

         return version;

     }

     private final Connection connection;

 }