function test_get_data() { $db = new TestSchema(); $records = $db->resultset('TestTable')->all(); $rec = $records[0]; $data = $rec->data(); if (!is_array($data)) { return PEAR::raiseError("data() did not return array"); } if (!array_key_exists('charfield', $data)) { return PEAR::raiseError("data() did not return any data"); } return true; }
function test_delete() { $db = new TestSchema(); $data = array("id" => 2, "charfield" => "Test Insert", "textfield" => "Test text data", "datefield" => "2010-04-09", "dtfield" => "2010-04-09 22:25:00"); $db->resultset('TestTable')->create($data); $data['id'] = 3; $db->resultset('TestTable')->create($data); $data['id'] = 4; $db->resultset('TestTable')->create($data); $records = $db->resultset('TestTable')->find(3)->all(); $records[0]->delete(); $records = $db->resultset('TestTable')->find(3)->all(); if (count($records) != 0) { return PEAR::raiseError("We found record 3 - so it was not deleted."); } $records = $db->resultset('TestTable')->all(); foreach ($records as $rec) { $rec->delete(); } $records = $db->resultset('TestTable')->all(); if (count($records) != 0) { return PEAR::raiseError("delete() did not seem to remove the records."); } return true; }