trankimvu

Keybase proof

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:

trankimvu

#!/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'}'

trankimvu

#!/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

trankimvu

1. Download docker-compose.yml to dir named sentry
2. Change SENTRY_SECRET_KEY to random 32 char string
3. Run docker-compose up -d
4. Run docker-compose exec sentry sentry upgrade to setup database and create admin user
5. (Optional) Run docker-compose exec sentry pip install sentry-slack if you want slack plugin, it can be done later
6. Run docker-compose restart sentry
7. Sentry is now running on public port 9000

• https://docs.docker.com/compose/compose-file/#env_file

trankimvu

# start
sudo launchctl load /Library/LaunchDaemons/org.jenkins-ci.plist

# stop
sudo launchctl unload /Library/LaunchDaemons/org.jenkins-ci.plist

trankimvu

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

trankimvu

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

trankimvu

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

trankimvu

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
       )

trankimvu

# 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"