DIFF Tests
The Tests called "DIFF Tests" has been made to detect and compare data differences between old tables and reversly populated views (or materialized views).
Most of tables are sharing same structure. Even their ID numbers are same. Only exceptions are address, external_reference and cityobject_genericattrib tables. All columns except ID column should be declared manually while comparing these tables with old ones.
For Exp: Ordinary Diff Test:
# Following query is enough to detect any data difference for buildings:
SELECT * FROM citydb.v_building #Reversly populated buildin view
EXCEPT
SELECT * FROM citydb.building #Old Table
Diff Test for cityobject_genericattrib table:
#All attributes except ID clumns must be declared manually
SELECT attrname, datatype, strval, intval, realval, urival, dateval, unit, genattribset_codespace, blobval, geomval, surface_geometry_id, cityobject_id
FROM v_cityobject_genericattrib;
EXCEPT
SELECT attrname, datatype, strval, intval, realval, urival, dateval, unit, genattribset_codespace, blobval, geomval, surface_geometry_id, cityobject_id
FROM cityobject_genericattrib;