CollectiveAccess data mangling example

fix_occurrences.php

<?php

require_once('./setup.php');
require_once(__CA_MODELS_DIR__.'/ca_occurrences.php');

$o_db = new Db();
$qr_prods = $o_db->query('SELECT occurrence_id FROM ca_occurrences WHERE type_id = 116');

while($qr_prods->nextRow()) {
	$t_occ = new ca_occurrences($qr_prods->get('occurrence_id'));

	if($va_dates = $t_occ->get('ca_occurrences.perfSchedule', array('returnAsArray' => true, 'returnBlankValues' => false))) {
		$t_occ->setMode(ACCESS_WRITE);
		$vb_update = false;
		foreach($va_dates as $vs_date) {
			if($vs_date) {
				$t_occ->addAttribute(array(
					'productionDate' => trim($vs_date)
				), 'productionDate');
				$vb_update = true;
			}
		}

		if($vb_update) {
			$t_occ->removeAttributes('perfSchedule');
			$t_occ->update();
			if ($t_occ->numErrors() > 0) {
				var_dump($t_occ->getErrors());
			}
		}
	}

}