# AWS GCP Check

This script is used to import AWS Costs to MySQL instance

* Daily Costs of PingCAP's AWS accounts
    * `pingcap` (Main testing account for DBaaS Testing)
    * `pingcap-dbaas` (Main account for DBaaS)
    * `pingcap-testing` (Account for Misc tests)

## Install AWS CLI and pip packages

```
curl "https://awscli.amazonaws.com/awscli-exe-linux-x86_64.zip" -o "awscliv2.zip"
unzip awscliv2.zip
sudo ./aws/install

pip3 install -r requirements.txt
```

## Initialize DB connection

```
mv db_connect.py.example db_connect.py
```

## Configure AWS CLI

Create files at `~/.aws/credentials` with the following content:

```
[pingcap-test]
aws_access_key_id = ATTACKMEOKAY 
aws_secret_access_key = YOOOOTHISISFAKEKEYEAAAHH
region = us-west-2

[pingcap]
aws_access_key_id = ATTACKMEOKAY
aws_secret_access_key = YOOOOTHISISFAKEKEYEAAAHH
region = us-west-2

[pingcap-dbaas]
aws_access_key_id = ATTACKMEOKAY
aws_secret_access_key = YOOOOTHISISFAKEKEYEAAAHH
region = us-west-2
```

## Use crontab to make it run everyday

```
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin
0 2 * * *  /usr/bin/python3 /path/to/import.py >> /path/to/import.log 2>&1
```

## Demo

![](./demo.png)