Sha256: 023a38c495fc317266008d2931036c908bd1faea8a73cefba8b69f5fd368f1ec

Contents?: true

Size: 564 Bytes

Versions: 11

Compression:

Stored size: 564 Bytes

Contents

UPDATE pacticipants SET name = 'pacticipant-' || 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

11 entries across 11 versions & 1 rubygems

Version Path
pact_broker-2.58.0 script/prod/redact-data.sql
pact_broker-2.57.0 script/prod/redact-data.sql
pact_broker-2.56.1 script/prod/redact-data.sql
pact_broker-2.56.0 script/prod/redact-data.sql
pact_broker-2.55.0 script/prod/redact-data.sql
pact_broker-2.54.0 script/prod/redact-data.sql
pact_broker-2.53.0 script/prod/redact-data.sql
pact_broker-2.52.2 script/prod/redact-data.sql
pact_broker-2.52.1 script/prod/redact-data.sql
pact_broker-2.52.0 script/prod/redact-data.sql
pact_broker-2.51.0 script/prod/redact-data.sql