* @copyright 2020 Akeneo SAS (http://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ class DbalSelectHourlyIntervalsToRefreshQuery { private Connection $dbalConnection; public function __construct(Connection $dbalConnection) { $this->dbalConnection = $dbalConnection; } /** * @return HourlyInterval[] */ public function execute(): array { $selectSQL = <<dbalConnection->executeQuery($selectSQL)->fetchFirstColumn(); return \array_map(fn (string $dateTime) => HourlyInterval::createFromDateTime( \DateTimeImmutable::createFromFormat( $this->dbalConnection->getDatabasePlatform()->getDateTimeFormatString(), $dateTime, new \DateTimeZone('UTC') ) ), $dateTimes); } }