$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') { fclose($backupfile); } $mysqli->query("UPDATE feeds SET `engine`=2 WHERE `id`='{$id}'"); $mysqli->query("UPDATE feeds SET `value`={$current_feed_value} WHERE `id`='{$id}'"); exec("chown {$uid}:{$gid} {$timeseries_dir}feed_{$id}.MYD"); if (trim($do_backup) == 'y') { exec("chown {$uid}:{$gid} {$timeseries_dir}feed_{$id}backup.csv"); } print "Feed {$id} is now PHPTimeseries\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"; } } } } if ($redis) { $redis->flushall();