connection = $connection; } public function byLocale(string $locale): array { $sql = <<connection->executeQuery($sql, ['locale' => $locale])->fetchAllAssociative(); $channelTranslations = []; foreach ($rows as $row) { $channelTranslations[$row['code']] = $row['label']; } return $channelTranslations; } }