<?php

//error_log("In program getTDATA") ;

// Load Config Database File
require_once("config/config_database.php");

function usage()
{
   echo "usage:\n" ;
   echo "DeleteData.php ds=year-month-day [sensor=ID] [table=which]\n" ;
   echo "Where year-month-day is the date from which to delete all earlier data\n" ;
   echo "ID is the sensor ID to delete data for\n" ;
   echo "   Default is ALL sensors\n" ;
   echo "Where which is the table to operate on\n" ;
   echo "   both is delete data from both DataBankRaw and DatabankCalib\n" ;
   echo "   raw is delete data from DataBankRaw only\n" ;
   echo "   calib is delete data from DataBankCalib\n" ;
   exit(0) ;
	
}


// Make a PDO Connection
try {
   $db = new PDO($datawiseConnect,$username,$password);
} catch (PDOException $e) {
  $str = 'DeleteData.php: connection failed: ' . $e->getMessage();
  echo $str.PHP_EOL ;
  exit(0) ;
}

$ds = "" ;
$sensor = 0 ;
$which = "xxx" ;

for ( $i = 1 ; $i < $argc ; $i++ ) {
	if ( strncmp($argv[$i],"ds=",3) == 0 )
		$ds = substr($argv[$i],3) ;
	else if ( strncmp($argv[$i],"sensor=",7) == 0 ) {
		$sensor = substr($argv[$i],7) ;
		$sensor = intval($sensor) ;
	} else if ( strncmp($argv[$i],"Table=",6) == 0 )
        $which = substr($argv[$i],6) ;		
	else if ( strncmp($argv[$i],"-?") == 0 )
		usage() ;
}

$date = explode("-",$ds) ;
if ( count($date) != 3 ) {
	echo "No OR invalid date specified\n" ;
	usage() ;
}

if ( ($which != 'both') && ($which != 'raw') && ($which != 'calib')  ) {
	echo "No table specified".PHP_EOL ;
	usage() ;
}

if ( $sensor == 0 ) {
	if ( ($which == 'raw') || ($which == 'both') ) {
	   $sql = "DELETE FROM DataBankRaw WHERE T_TIME <= ".$ds ;
	   echo $sql.PHP_EOL ;
	   $result = $db->query($sql) ;
	}
	if ( ($which == 'calib') || ($which == 'both') ) {
	   $sql = "DELETE FROM DataBankCalib WHERE T_TIME <= ".$ds ;
	   echo $sql.PHP_EOL ;
	   $result = $db->query($sql) ;
	}
} else {
	if ( ($which == 'raw') || ($which == 'both') ) {
	   $sql = "DELETE FROM DataBankRaw WHERE T_TIME <= ".$ds." AND S_ID=".$sensor ;
	   echo $sql.PHP_EOL ;
	   $result = $db->query($sql) ;
	}
	if ( ($which == 'calib') || ($which == 'both') ) {
	   $sql = "DELETE FROM DataBankCalib WHERE T_TIME <= ".$ds." AND S_ID=".$sensor ; ;
	   echo $sql.PHP_EOL ;
	   $result = $db->query($sql) ;
	}	
}


?>