Class DatasetMapper

lib/Db/DatasetMapper.php:16–246

use Psr\Log\LoggerInterface;

class DatasetMapper {
	private $l10n;
	private $userId;
	private $db;
	private $logger;
	const TABLE_NAME = 'analytics_dataset';

	public function __construct(
		$userId,
		IL10N $l10n,
		IDBConnection $db,
		LoggerInterface $logger
	) {
		$this->userId = $userId;
		$this->l10n = $l10n;
		$this->db = $db;
		$this->logger = $logger;
	}

	/**
	 * get datasets
	 * @return array
	 * @throws Exception
	 */
	public function index(): array {
		$sql = $this->db->getQueryBuilder();
               $sql->from(self::TABLE_NAME)
                       ->select('id')
                       ->addSelect('name')
                       ->addSelect('dimension1')
                       ->addSelect('dimension2')
                       ->addSelect('value')
                       ->addSelect('type')
                       ->addSelect('parent')
                       ->where($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)))
                       ->orderBy('parent', 'ASC')
                       ->addOrderBy('name', 'ASC');
		$statement = $sql->executeQuery();
		$result = $statement->fetchAll();
		$statement->closeCursor();
		return $result;
	}

	/**
	 * get datasets
	 * @param $userId
	 * @return array
	 * @throws Exception
	 */
	public function indexByUser($userId): array {
		$sql = $this->db->getQueryBuilder();
		$sql->from(self::TABLE_NAME)->select('id')->where($sql->expr()
															  ->eq('user_id', $sql->createNamedParameter($userId)));
		$statement = $sql->executeQuery();
		$result = $statement->fetchAll();
		$statement->closeCursor();
		return $result;
	}