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.75.0 script/prod/redact-data.sql
pact_broker-2.74.1 script/prod/redact-data.sql
pact_broker-2.74.0 script/prod/redact-data.sql
pact_broker-2.73.0 script/prod/redact-data.sql
pact_broker-2.72.0 script/prod/redact-data.sql
pact_broker-2.71.0 script/prod/redact-data.sql
pact_broker-2.70.0 script/prod/redact-data.sql
pact_broker-2.69.0 script/prod/redact-data.sql
pact_broker-2.68.1 script/prod/redact-data.sql
pact_broker-2.68.0 script/prod/redact-data.sql
pact_broker-2.67.0 script/prod/redact-data.sql
pact_broker-2.66.0 script/prod/redact-data.sql
pact_broker-2.65.0 script/prod/redact-data.sql
pact_broker-2.64.0 script/prod/redact-data.sql
pact_broker-2.63.0 script/prod/redact-data.sql
pact_broker-2.62.0 script/prod/redact-data.sql
pact_broker-2.61.0 script/prod/redact-data.sql
pact_broker-2.60.1 script/prod/redact-data.sql
pact_broker-2.60.0 script/prod/redact-data.sql
pact_broker-2.59.2 script/prod/redact-data.sql