| /* |
| * Licensed to the Apache Software Foundation (ASF) under one or more |
| * contributor license agreements. See the NOTICE file distributed with |
| * this work for additional information regarding copyright ownership. |
| * The ASF licenses this file to You 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. |
| */ |
| |
| package macromedia.qa.metrics; |
| |
| import macromedia.util.UnitTrace; |
| |
| import java.sql.PreparedStatement; |
| import java.sql.ResultSet; |
| import java.sql.SQLException; |
| import java.util.HashMap; |
| import java.util.Map; |
| |
| public class Value extends Persistable |
| { |
| public static final String TABLE_NAME = "Value"; |
| |
| public final Run run; |
| public final Metric metric; |
| public boolean outlier; |
| public String textValue; |
| public Double numberValue; |
| |
| private Map clause; |
| private String[] tables = new String[]{TABLE_NAME}; |
| |
| Value(Run run, Metric statistic) |
| { |
| this.run = run; |
| this.metric = statistic; |
| } |
| |
| public void load(MetricsDatabase database) |
| { |
| PreparedStatement statement = null; |
| ResultSet rs = null; |
| |
| try |
| { |
| statement = get(database); |
| rs = statement.executeQuery(); |
| rs.first(); //move to first row |
| |
| Object i = rs.getObject("id"); |
| if (i != null) |
| { |
| id = MetricsDatabase.getId(i); |
| outlier = rs.getBoolean("outlier"); |
| textValue = rs.getString("textvalue"); |
| numberValue = new Double(rs.getDouble("numvalue")); |
| } |
| else |
| { |
| id = -1; |
| } |
| } |
| catch (SQLException ex) |
| { |
| if (UnitTrace.errors) |
| System.err.println("Error loading " + getIdentity() + ". " + ex == null ? "" : ex.getMessage()); |
| } |
| finally |
| { |
| closeResultSet(rs); |
| closeStatement(statement); |
| } |
| } |
| |
| public String getIdentity() |
| { |
| return TABLE_NAME + ": " + run.build.getIdentity() + ", " + metric.getIdentity() + ", id: " + id; |
| } |
| |
| public String getTableName() |
| { |
| return TABLE_NAME; |
| } |
| |
| protected String[] getTables() |
| { |
| return tables; |
| } |
| |
| protected Map getInserts() |
| { |
| Map inserts = getUpdates(); |
| inserts.put("metric_id", metric); |
| inserts.put("run_id", run); |
| return inserts; |
| } |
| |
| protected Map getUpdates() |
| { |
| HashMap updates = new HashMap(); |
| updates.put("outlier", outlier ? Boolean.TRUE : Boolean.FALSE); |
| |
| if (textValue != null) |
| updates.put("textvalue", textValue); |
| |
| if (numberValue != null) |
| updates.put("numvalue", numberValue); |
| |
| return updates; |
| } |
| |
| protected Map getClauses() |
| { |
| if (clause == null) |
| { |
| clause = new HashMap(); |
| clause.put("metric_id", metric); |
| clause.put("run_id", run); |
| } |
| |
| if (id >= 0) |
| clause.put("id", new Long(id)); |
| |
| return clause; |
| } |
| } |