<?php

echo "\nOBJECT UPDATING\n";

$e = new TableGateway('employees', 'id', $db);
$row = $e[1];
$row['name'] = 'Patry';
$row['email'] = '';
$id = ($e[1] = $row);
echo "Updating object: " . (($id == 1) ? 'PASSED' : 'FAILED') . "\n";
unset($e);
unset($id);

$sql = "SELECT * FROM employees";
$db->execute($sql);
$res = $db->getResult();
echo "Verifying database table entry: " . ((count($res) == 1 and $res[0]['name'] == 'Patry' and $res[0]['email'] == '') ? 'PASSED' : 'FAILED') . "\n";
unset($res);

?>