#!/usr/bin/php
<?php

require_once('common.php');

if (count($argv) != 2) fatal("only one argument needed");

$fp = fopen($argv[1], 'r');

if (!$fp) fatal("unable to open {$argv[1]}");

$lastdate = db_single_field('SELECT IFNULL(UNIX_TIMESTAMP(MAX(price_date)), 0) FROM prices');

echo("lastdate=$lastdate\n");

while (($row = fgetcsv($fp))) {
	$time = trim($row[0])/1000;
	if ($time > $lastdate) {
		$price = trim($row[1]);
		db_exec('INSERT IGNORE INTO prices ( price_date, price_usd ) VALUES ( FROM_UNIXTIME( ? ), ? )', $time, $price);
	}
}

?>