A generic set of commands to reference when working with Docker
$ sudo docker run --name mydb -e MYSQL_ROOT_PASSWORD=pass -d mysql:latest
""" | |
# Export FatSecret Weight History CSV | |
A simple script for exporting all FatSecret weight history to CSV. | |
## Installation | |
*Install Dependencies* | |
```sh |
-- show running queries (pre 9.2) | |
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
FROM pg_stat_activity | |
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
ORDER BY query_start desc; | |
-- show running queries (9.2) | |
SELECT pid, age(clock_timestamp(), query_start), usename, query | |
FROM pg_stat_activity | |
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
import os | |
import base64 | |
encoded_env_file = os.environ.get("ENV_FILE") | |
if encoded_env_file != None: | |
decoded_env_file = base64.b64decode(encoded_env_file).decode('utf-8') | |
with open("./" + str(os.environ.get("FILE_NAME", ".env")), "w") as text_file: | |
text_file.write(decoded_env_file) |
for node in $(kubectl get nodes -l cloud.google.com/gke-nodepool=default-pool -o=name); do | |
kubectl drain --force --ignore-daemonsets --delete-local-data --grace-period=10 "$node"; | |
done |
for node in $(kubectl get nodes -l cloud.google.com/gke-nodepool=default-pool -o=name); do | |
kubectl cordon "$node"; | |
done |
gcloud container node-pools create my-pool \ | |
--cluster=my-cluster \ | |
--machine-type=n1-highmem-2 \ | |
--num-nodes 1 --enable-autoscaling | |
--min-nodes 1 --max-nodes 3 |
kubectl create -f ingress-service.yml | |
# Verify exposed IP address is ready | |
kubectl get ingress |