print "There are " . $result->num_rows . " feeds to convert, would you like to continue?(y/n) ";
$handle = fopen("php://stdin", "r");
$line = fgets($handle);
if (trim($line) != 'y') {
exit;
}
print "\n";
print "Do you want to create a CSV backup in your PHPTimeSeries folder?(y/n) ";
$handle = fopen("php://stdin", "r");
$do_backup = fgets($handle);
print "\n";
while ($row = $result->fetch_array()) {
print "userid:" . $row['userid'] . " feed:" . $row['id'] . " name:" . $row['name'] . "\n";
$id = $row['id'];
$current_feed_value = $row['value'];
$engineresult = $engine->create($id, 0);
if ($engineresult == true) {
if (trim($do_backup) == 'y') {
$backupfile = fopen("{$timeseries_dir}feed_{$id}backup.csv", "w") or die("Unable to open backup file!");
fwrite($backupfile, "timestamp;data\n");
}
$data = $mysqli->query("SELECT * FROM feed_{$id}");
while ($row = $data->fetch_array()) {
//print "timestamp:".$row['time']." data:".$row['data']."\n";
$postresult = $engine->post($id, $row['time'], $row['data']);
if (trim($do_backup) == 'y') {
fwrite($backupfile, "{$row['time']};{$row['data']}\n");
}
//print $postresult."\n";
}
if (trim($do_backup) == 'y') {
print "\n";
$result = $mysqli->query("SELECT * FROM feeds WHERE `engine`= 0 AND `datatype`= 2");
print "Found " . $result->num_rows . " daily mysql feeds to convert\n";
if ($apply) {
if ($result->num_rows == 0) {
print "Nothing to apply\n";
}
while ($row = $result->fetch_array()) {
print "converting feed userid:" . $row['userid'] . " feed:" . $row['id'] . " name:" . $row['name'] . "\n";
$id = $row['id'];
$current_feed_value = $row['value'];
print "- current value is: {$current_feed_value}\n";
if (file_exists($phptimeseries_dir . "feed_{$feedid}.MYD")) {
print "phptimeseries data file already exists\n";
} else {
$engineresult = $phptimeseries->create($id, 0);
if ($engineresult == true) {
print "created phptimeseries feed\n";
$data = $mysqli->query("SELECT * FROM feed_{$id}");
print "copying " . $data->num_rows . " datapoints\n";
while ($row = $data->fetch_array()) {
$postresult = $phptimeseries->post($id, $row['time'], $row['data']);
}
$mysqli->query("UPDATE feeds SET `engine`=2 WHERE `id`='{$id}'");
$mysqli->query("UPDATE feeds SET `value`={$current_feed_value} WHERE `id`='{$id}'");
if ($redis) {
$redis->hset("feed:{$id}", "engine", 2);
}
print "Feed {$id} is now PHPTimeseries\n";
} else {
print "could not create phptimeseries feed\n";
