return true; } function test_fetch_by_search() { $db = new TestSchema(); $record = $db->resultset('TestTable')->search(array("charfield" => "Test Title"))->single(); if (!$record instanceof Record) { return PEAR::raiseError('search()->single() did not return Record'); } if ($record->id != 1) { return PEAR::raiseError('search() returned wrong ID: expected 1, got ' . $record->id); } return true; } # Test bug where ->data() did not load() 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; } Testing::runTests(array("test_fetch_by_id", "test_fetch_all", "test_fetch_by_search", "test_get_data"));
return PEAR::raiseError("create() did not seem to insert the right id."); } 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; } Testing::runTests(array("test_insert", "test_delete"));