Page History

delete from "AO_8B1069_TEST_CHANGE";  
truncate "AO_8B1069_GENERIC_DEFINITION";
truncate "AO_8B1069_CUCUMBER_DEFINITION";
UPDATE "AO_8B1069_TEST_PRE_COND_LINK" SET "TEST_VERSION_ID" = null;
UPDATE "AO_8B1069_PARAM" SET "SUB_ENTITY_ID" = null;
UPDATE "AO_8B1069_TEST_STEP" SET "TEST_VERSION_ID" = null;
UPDATE "AO_8B1069_AUTOMATED_STEP_ISSUE" SET "TEST_VERSION_ID" = null;
UPDATE "AO_8B1069_ENTITY_DATASET_SIZE" SET "SUB_ENTITY_ID" = null;
UPDATE "AO_8B1069_TEST_RUN" SET "TEST_VERSION_ID" = null;

delete from "AO_8B1069_TEST_VERSION";  

-- Check for the unlikely case of having the same precondition linked more than once to the same test
select count(*), "TARGET_ISSUE", "SOURCE_ISSUE"
from "AO_8B1069_TEST_PRE_COND_LINK"
group by "TARGET_ISSUE", "SOURCE_ISSUE"
HAVING count(*)>1

-- delete the duplicated ocurrences
DELETE FROM "AO_8B1069_TEST_PRE_COND_LINK" a USING (
    SELECT MIN("ID") as "ID", "TARGET_ISSUE", "SOURCE_ISSUE"
    FROM "AO_8B1069_TEST_PRE_COND_LINK" 
    GROUP BY "TARGET_ISSUE", "SOURCE_ISSUE" HAVING COUNT(*) > 1
) b
WHERE a."TARGET_ISSUE" = b."TARGET_ISSUE"
AND b."SOURCE_ISSUE" = b."SOURCE_ISSUE"
AND a."ID" <> b."ID"
using the query of your choice


-- Get upgrade number IDs
select ps.* from propertystring ps
join propertyentry pe on pe.id=ps.id
where property_key like '%xray%';

update propertystring set propertyvalue = 2007000000 where ID in (<ids from the previous query that has the value 2007000001>);

– Re-run this select to validate the values have been changed

select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like '%xray%';