/*--
  This file is a part of ZetaGrid, a simple and secure Grid Computing
  kernel.

  Copyright (c) 2001-2004 Sebastian Wedeniwski.  All rights reserved.

  Use in source and binary forms, with or without modification,
  are permitted provided that the following conditions are met:

  1. The source code must retain the above copyright
     notice, this list of conditions and the following disclaimer.

  2. The origin of this software must not be misrepresented; you must 
     not claim that you wrote the original software.  If you plan to
     use this software in a product, please contact the author.

  3. Altered source versions must be plainly marked as such, and must
     not be misrepresented as being the original software. The author
     must be informed about these changes.

  4. The name of the author may not be used to endorse or promote 
     products derived from this software without specific prior written 
     permission.

  THIS SOFTWARE IS PROVIDED BY THE AUTHOR ``AS IS'' AND ANY EXPRESS
  OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
  ARE DISCLAIMED.  IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY
  DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
  DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE
  GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
  INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
  WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
  NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

  Version 1.8.5, April 17, 2003

  This program is based on the work of:
     S. Wedeniwski
--*/

package zeta.tool;

import java.io.File;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Arrays;

import zeta.util.DatabaseUtils;

public class CheckCompleteness {

  public static void main(String[] args) {
    if (args.length == 1) {
      if (args[0].equals("?")) {
        System.out.println("USAGE: [s] [n]");
      } else if (args[0].equals("s")) {
        summary(0);
      } else {
        checkCompleteness(Long.parseLong(args[0]));
      }
    } else if (args.length == 2 && args[0].equals("s")) {
      summary(Long.parseLong(args[1]));
    } else {
      checkCompleteness(0);
    }
  }

  static void summary(long greaterThanWorkUnitId) {
    File file = new File(ConstantProperties.FINAL_DIR + "/1");
    String[] list = file.list();
    if (list != null) {
      long rangeAll = 0;
      int numberOfWorkUnits = 0;
      int workUnitIdOverlap = 100; // ToDo: not fix
      long minWorkUnitId = 0;
      long maxWorkUnitIdRange = 0;
      for (int i = 0; i < list.length; ++i) {
        if (list[i].endsWith(".zip")) {
          int idx = list[i].indexOf('_', 11);
          long workUnitId = Long.parseLong(list[i].substring(11, idx));
          if (greaterThanWorkUnitId == 0 || greaterThanWorkUnitId < workUnitId) {
            int range = Integer.parseInt(list[i].substring(idx+1, list[i].length()-4));
            if (minWorkUnitId == 0 || minWorkUnitId > workUnitId) {
              minWorkUnitId = workUnitId;
            }
            if (maxWorkUnitIdRange == 0 || maxWorkUnitIdRange < workUnitId+range) {
              maxWorkUnitIdRange = workUnitId+range-workUnitIdOverlap;
            }
            rangeAll += range-workUnitIdOverlap;
            ++numberOfWorkUnits;
          }
        }
      }
      System.out.println("Checked between " + minWorkUnitId + " and " + maxWorkUnitIdRange);
      System.out.println("Available: " + rangeAll + " (" + (rangeAll*100.0)/(maxWorkUnitIdRange-minWorkUnitId) + "%)");
      System.out.println("Missing: " + (maxWorkUnitIdRange-minWorkUnitId-rangeAll) + " (" + ((maxWorkUnitIdRange-minWorkUnitId-rangeAll)*100.0)/(maxWorkUnitIdRange-minWorkUnitId) + "%)");
    }
  }

  static void checkCompleteness(long greaterThanWorkUnitId) {
    File file = new File(ConstantProperties.FINAL_DIR + "/1");
    String[] list = file.list();
    if (list != null) {
      Arrays.sort(list);
      Connection connection = null;
      Statement stmt = null;
      try {
        long lastWorkUnitId = 0;
        for (int i = 0; i < list.length; ++i) {
          if (list[i].endsWith(".zip")) {
            int idx = list[i].indexOf('_', 11);
            long workUnitId = Long.parseLong(list[i].substring(11, idx));
            if (greaterThanWorkUnitId == 0 || greaterThanWorkUnitId < workUnitId) {
              int range = Integer.parseInt(list[i].substring(idx+1, list[i].length()-4));
              if (lastWorkUnitId != 0 && lastWorkUnitId < workUnitId) {
                try {
                  if (connection == null) {
                    connection = GetData.getConnection();
                    stmt = connection.createStatement();
                  }
                  ResultSet rs = stmt.executeQuery("SELECT MAX(work_unit_id) FROM zeta.computation WHERE task_id=1 AND work_unit_id<" + lastWorkUnitId);
                  if (rs.next()) {
                    workUnitId = rs.getLong(1);
                  }
                  rs.close();
                  rs = stmt.executeQuery("SELECT range FROM zeta.computation WHERE task_id=1 AND work_unit_id=" + workUnitId);
                  if (rs.next()) {
                    range = rs.getInt(1);
                  }
                  rs.close();
                  System.out.println("MISSING: " + workUnitId + ' ' + range);
                } catch (Exception e) {
                  System.out.println("!MISSING: " + (lastWorkUnitId-100) + ' ' + (workUnitId-lastWorkUnitId+200));
                  //ThrowableHandler.handle(e);
                }
                --i;
              } else {
                //checkSize(list[i], range);
              }
              lastWorkUnitId = workUnitId+range;
            }
          }
        }
      } finally {
        DatabaseUtils.close(stmt);
        DatabaseUtils.close(connection);
      }
    }
  }


  static void checkSize(String filename, int range) {
    long size = new File(ConstantProperties.FINAL_DIR + "/1/" + filename).length();
    switch (range) {
      case 200000:
        if (size < 610000 || size > 900000) System.out.println("Wrong size (" + size + "): " + filename);
        break;
      case 300000:
        if (size < 910000 || size > 1310000) System.out.println("Wrong size (" + size + "): " + filename);
        break;
      case 500000:
        if (size < 1480000 || size > 2200000) System.out.println("Wrong size (" + size + "): " + filename);
        break;
      case 700000:
        if (size < 2100000 || size > 2850000) System.out.println("Wrong size (" + size + "): " + filename);
        break;
      case 1000000:
        if (size < 3000000 || size > 4100000) System.out.println("Wrong size (" + size + "): " + filename);
        break;
      default:
        System.out.println("Unknown range " + range + " (" + size + "): " + filename);
        break;
    }
  }
}