content: /*
   * 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.
   */
  
  // Log Event Prototype 
  // From event_viewer.jsp
  package org.apache.hadoop.chukwa.extraction.engine.datasource.database;
  
  
  import java.sql.Connection;
  import java.sql.ResultSet;
  import java.sql.ResultSetMetaData;
  import java.sql.SQLException;
  import java.sql.Statement;
  import java.text.SimpleDateFormat;
  import java.util.LinkedList;
  import java.util.List;
  import java.util.TreeMap;
  import org.apache.hadoop.chukwa.extraction.engine.ChukwaRecord;
  import org.apache.hadoop.chukwa.extraction.engine.Record;
  import org.apache.hadoop.chukwa.extraction.engine.SearchResult;
  import org.apache.hadoop.chukwa.extraction.engine.Token;
  import org.apache.hadoop.chukwa.extraction.engine.datasource.DataSource;
  import org.apache.hadoop.chukwa.extraction.engine.datasource.DataSourceException;
  import org.apache.hadoop.chukwa.util.ExceptionUtil;
  import org.apache.commons.logging.Log;
  import org.apache.commons.logging.LogFactory;
  
  //import org.apache.hadoop.chukwa.hicc.ClusterConfig;
  
  public class DatabaseDS implements DataSource {
    private static final Log log = LogFactory.getLog(DatabaseDS.class);
  
    @edu.umd.cs.findbugs.annotations.SuppressWarnings(value =
        "SQL_NONCONSTANT_STRING_PASSED_TO_EXECUTE", 
        justification = "Dynamic based upon tables in the database")
    public SearchResult search(SearchResult result, String cluster,
        String dataSource, long t0, long t1, String filter, Token token)
        throws DataSourceException {
      SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd kk:mm:ss");
      String timeField = null;
      TreeMap<Long, List<Record>> records = result.getRecords();
  
      if (cluster == null) {
        cluster = "demo";
      }
  
      if (dataSource.equalsIgnoreCase("MRJob")) {
        timeField = "LAUNCH_TIME";
      } else if (dataSource.equalsIgnoreCase("HodJob")) {
        timeField = "StartTime";
      } else {
        timeField = "timestamp";
      }
      String startS = formatter.format(t0);
      String endS = formatter.format(t1);
      Statement stmt = null;
      ResultSet rs = null;
      try {
        String dateclause = timeField + " >= '" + startS + "' and " + timeField
            + " <= '" + endS + "'";
  
        // ClusterConfig cc = new ClusterConfig();
        String jdbc = ""; // cc.getURL(cluster);
  
        Connection conn = org.apache.hadoop.chukwa.util.DriverManagerUtil.getConnection(jdbc);
  
        stmt = conn.createStatement();
        String query = "";
        query = "select * from " + dataSource + " where " + dateclause + ";";
        rs = stmt.executeQuery(query);
        if (stmt.execute(query)) {
          rs = stmt.getResultSet();
          ResultSetMetaData rmeta = rs.getMetaData();
          int col = rmeta.getColumnCount();
          while (rs.next()) {
            ChukwaRecord event = new ChukwaRecord();
            StringBuilder cell = new StringBuilder();;
            long timestamp = 0;
  
            for (int i = 1; i < col; i++) {
              String value = rs.getString(i);
              if (value != null) {
                cell.append(" ");
                cell.append(rmeta.getColumnName(i));
                cell.append(":");
                cell.append(value);
              }
              if (rmeta.getColumnName(i).equals(timeField)) {
                timestamp = rs.getLong(i);
                event.setTime(timestamp);
              }
            }
            boolean isValid = false;
            if (filter == null || filter.equals("")) {
              isValid = true;
            } else if (cell.indexOf(filter) > 0) {
              isValid = true;
            }
            if (!isValid) {
              continue;
            }
  
            event.add(Record.bodyField, cell.toString());
            event.add(Record.sourceField, cluster + "." + dataSource);
            if (records.containsKey(timestamp)) {
              records.get(timestamp).add(event);
            } else {
              List<Record> list = new LinkedList<Record>();
              list.add(event);
              records.put(event.getTime(), list);
            }
          }
        }
      } catch (SQLException e) {
        e.printStackTrace();
        throw new DataSourceException(e);
      } finally {
        if (rs != null) {
          try {
            rs.close();
          } catch (SQLException sqlEx) {
            log.debug(ExceptionUtil.getStackTrace(sqlEx));
          }
          rs = null;
        }
        if (stmt != null) {
          try {
            stmt.close();
          } catch (SQLException sqlEx) {
            log.debug(ExceptionUtil.getStackTrace(sqlEx));
          }
          stmt = null;
        }
      }
      return result;
    }
  
    public boolean isThreadSafe() {
      return true;
    }
  
  }
  