Differences

This shows you the differences between two versions of the page.

--- kurs:entwickeln_mit_phpunit [2012/01/12 11:07]
mh
+++ kurs:entwickeln_mit_phpunit [2012/01/12 12:43]
mh
@@ Line 3: / Line 3: @@
 <code>
 <?php
+require_once 'PEAR/Exception.php';
 class Employee {
   var $id, $last_name, $salary;
   var $db;
+  function Employee() {
+    $this->db_connect();
+  }
   private function db_connect() {
     $this->db = oci_connect('hr', 'hr', 'orcl');
   }
   function set_last_name($last_name) {
     $this->last_name = $last_name;
   }
   function read() {
-    $this->db_connect();
+	$q = oci_parse($this->db,
-	$q = oci_parse($this->db,
+      "select last_name ln, salary
-      "select last_name ln, salary
 	     from employees
          where last_name = :b_last_name");
     oci_bind_by_name
 	   ($q, ":b_last_name", $this->last_name);
     $r = oci_execute($q, OCI_DEFAULT);
     $row = oci_fetch_array($q, OCI_ASSOC);
-    $this->salary = $row['SALARY'];
+    if (!isset($row['LN'])) {
-  }
+	  throw new PEAR_Exception("no employee ".$this->last_name
+	    , 404);
+	}
+	$this->salary = $row['SALARY'];
+  }
   function store() {}
   function __set($u, $a) {
     die("ERROR: you tried to set $u with $a");
@@ Line 42: / Line 53: @@
     die("ERROR: you tried to call $u with $a");
   }
 }
 </code>

dokuwiki