Example #1
0
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;
}
Example #2
0
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;
}