From 07e3636f3ef4a666db0fefbc1663bf6c1e10b996 Mon Sep 17 00:00:00 2001
From: michael pereira
Date: Tue, 8 Feb 2011 13:18:06 +0100
Subject: MapperScript & Mapper angelegt (alle die einen Primärschlüssel
 besitzen)

---
 application/models/RoleMapper.php | 67 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 67 insertions(+)

(limited to 'application/models/RoleMapper.php')

diff --git a/application/models/RoleMapper.php b/application/models/RoleMapper.php
index 020fcca..6ea7079 100644
--- a/application/models/RoleMapper.php
+++ b/application/models/RoleMapper.php
@@ -2,7 +2,74 @@
 
 class Application_Model_RoleMapper
 {
+	
+	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_Role $role)
+	{
+		
+		$data = array('roleID'=> $role->getID() ,'groupID'=> $role->getGroupID() ,'title'=> $role->getTitle() ,'description'=> $role->getDescription() );
+
+		if (null === ($id = $role->getID()) ) {
+			unset($data['id']);
+			$this->getDbTable()->insert($data);
+		} else {
+			$this->getDbTable()->update($data, array('id = ?' => $id));
+		}
+	}
+
+	public function find($id, Application_Model_Role $role)
+	{
+		$result = $this->getDbTable()->find($id);
+		if (0 == count($result)) {
+			return;
+		}
+
+		$row = $result->current();
+		
+		$role->setID($row->roleID)->setGroupID($row->groupID)->setTitle($row->title)->setDescription($row->description);
+	}
+
+	public function fetchAll()
+	{
+		$resultSet = $this->getDbTable()->fetchAll();
+		$entries   = array();
+		foreach ($resultSet as $row) {
+			$entry = new Application_Model_Role();
+			
+			$entry->setID($row->roleID)->setGroupID($row->groupID)->setTitle($row->title)->setDescription($row->description);	
+
+			$entries[] = $entry;
+		}
+
+		return $entries;
+	}
+
+
+	
 }
 
-- 
cgit v1.2.3-55-g7522