1 /*
2 * Copyright (c) 2004 International Decision Systems, Inc. All Rights Reserved.
3 *
4 * By using this Software, You acknowledge that the Software is a valuable asset
5 * and trade secret of either International Decision Systems, Inc. ("IDSI") or a
6 * third party supplier of IDSI and constitutes confidential and proprietary
7 * information.
8 *
9 * NEITHER IDSI NOR ANY AGENT OR PERSON ACTING FOR OR WITH IDSI HAS MADE OR DOES
10 * MAKE ANY STATEMENTS, AFFIRMATIONS, REPRESENTATIONS OR WARRANTIES WHATSOEVER
11 * TO YOU, WHETHER EXPRESS OR IMPLIED, AS TO THE SOFTWARE, THE QUALITY OR
12 * CONDITION OF THE SOFTWARE, OR THE OPERATING CHARACTERISTICS OR RELIABILITY OF
13 * THE SOFTWARE, OR ITS SUITABILITY FOR ANY GENERAL OR PARTICULAR PURPOSE, OR AS
14 * TO ANY OTHER MATTER WHATSOEVER; ANY AND ALL OTHER WARRANTIES INCLUDING
15 * WITHOUT LIMITATION ANY WARRANTIES IMPLIED BY LAW, SUCH AS THE IMPLIED
16 * WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND TITLE,
17 * USE AND NON-INFRINGEMENT; ARE HEREBY EXPRESSLY DISCLAIMED AND EXCLUDED.
18 */
19 package net.sourceforge.addam.ddlrun.custom;
20
21
22 import java.sql.Connection;
23 import java.sql.PreparedStatement;
24 import java.sql.ResultSet;
25 import java.sql.SQLException;
26 import java.util.ArrayList;
27 import java.util.Collection;
28 import java.util.List;
29
30 import net.sourceforge.addam.ddlrun.utils.CompletedScriptRetriever;
31
32 /**
33 * ENTER A DESCRIPTION HERE
34 *
35 * @author TIM3
36 * @since Sep 16, 2005
37 */
38 public class IDSCompletedScriptRetriever implements CompletedScriptRetriever {
39
40 public static final String GET_COMPLETED_SCRIPTS_SQL = "SELECT SCL_SCRIPT FROM SCRIPT_LOG";
41
42 public IDSCompletedScriptRetriever(Connection conn) {
43 this.connection = conn;
44 }
45
46 public Collection getCompletedScripts() {
47 List runScripts = new ArrayList();
48 try {
49 PreparedStatement statement = connection.prepareStatement(GET_COMPLETED_SCRIPTS_SQL);
50 ResultSet runScriptsSet = statement.executeQuery();
51 while (runScriptsSet.next()) {
52 runScripts.add(runScriptsSet.getString(1));
53 }
54 } catch (SQLException e) {
55 throw new RuntimeException("unable to retrieve completed scripts", e);
56 }
57 return runScripts;
58 }
59
60 private final Connection connection;
61 }