PHP SpotDb::addSpot示例

示例#1

文件： retrieve.php 项目： 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();

示例#2

文件： retrieve.php 项目： Jurjee/spotweb

    # catch
    exit;
}
# export
if (isset($argc) && $argc > 1 && $argv[1] == '--import') {
    try {
        $db = new SpotDb($settings['db']);
        $db->connect();
        $fp = fopen('export-db.csv', 'r');
        while (($line = fgetcsv($fp)) !== FALSE) {
            $mappedSpot = array();
            foreach ($line as $key => $value) {
                $mappedSpot[Spot_SpotMapping::$valueMapping[$key]] = $value;
            }
            # foreach
            $db->addSpot($line, $line);
        }
        # while
        fclose($fp);
    } catch (Exception $x) {
        die("Error exporting data: " . $x->getMessage() . PHP_EOL);
    }
    # catch
    exit;
}
# import
$req = new SpotReq();
$req->initialize();
if ($req->getDef('output', '') == 'xml') {
    echo "<xml>";
}