Entity Repository Mapper dle mého

class QuoteDbMapper extends Object{ public function save(Quote $entity){ $data = $this->entityToData($entity); unset ($data); if($entity->id == NULL){//INSERT dibi::query('INSERT INTO ', $data); $returnId = dibi::insertId(); }else{//UPDATE dibi::query('UPDATE SET', $data,' WHERE quote = %i', $entity->id); $returnId = $entity->id; } return $this->find($returnId); } public function find($entityId){ $data = dibi::fetch('SELECT * FROM WHERE quote = %i', $entityId); return $this->load($data); } public function findBy($where = NULL, $by = NULL, $limit = NULL, $offset = NULL){ $rows = dibi::fetchAll(' SELECT * FROM %if', isset($where),'WHERE %and', $where,' %end %if', isset($by),'ORDER BY %by ', $by,' %end %if', isset($limit),' %lmt', $limit,' %end %if', isset($offset),' %ofs', $offset,'%end '); if(!$rows){ return FALSE; } $arr = array(); foreach ($rows as $row){ $arr[] = $this->load($row); } return $arr; } public function findOneBy($where){ $data = dibi::fetch('SELECT * FROM %if', isset($where),' WHERE %and %end', $where); return $this->load($data); } private function entityToData(Quote $entity){ return array( 'quote' => $entity->id, 'series' => $entity->getSeries(FALSE), 'user' => $entity->getUser(FALSE), 'content' => $entity->content ); } private function load($data){ $entity = new Quote(); foreach ($data as $k => $v){ $entity->$k = $v; } return $entity; } } Mapper se mi stará o veškerou práci s databází, nikde jinde se název tabulky či jiný sql dotaz nevyskytuje. 2. Entity