* @copyright 2020 Akeneo SAS (http://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ class DbalSelectEventsApiRequestCountWithinLastHourQuery implements SelectEventsApiRequestCountWithinLastHourQueryInterface { private Connection $dbalConnection; public function __construct(Connection $dbalConnection) { $this->dbalConnection = $dbalConnection; } public function execute(\DateTimeImmutable $eventDateTime): array { $oneHourAgoEventDateTime = $eventDateTime->modify('-1 hour'); $sql = <<dbalConnection->executeQuery( $sql, [ 'from_datetime' => $oneHourAgoEventDateTime, 'to_datetime' => $eventDateTime, ], [ 'from_datetime' => Types::DATETIME_IMMUTABLE, 'to_datetime' => Types::DATETIME_IMMUTABLE, ] )->fetchAllAssociative(); } }