TST: add tests for caosdb-server#170

Tests for caosdb-server!28 (merged)

tests/test_issues_server.py

@@ -263,14 +263,14 @@ def test_issue_170():
     """update scalar data type to list data type"""
     p = db.Property(name="TestProp1", datatype=db.LIST(db.INTEGER))
     p.value = [1, 2]
-    p.insert()  # works
+    p.insert()
 
     p2 = db.execute_query("FIND TestProp1", unique=True)
     assert p2.datatype == db.LIST(db.INTEGER)
     assert p2.value == [1, 2]
 
     p.description = "TestDescription"
-    p.update()  # fails
+    p.update()  # this failed
 
     p2 = db.execute_query("FIND TestProp1", unique=True)
     assert p2.datatype == db.LIST(db.INTEGER)
@@ -278,23 +278,26 @@ def test_issue_170():
     assert p2.description == "TestDescription"
 
     p = db.Property(name="TestProp2", datatype=db.DOUBLE)
-    p.insert()  # works
+    p.insert()
 
     p.datatype = db.LIST(db.INTEGER)
-    p.update()  # works
-    p2 = db.execute_query("FIND TestProp1", unique=True)
+    p.update()  # this worked because no value yet
+    p2 = db.execute_query("FIND TestProp2", unique=True)
+    assert p2.datatype == db.LIST(db.INTEGER)
+    p.value = [1, 2]
+
+    p.update()  # this failed
+    p2 = db.execute_query("FIND TestProp2", unique=True)
     assert p2.datatype == db.LIST(db.INTEGER)
     assert p2.value == [1, 2]
-    p2.value = [1, 2]
-    p2.update()  # fails
 
     p = db.Property(name="TestProp3", datatype=db.DOUBLE)
-    p.insert()  # works
+    p.insert()
 
     p.datatype = db.LIST(db.INTEGER)
     p.value = [1, 2]
-    p.update()  # fails
+    p.update()  # this failed
 
-    p2 = db.execute_query("FIND TestProp1", unique=True)
+    p2 = db.execute_query("FIND TestProp3", unique=True)
     assert p2.datatype == db.LIST(db.INTEGER)
     assert p2.value == [1, 2]