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