summaryrefslogtreecommitdiffstats
path: root/application/models/PoolMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/PoolMapper.php')
-rw-r--r--application/models/PoolMapper.php67
1 files changed, 67 insertions, 0 deletions
diff --git a/application/models/PoolMapper.php b/application/models/PoolMapper.php
index 099aa1e..c788a18 100644
--- a/application/models/PoolMapper.php
+++ b/application/models/PoolMapper.php
@@ -2,7 +2,74 @@
class Application_Model_PoolMapper
{
+
+ protected $_dbTable;
+ public function setDbTable($dbTable)
+ {
+ if (is_string($dbTable)) {
+ $dbTable = new $dbTable();
+ }
+ if (!$dbTable instanceof Zend_Db_Table_Abstract) {
+ throw new Exception('Invalid table data gateway provided');
+ }
+
+ $this->_dbTable = $dbTable;
+
+ return $this;
+ }
+
+ public function getDbTable()
+ {
+ if (null === $this->_dbTable) {
+ $this->setDbTable('Application_Model_DbTable_Person');
+ }
+
+ return $this->_dbTable;
+ }
+
+ public function save(Application_Model_Pool $pol)
+ {
+
+ $data = array('poolID'=> $pol->getID() ,'title'=> $pol->getTitle() ,'description'=> $pol->getDescription() ,'location'=> $pol->getLocation() );
+
+ if (null === ($id = $pol->getID()) ) {
+ unset($data['id']);
+ $this->getDbTable()->insert($data);
+ } else {
+ $this->getDbTable()->update($data, array('id = ?' => $id));
+ }
+ }
+
+ public function find($id, Application_Model_Pool $pol)
+ {
+ $result = $this->getDbTable()->find($id);
+ if (0 == count($result)) {
+ return;
+ }
+
+ $row = $result->current();
+
+ $pol->setID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location);
+ }
+
+ public function fetchAll()
+ {
+ $resultSet = $this->getDbTable()->fetchAll();
+ $entries = array();
+ foreach ($resultSet as $row) {
+ $entry = new Application_Model_Pool();
+
+ $entry->setID($row->poolID)->setTitle($row->title)->setDescription($row->description)->setLocation($row->location);
+
+ $entries[] = $entry;
+ }
+
+ return $entries;
+ }
+
+
+
}