lithium\tests\cases\data\source\DatabaseTest::testDelete PHP Method

    public function testDelete()
    {
        $entity = new Record(array('model' => $this->_model, 'data' => array('id' => 1, 'title' => 'new post', 'body' => 'the body'), 'exists' => true));
        $query = new Query(compact('entity') + array('type' => 'delete'));
        $this->assertTrue($entity->exists());
        $this->assertTrue($this->_db->delete($query));
        $this->assertEqual(1, $query->entity()->id);
        $expected = "DELETE FROM {mock_database_posts} WHERE {id} = 1;";
        $this->assertEqual($expected, $this->_db->sql);
        $this->assertFalse($entity->exists());
    }