/** @depends testUpdate */
public function testUpdateKeepImg()
{
$category = new Category(null, "Test", true, 1);
$category2 = new Category(null, "Parent", null, 0);
$id = CategoriesService::createCat($category, 0xaa);
$id2 = CategoriesService::createCat($category2);
$category->id = $id;
$category->label = "Updated";
$category->image = "";
$category->dispOrder = 3;
$category->parentId = $id2;
$ret = CategoriesService::updateCat($category);
$this->assertNotEquals(false, $ret, "Update failed");
$pdo = PDOBuilder::getPDO();
$db = DB::get();
$sql = "SELECT * FROM CATEGORIES WHERE ID = :id";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(":id", $id);
$this->assertNotEquals(false, $stmt->execute(), "Query failed");
$row = $stmt->fetch();
$this->assertEquals($id, $row['ID'], "Id was modified");
$this->assertEquals("Updated", $row['NAME'], "Label update failed");
$this->assertEquals($id2, $row['PARENTID'], "Parent id update failed");
$this->assertEquals(0xaa, $db->readBin($row['IMAGE']), "Image keeping failed");
$this->assertEquals(3, $row['DISPORDER'], "Display order update failed");
}
