Sha256: e9679751e22da9f192fb1c7e35ebe569b376940ff3c79b429ea786a3aa07f447

Contents?: true

Size: 611 Bytes

Versions: 44

Compression:

Stored size: 611 Bytes

Contents

UPDATE pacticipants SET name = 'pacticipant-' || id;
UPDATE versions SET number = 'version-' || id;
UPDATE pact_versions SET content = '{}';
UPDATE verifications SET test_results = null;
DELETE FROM webhook_executions;
DELETE FROM triggered_webhooks;
DELETE FROM webhooks;
DELETE FROM certificates;

UPDATE tags
SET name = temprow.redacted_name
FROM
  ( SELECT name, 'tag-' || ROW_NUMBER () OVER (ORDER BY name) as redacted_name FROM (
    SELECT DISTINCT name FROM tags WHERE lower(name) NOT IN ('master', 'test', 'dev', 'prod', 'production') ORDER BY name
  ) as x) as temprow
WHERE tags.name = temprow.name;

Version data entries

44 entries across 44 versions & 1 rubygems

Version Path
pact_broker-2.89.1 script/prod/redact-data.sql
pact_broker-2.89.0 script/prod/redact-data.sql
pact_broker-2.88.0 script/prod/redact-data.sql
pact_broker-2.87.0 script/prod/redact-data.sql
pact_broker-2.86.0 script/prod/redact-data.sql
pact_broker-2.85.1 script/prod/redact-data.sql
pact_broker-2.85.0 script/prod/redact-data.sql
pact_broker-2.84.0 script/prod/redact-data.sql
pact_broker-2.83.0 script/prod/redact-data.sql
pact_broker-2.82.0 script/prod/redact-data.sql
pact_broker-2.81.0 script/prod/redact-data.sql
pact_broker-2.80.0 script/prod/redact-data.sql
pact_broker-2.79.1 script/prod/redact-data.sql
pact_broker-2.79.0 script/prod/redact-data.sql
pact_broker-2.78.1 script/prod/redact-data.sql
pact_broker-2.78.0 script/prod/redact-data.sql
pact_broker-2.77.0 script/prod/redact-data.sql
pact_broker-2.76.2 script/prod/redact-data.sql
pact_broker-2.76.1 script/prod/redact-data.sql
pact_broker-2.76.0 script/prod/redact-data.sql