Cheat sheet for common programming tasks

kubernetes.sh

# Delete all evicted pods.
kubectl get po --all-namespaces --field-selector 'status.phase!=Running' -o yaml | kubectl delete -f -

# List all resources in a namespace.
kubectl api-resources --verbs=list --namespaced -o name | xargs -n 1 kubectl get --show-kind --ignore-not-found -n <namespace>

# Trigger cronjob manually.
kubectl create job --from=cronjob/<cronjob-name> <job-name>

# Run busybox.
kubectl run -i --tty busybox --image=busybox --restart=Never -- sh

postgres.sql

-- Alter default privileges.
ALTER DEFAULT PRIVILEGES IN SCHEMA schema GRANT SELECT ON TABLES TO role;

-- Alter privileges.
GRANT SELECT ON ALL TABLES IN SCHEMA schema TO role;

-- Create role.
CREATE ROLE role;
ALTER ROLE role WITH PASSWORD 'role';
ALTER ROLE role SET search_path = schema;

-- Create schema.
CREATE SCHEMA schema;
ALTER SCHEMA schema OWNER TO user;

To remove trailing whitespace from all fiels using Visual Studio Code:

1. Use Regex
2. Enter " +\n" in the Search bar and "\n" in the Replace bar

To fix a stuck Terraform Kinesis delivery stream:

• update underlying CloudFormation stack manually:
  • rename delivery stream with "-2" suffix, for example
  • switch to a new source stream
• run terraform apply