I hereby claim:
- I am trankimvu on github.
- I am vutk (https://keybase.io/vutk) on keybase.
- I have a public key ASB_lJGfj1MvqDKMbcKZr9jMiKb4cMXEqFEjSazFvu2xXQo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
| #!/bin/sh | |
| # Cleanup docker files: untagged containers and images. | |
| # | |
| # Use `docker-cleanup -n` for a dry run to see what would be deleted. | |
| untagged_containers() { | |
| # Print containers using untagged images: $1 is used with awk's print: 0=line, 1=column 1. | |
| # NOTE: "[0-9a-f]{12}" does not work with GNU Awk 3.1.7 (RHEL6). | |
| # Ref: https://github.com/blueyed/dotfiles/commit/a14f0b4b#commitcomment-6736470 | |
| docker ps -a | tail -n +2 | awk '$2 ~ "^[0-9a-f]+$" {print $'$1'}' |
| #!/bin/bash | |
| # Remote all exited container | |
| docker rm $(docker ps -q -f status=exited) | |
| # Remote none tag images (image with tag <none>) | |
| docker images | grep "<none>" | awk '{print $3}' |xargs docker rmi -f | |
| # Remove all images that is not using by any running container | |
| # note: docker ps --format {{.Image} -> List all images of running container then set it as grep pattern |
sentrySENTRY_SECRET_KEY to random 32 char stringdocker-compose up -ddocker-compose exec sentry sentry upgrade to setup database and create admin userdocker-compose exec sentry pip install sentry-slack if you want slack plugin, it can be done laterdocker-compose restart sentry9000| # start | |
| sudo launchctl load /Library/LaunchDaemons/org.jenkins-ci.plist | |
| # stop | |
| sudo launchctl unload /Library/LaunchDaemons/org.jenkins-ci.plist |
| SELECT SUM(ssq_quantity) as ssq_quantity_sold | |
| FROM "transaction" | |
| WHERE "command_type" = 'Bán' | |
| LIMIT 50; | |
| SELECT in_transactions.account_number, in_transactions.transaction_date, in_transactions.command_type, in_transactions.ssq_quantity, out_transactions.transaction_date as selling_date, DATE_PART('day', out_transactions.transaction_date::timestamp - in_transactions.transaction_date::timestamp) as num_of_holding_days | |
| FROM "transaction" as in_transactions | |
| JOIN "transaction" as out_transactions | |
| ON out_transactions.command_type = 'Bán' AND |
| SELECT SUM(ssq_quantity) as ssq_quantity_sold | |
| FROM "transaction" | |
| WHERE "command_type" = 'Bán' | |
| LIMIT 50; | |
| SELECT in_transactions.account_number, in_transactions.transaction_date, in_transactions.command_type, in_transactions.ssq_quantity, out_transactions.transaction_date as selling_date, DATE_PART('day', out_transactions.transaction_date::timestamp - in_transactions.transaction_date::timestamp) as num_of_holding_days | |
| FROM "transaction" as in_transactions | |
| JOIN "transaction" as out_transactions | |
| ON out_transactions.command_type = 'Bán' AND |
| SELECT SUM(ssq_quantity) as ssq_quantity_sold | |
| FROM "transaction" | |
| WHERE "command_type" = 'Bán' | |
| LIMIT 50; | |
| SELECT in_transactions.account_number, in_transactions.transaction_date, in_transactions.command_type, in_transactions.ssq_quantity, out_transactions.transaction_date as selling_date, DATE_PART('day', out_transactions.transaction_date::timestamp - in_transactions.transaction_date::timestamp) as num_of_holding_days | |
| FROM "transaction" as in_transactions | |
| JOIN "transaction" as out_transactions | |
| ON out_transactions.command_type = 'Bán' AND |
| SELECT in_transactions.*, out_transactions.transaction_date as selling_date, DATE_PART('day', out_transactions.transaction_date::timestamp - in_transactions.transaction_date::timestamp) as num_of_holding_days, out_transactions.command_type as selling_command_type | |
| FROM "transaction" as in_transactions | |
| JOIN "transaction" as out_transactions | |
| ON out_transactions.command_type = 'Bán' AND | |
| out_transactions.transaction_date = | |
| (SELECT MIN (inner_transaction.transaction_date) | |
| FROM "transaction" as inner_transaction | |
| WHERE inner_transaction.command_type = 'Bán' AND | |
| inner_transaction.transaction_date >= in_transactions.transaction_date | |
| ) |
| # Ask for the user password | |
| # Script only works if sudo caches the password for a few minutes | |
| sudo true | |
| # Install kernel extra's to enable docker aufs support | |
| # sudo apt-get -y install linux-image-extra-$(uname -r) | |
| # Add Docker PPA and install latest version | |
| # sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 36A1D7869245C8950F966E92D8576A8BA88D21E9 | |
| # sudo sh -c "echo deb https://get.docker.io/ubuntu docker main > /etc/apt/sources.list.d/docker.list" |