/**
* @static
* @param string $reportName
* @param int $userId
* @param Date $dateCreated
* @param string $serialized
* @param int $reportId
* @return SavedReport
*/
public static function FromDatabase($reportName, $userId, Date $dateCreated, $serialized, $reportId)
{
$savedReport = ReportSerializer::Deserialize($reportName, $userId, $serialized);
$savedReport->WithDateCreated($dateCreated);
$savedReport->WithId($reportId);
return $savedReport;
}
public function SaveCustomReport(SavedReport $report)
{
$serialized = ReportSerializer::Serialize($report);
ServiceLocator::GetDatabase()->ExecuteInsert(new AddSavedReportCommand($report->ReportName(), $report->OwnerId(), $report->DateCreated(), $serialized));
}
public function testLoadsSingleReportForUser()
{
$userId = 100;
$reportId = 1;
$reportName = 'report2';
$date = Date::Now();
$expectedReport1 = new SavedReport($reportName, $userId, new Report_Usage(Report_Usage::ACCESSORIES), new Report_ResultSelection(Report_ResultSelection::COUNT), new Report_GroupBy(Report_GroupBy::GROUP), new Report_Range(Report_Range::DATE_RANGE, Date::Now()->ToUtc(), Date::Now()->ToUtc()), new Report_Filter(12, 11, 896, 123, 45234, 111));
$expectedReport1->WithDateCreated($date->ToUtc());
$expectedReport1->WithId($reportId);
$serialized1 = ReportSerializer::Serialize($expectedReport1);
$rows = new SavedReportRow();
$rows->With($userId, $reportName, $date->ToDatabase(), $serialized1, $reportId);
$this->db->SetRows($rows->Rows());
$report = $this->repository->LoadSavedReportForUser($reportId, $userId);
$expectedCommand = new GetSavedReportForUserCommand($reportId, $userId);
$this->assertEquals($expectedCommand, $this->db->_LastCommand);
$this->assertEquals($expectedReport1, $report);
}
