<?php
/**
 *	Sample program to batch create and update metadata in dspace datadabase. Used with dspace v1.5.2
 *	Please ALWAYS backup dspace database and read carefully before using!
 *	requirements: PEAR MDB2 library
 *
 *	@creator Evangelos Banos, http://vbanos.gr, vbanos@gmail.com
 *	@modified 2010-03-07
 *	
 *	The program connects to Postgresql, opens dspace.metadatavalue table and performs the following actions in ALL items:
 *
 *	1. if an item doesn't have europeana:provider, insert europeana:provider = Veria Central Public Library
 *	2. if an item doesn't have europeana:type, insert europeana:type = TEXT
 *	// NOT NEEDED ANY MORE, if an item doesn't have europeana:isShownBy (URL of the item), add the current URL of item from dc:identifier
 *
 *	database dspace
 *	table	metadatavalue
 *			metadata_value_id (auto increment)
 *			item_id
 *			metadata_field_id
 *			text_value
 *			text_lang  (el, en_US)
 *			place (always 1)
 */

/**
 *	These parameters should be changed before using the program, please consult dspace.
 */

$provider_id = "73";
$type_id = "72";
// $isshownby_id = "74";

require("MDB2.php");

//
//	dspace database connection
//	pgsql://username:password@tcp(ip:port)/database
//
$dsn = "pgsql://dspace:XXXXXX@tcp(localhost:5432)/dspace";
$options = array(
    'debug' => 2,
    'result_buffering' => false,
);

$mdb2 =& MDB2::factory($dsn, $options);
if (PEAR::isError($mdb2)) {
    die($mdb2->getMessage());
}
$mdb2->setFetchMode(MDB2_FETCHMODE_ASSOC);

echo "ok connected\n";

$res =& $mdb2->query("SELECT item_id FROM item");
while($line = $res->fetchRow()) {

	//
	// if an item doesn't have europeana:provider, insert europeana:provider = Veria Central Public Library
	//
	$res2 = $mdb2->query("SELECT COUNT(*) FROM metadatavalue WHERE item_id={$line['item_id']} AND metadata_field_id=" . $provider_id);
	$count = $res2->fetchOne();
	if($count == 0) {
		$mdb2->query("INSERT INTO metadatavalue(metadata_value_id, item_id, metadata_field_id, text_value, text_lang, place) VALUES (nextval('metadatavalue_seq'::regclass), {$line['item_id']}, {$provider_id}, 'Veria Central Public Library', 'en_US', 1)");
	}

	//
	// if an item doesn't have europeana:type, insert europeana:type = TEXT
	//
	$res3 = $mdb2->query("SELECT COUNT(*) FROM metadatavalue WHERE item_id={$line['item_id']} AND metadata_field_id=" . $type_id);
	$count3 = $res3->fetchOne();
	if($count3 == 0) {
		$mdb2->query("INSERT INTO metadatavalue(metadata_value_id, item_id, metadata_field_id, text_value, text_lang, place) VALUES (nextval('metadatavalue_seq'::regclass), {$line['item_id']}, {$type_id}, 'TEXT', NULL, 1)");
	}

	//
	// if an item doesn't have europeana:isShownBy, add the current URL from the dc:identifier value
	//
	// $res4 = $mdb2->query("SELECT COUNT(*) FROM metadatavalue WHERE item_id={$line['item_id']} AND metadata_field_id=" . $isshownby_id);
	// $count4 = $res4->fetchOne();
	// if($count4 == 0) {
	//	$res5 = $mdb2->query("SELECT text_value FROM metadatavalue WHERE item_id={$line['item_id']} AND metadata_field_id=25");
	//	$url = $res5->fetchOne();
	//	$mdb2->query("INSERT INTO metadatavalue(metadata_value_id, item_id, metadata_field_id, text_value, text_lang, place) VALUES (nextval('metadatavalue_seq'::regclass), {$line['item_id']}, {$isshownby_id}, '{$url}', NULL, 1)");
	// }
}
echo "actions completed\n";

$mdb2->disconnect();
?>