DataAccess/StepMania/SimfileRepository.php

   1 <?php
   2
   3 namespace DataAccess\StepMania;
   4
   5 use DataAccess\StepMania\ISimfileRepository;
   6 use DataAccess\DataMapper\IDataMapper;
   7 use DataAccess\Queries\IQueryBuilderFactory;
   8 use DataAccess\Queries\IQueryBuilder;
   9 use DataAccess\Queries\StepMania\ISimfileQueryConstraints;
  10 use Domain\Entities\StepMania\ISimfile;
  11
  12 //TODO: Implement some sort of caching. Probably OK for now not to worry.
  13 class SimfileRepository implements ISimfileRepository
  14 {
  15     private $_dataMapper;
  16     private $_queryBuilderFactory;
  17
  18     public function __construct(IDataMapper $dataMapper, IQueryBuilderFactory $queryBuilderFactory) {
  19         $this->_dataMapper = $dataMapper;
  20         $this->_queryBuilderFactory = $queryBuilderFactory;
  21     }
  22
  23     public function findById($id) {
  24         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  25         $queryBuilder->where('id', '=', $id)->null('pack_id');
  26
  27         $result = $this->_dataMapper->map('Simfile', $queryBuilder);
  28         return reset($result);
  29     }
  30
  31     public function findAll()
  32     {
  33         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  34         $queryBuilder->where('id', '>', 0)->null('pack_id');
  35         $result = $this->_dataMapper->map('Simfile', $queryBuilder);
  36         return $result;
  37     }
  38
  39     public function findRange($id, $limit)
  40     {
  41         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  42         $queryBuilder->where('id', '>=', $id)->null('pack_id')->limit($limit);
  43
  44         return $this->_dataMapper->map('Simfile', $queryBuilder);
  45     }
  46
  47     public function save(ISimfile $entity) {
  48         return $this->_dataMapper->save($entity);
  49     }
  50
  51     //TODO: Implement
  52     public function remove(ISimfile $entity) {
  53         ;
  54     }
  55
  56     private function applyConstraintsAndReturn(ISimfileQueryConstraints $constraints = NULL, IQueryBuilder $queryBuilder)
  57     {
  58         if($constraints)
  59         {
  60             $constraints->applyTo($queryBuilder);
  61         }
  62
  63         $queryBuilder->null('pack_id');
  64
  65         return $this->_dataMapper->map('Simfile', $queryBuilder);
  66     }
  67
  68     public function findByTitle($title, ISimfileQueryConstraints $constraints = NULL)
  69     {
  70         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  71         $queryBuilder->where('title', 'LIKE', "%%$title%%");
  72
  73         return $this->applyConstraintsAndReturn($constraints, $queryBuilder);
  74     }
  75
  76     public function findByArtist($artist, ISimfileQueryConstraints $constraints = NULL)
  77     {
  78         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  79         $queryBuilder->where('artist', 'LIKE', "%%$artist%%");
  80
  81         return $this->applyConstraintsAndReturn($constraints, $queryBuilder);
  82     }
  83
  84     public function findByBpm($high, $low = null, ISimfileQueryConstraints $constraints = NULL)
  85     {
  86         $queryBuilder = $this->_queryBuilderFactory->createInstance();
  87         $queryBuilder->where('bpm_high', '=', $high);
  88
  89         if($low)
  90         {
  91             $queryBuilder->where('bpm_low', '=', $low);
  92         }
  93
  94         return $this->applyConstraintsAndReturn($constraints, $queryBuilder);
  95     }
  96
  97     public function findByStepArtist($artistName, ISimfileQueryConstraints $constraints = null)
  98     {
  99         $queryBuilder = $this->_queryBuilderFactory->createInstance();
 100         $queryBuilder->join('inner', 'simfiles', 'id', 'steps', 'simfile_id')
 101                      ->join('inner', 'steps', 'step_artist_id', 'step_artists', 'id')
 102                      ->where('tag', 'LIKE', "%%$artistName%%");
 103
 104         return $this->applyConstraintsAndReturn($constraints, $queryBuilder);
 105     }
 106
 107     private function findByDifficultyAndRating($difficulty, $rating, ISimfileQueryConstraints $constraints = null)
 108     {
 109         $queryBuilder = $this->_queryBuilderFactory->createInstance();
 110         $queryBuilder->join('inner', 'simfiles', 'id', 'steps', 'simfile_id')
 111                      ->where('difficulty', '=', $difficulty)
 112                      ->where('rating', '=', $rating);
 113
 114         return $this->applyConstraintsAndReturn($constraints, $queryBuilder);
 115     }
 116
 117     public function findByLightMeter($feet, ISimfileQueryConstraints $constraints = null)
 118     {
 119         return $this->findByDifficultyAndRating('light', $feet, $constraints);
 120     }
 121
 122     public function findByBeginnerMeter($feet, ISimfileQueryConstraints $constraints = null)
 123     {
 124         return $this->findByDifficultyAndRating('beginner', $feet, $constraints);
 125     }
 126
 127     public function findByMediumMeter($feet, ISimfileQueryConstraints $constraints = null)
 128     {
 129         return $this->findByDifficultyAndRating('medium', $feet, $constraints);
 130     }
 131
 132     public function findByHardMeter($feet, ISimfileQueryConstraints $constraints = null)
 133     {
 134         return $this->findByDifficultyAndRating('challenge', $feet, $constraints);
 135     }
 136
 137     public function findByExpertMeter($feet, ISimfileQueryConstraints $constraints = null)
 138     {
 139         return $this->findByDifficultyAndRating('expert', $feet, $constraints);
 140     }
 141 }