Classes in this File | Line Coverage | Branch Coverage | Complexity | ||||
IDSCompletedScriptRetriever |
|
| 2.5;2.5 |
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 | 0 | public IDSCompletedScriptRetriever(Connection conn) { |
43 | 0 | this.connection = conn; |
44 | 0 | } |
45 | ||
46 | public Collection getCompletedScripts() { | |
47 | 0 | List runScripts = new ArrayList(); |
48 | try { | |
49 | 0 | PreparedStatement statement = connection.prepareStatement(GET_COMPLETED_SCRIPTS_SQL); |
50 | 0 | ResultSet runScriptsSet = statement.executeQuery(); |
51 | 0 | while (runScriptsSet.next()) { |
52 | 0 | runScripts.add(runScriptsSet.getString(1)); |
53 | 0 | } |
54 | 0 | } catch (SQLException e) { |
55 | 0 | throw new RuntimeException("unable to retrieve completed scripts", e); |
56 | 0 | } |
57 | 0 | return runScripts; |
58 | } | |
59 | ||
60 | private final Connection connection; | |
61 | } |