function get_array_id_map($server_cfg, $game_cfg)
{
include_once '/usr/local/zperfmon/bin/rightscale.php';
$rs = new RightScale($server_cfg, $game_cfg);
$array_map = $rs->get_array_to_arrayid_mapping();
return $array_map;
}
function main($server_cfg)
{
$options = getopt("g:");
$game = $options['g'];
$game_cfg = load_game_config($game);
$hostConfigObj = new HostgroupConfig($server_cfg, $game);
$rsObj = new RightScale($server_cfg, $game_cfg);
$array_id_name = array_values($rsObj->get_array_to_arrayid_mapping());
$config_col_names = $hostConfigObj->get_config_column_names();
$xhprofModelObj = new XhprofModel($server_cfg, $game_cfg, false);
// add columns for both the tables
$tables = array("vertica_stats_30min", "vertica_stats_daily");
echo "adding columns for {$game}:\n";
foreach ($tables as $table) {
$result = add_missing_columns($config_col_names, $table, $xhprofModelObj);
}
foreach ($array_id_name as $array_id) {
echo "adding columns for {$game}:{$array_id}:\n";
$game_cfg = load_game_config($game, $array_id);
$xhprofModelObj = new XhprofModel($server_cfg, $game_cfg, false);
foreach ($tables as $table) {
$result = add_missing_columns($config_col_names, $table, $xhprofModelObj);
}
}
}
