DataAccess/StepMania/PackRepository.php

   1 <?php
   2
   3 namespace DataAccess\StepMania;
   4
   5 use DataAccess\StepMania\IPackRepository;
   6 use DataAccess\DataMapper\IDataMapper;
   7 use DataAccess\Queries\IQueryBuilderFactory;
   8 use Domain\Entities\StepMania\IPack;
   9
  10 //TODO: Implement some sort of caching. Probably OK for now not to worry.
  11 class PackRepository implements IPackRepository
  12 {
  13     private $_dataMapper;
  14     private $_queryBuilderFactory;
  15
  16     public function __construct(IDataMapper $dataMapper, IQueryBuilderFactory $queryBuilderFactory) {
  17         $this->_dataMapper = $dataMapper;
  18         $this->_queryBuilderFactory = $queryBuilderFactory;
  19     }
  20
  21     public function findById($id) {
  22         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  23         $queryBuilder->where('id', '=', $id);
  24
  25         $result = $this->_dataMapper->map('Pack', $queryBuilder);
  26         return reset($result);
  27     }
  28
  29     public function findAll()
  30     {
  31         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  32         $queryBuilder->where('id', '>', 0);
  33
  34         $result = $this->_dataMapper->map('Pack', $queryBuilder);
  35         return $result;
  36     }
  37
  38     public function findRange($id, $limit)
  39     {
  40         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  41         $queryBuilder->where('id', '>=', $id)->limit($limit);
  42
  43         return $this->_dataMapper->map('Pack', $queryBuilder);
  44     }
  45
  46     public function save(IPack $entity) {
  47         return $this->_dataMapper->save($entity);
  48     }
  49
  50     //TODO: Implement
  51     public function remove(IPack $entity) {
  52         ;
  53     }
  54
  55     public function findByTitle($title)
  56     {
  57         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  58         $queryBuilder->where('title', 'LIKE', "%%$title%%");
  59
  60         return $this->_dataMapper->map('Pack', $queryBuilder);
  61     }
  62
  63     public function findByContributor($artistName)
  64     {
  65         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  66         $queryBuilder->join('inner', 'packs', 'id', 'simfiles', 'pack_id')
  67                      ->join('inner', 'simfiles', 'id', 'steps', 'simfile_id')
  68                      ->join('inner', 'steps', 'step_artist_id', 'step_artists', 'id')
  69                      ->where('tag', 'LIKE', "%%$artistName%%");
  70
  71         return $this->_dataMapper->map('Pack', $queryBuilder);
  72     }
  73 }