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); } } }