Skip to content

Instantly share code, notes, and snippets.

@delfer

delfer/drone-clone-secrets.sql

Last active January 26, 2018 08:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save delfer/52902497e7bc3afb41810d84dcf5d1b6 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save delfer/52902497e7bc3afb41810d84dcf5d1b6 to your computer and use it in GitHub Desktop.
Download ZIP
drone-clone-secrets
Raw
drone-clone-secrets.sql
DELETE FROM secrets WHERE secret_repo_id!=120;
INSERT INTO secrets (secret_repo_id, secret_name, secret_value,secret_images,secret_events,secret_skip_verify,secret_conceal)
SELECT repo_id, secret_name, secret_value,secret_images,secret_events,secret_skip_verify,secret_conceal
FROM repos, secrets
WHERE repo_active AND repo_id != 120 AND secret_repo_id=120;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment