PHP SpotDb::commitTransaction Beispiele

Beispiel #1

Datei: retrieve.php Projekt: red-arrow/spotweb

if ((isset($argc)) && ($argc > 1) && ($argv[1] == '--import')) {
	try {
		$db = new SpotDb($settings['db']);
		$db->connect();
	
		$fp = fopen('export-db.csv', 'r');
		$db->beginTransaction();
		while (($line = fgetcsv($fp)) !== FALSE) {
			$mappedSpot = array();
			foreach($line as $key => $value) {
				$mappedSpot[Spot_SpotMapping::$valueMapping[$key]] = $value;
			} # foreach

			$db->addSpot($mappedSpot, $mappedSpot);
		} # while
		$db->commitTransaction();
		
		fclose($fp);
	} 
	catch(Exception $x) {
		die("Error importing data: " . $x->getMessage() . PHP_EOL);
	} # catch
	
	exit;
} # import

$req = new SpotReq();
$req->initialize();

if ($req->getDef('output', '') == 'xml') {
	echo "<xml>";