$t->info('WARNING: Doctrine_Connection_Sqlite_Exception caught.'); } doctrine_refresh($a1); $t->is($a1['category_id'], $categories[1]['id'], sprintf('"First item" has been moved to %s', $a3['Category']['name'])); $t->is($a1['position'], 3, '"First item" has been moved to "3" from "1"'); $t->info('Test deleting a collection of sortable items'); $d1 = new SortableArticleUniqueBy(); $d1->name = 'ArticleUniqueBy To Delete 1'; $d1->Category = $categories[2]; $d1->save(); $d2 = new SortableArticleUniqueBy(); $d2->name = 'ArticleUniqueBy To Delete 2'; $d2->Category = $categories[2]; $d2->save(); $d3 = new SortableArticleUniqueBy(); $d3->name = 'ArticleUniqueBy To Delete 3'; $d3->Category = $categories[2]; $d3->save(); $d4 = new SortableArticleUniqueBy(); $d4->name = 'ArticleUniqueBy To Delete 4'; $d4->Category = $categories[2]; $d4->save(); $collection = Doctrine::getTable('SortableArticleUniqueBy')->createQuery()->where('category_id = ?', $categories[2]['id'])->execute(); $t->is($collection->count(), 4, 'Three items exist in the Doctrine Collection to be deleted'); $collection->delete(); $t->is($collection->count(), 0, 'No items in collection - they have been deleted'); $t->ok(!$d1->exists(), '"ArticleUniqueBy To Delete 1" has been removed'); $t->ok(!$d2->exists(), '"ArticleUniqueBy To Delete 2" has been removed'); $t->ok(!$d3->exists(), '"ArticleUniqueBy To Delete 3" has been removed'); $t->ok(!$d4->exists(), '"ArticleUniqueBy To Delete 4" has been removed');