public function simulateUsage() { # Month with overage bandwidth MySQLRunner::execute("INSERT INTO kalturadw.dwh_hourly_partner_usage (partner_id, \n\t\t\tdate_id, hour_id, bandwidth_source_id, count_bandwidth_kb , aggr_storage_mb)\n\t\t\tVALUES(?, ?,0,8,250,0)", array(0 => $this->partnerId, 1 => self::BW_MONTH)); MySQLRunner::execute("INSERT INTO kalturadw.dwh_hourly_partner_usage (partner_id, \n\t\t\tdate_id, hour_id, bandwidth_source_id, count_bandwidth_kb , aggr_storage_mb)\n\t\t\tVALUES(?, ?,0,9,250,0)", array(0 => $this->partnerId, 1 => self::BW_MONTH)); # Month with overage storage for ($i = 0; $i < 28; $i++) { MySQLRunner::execute("INSERT INTO kalturadw.dwh_hourly_partner_usage (partner_id, \n date_id, hour_id, bandwidth_source_id, count_bandwidth_kb , aggr_storage_mb)\n VALUES(?, ?,0,8,0,500)", array(0 => $this->partnerId, 1 => self::ST_MONTH + $i)); } # Month with overage storage + bandwidth for ($i = 0; $i < 31; $i++) { MySQLRunner::execute("INSERT INTO kalturadw.dwh_hourly_partner_usage (partner_id, \n date_id, hour_id, bandwidth_source_id, count_bandwidth_kb , aggr_storage_mb)\n VALUES(?, ?,0,8,290*1024/31,290)", array(0 => $this->partnerId, 1 => self::BW_ST_MONTH + $i)); } # Month with overage plays MySQLRunner::execute("INSERT INTO kalturadw.dwh_hourly_partner (partner_id, \n\t\t\tdate_id, hour_id, count_plays)\n\t\t\tVALUES(?, ?,0,500)", array(0 => $this->partnerId, 1 => self::PLAY_MONTH)); # Month with overage entries for ($i = 0; $i < 10; $i++) { DWHInspector::createNewEntry($this->partnerId, $i, self::ENTRY_MONTH); } }