if ($insertTickRESULT) {
return true;
} else {
return false;
}
} else {
return false;
}
}
// Function Create Table History
public function createTableHistory($idServer, $year, $month)
{
$createTableSQL = "CREATE TABLE IF NOT EXISTS `" . $this->dbNameCore . "`.`bi_history_" . $idServer . "_" . $year . "_" . $month . "` (\r\n `id_history` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `id_item` int(11) unsigned NOT NULL DEFAULT '0',\r\n `id_host` int(11) unsigned NOT NULL,\r\n `clock` int(11) unsigned NOT NULL DEFAULT '0',\r\n `value` double(16,4) unsigned NOT NULL DEFAULT '0.0000',\r\n `valid` int(11) NOT NULL DEFAULT '0',\r\n PRIMARY KEY (`id_history`),\r\n \tKEY `Dual` (`id_host`,`id_item`),\r\n KEY `id_item` (`id_item`),\r\n \t\t\t\tKEY `id_host` (`id_host`),\r\n \t\t\t\tKEY `clock` (`clock`)\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$createTableRESULT = $this->conexion->query($createTableSQL, false, 'logs_split');
$month = $month + 1;
$createTableSQL = "CREATE TABLE IF NOT EXISTS `" . $this->dbNameCore . "`.`bi_history_" . $idServer . "_" . $year . "_" . $month . "` (\r\n `id_history` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n `id_item` int(11) unsigned NOT NULL DEFAULT '0',\r\n `id_host` int(11) unsigned NOT NULL,\r\n `clock` int(11) unsigned NOT NULL DEFAULT '0',\r\n `value` double(16,4) unsigned NOT NULL DEFAULT '0.0000',\r\n `valid` int(11) NOT NULL DEFAULT '0',\r\n PRIMARY KEY (`id_history`),\r\n \tKEY `Dual` (`id_host`,`id_item`),\r\n KEY `id_item` (`id_item`),\r\n \t\t\t\tKEY `id_host` (`id_host`),\r\n \t\t\t\tKEY `clock` (`clock`)\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
$createTableRESULT = $this->conexion->query($createTableSQL, false, 'logs_split');
if ($createTableRESULT) {
return true;
} else {
return false;
}
}
}
$cmd = new Control(true, 'core.bi.node1.baking.cl', true);
$cmd->parametro->remove('STDOUT');
$cmd->parametro->set('STDOUT', true);
//Start Split
$split = new Split($cmd);
$split->validStart();
$split->start();
