remove_observations_from_cache.php

<?php

///////////////////////////////////////////////////////////////
// Removes from cache any species+poldiv combinations
// in observation table for this batch and job. 
// Run if $replace_cache option set to true (command line option -r=true)
///////////////////////////////////////////////////////////////

include "dbw_open.php";

$sql="
UPDATE observation 
SET is_in_cache=0
WHERE $JOB_WHERE_NA 
;

UPDATE observation o JOIN cache c
ON o.species=c.species
AND o.country=c.country
AND o.state_province=c.state_province
AND o.county_parish=c.county_parish
SET c.native_status_reason='remove'
WHERE $JOB_WHERE 
;

UPDATE observation o JOIN cache c
ON o.species=c.species
AND o.country=c.country
AND o.state_province=c.state_province
SET c.native_status_reason='remove'
WHERE $JOB_WHERE 
AND o.county_parish IS NULL AND c.county_parish IS NULL
;

UPDATE observation o JOIN cache c
ON o.species=c.species
AND o.country=c.country
SET c.native_status_reason='remove'
WHERE $JOB_WHERE 
AND o.county_parish IS NULL AND c.county_parish IS NULL
AND o.state_province IS NULL AND c.state_province IS NULL
;

-- Delete records from cache
DELETE FROM cache
WHERE native_status_reason='remove'
;
";
sql_execute_multiple($dbh, $sql);

include "db_close.php";

?>