# Pingdoomer

## django ping monitor and blacklist

### Models

class Account(models.Model):
    name = fields.CharField()
    externa_id = fields.IntegerField()
    
class Host(models.Model)
    hostname = fields.CharField()
    account = fields.ForeignKey()

### Django rest framework

- POST create
- PUT update
- DEL delete

#### Api (protected by Apikey for writing and other for reading):

v1/api/account/
v1/api/account/<account_id>/hosts/
v1/api/account/<account_id>/hosts/<host_id>/
- GET for obtain all data to graph. and last result

### TimeserieDB:: InfluxDB

I will store the ping stats using [pingparsing](https://pypi.org/project/pingparsing/) into a [influxdb](https://github.com/influxdata/influxdb-python)

$ python
>>> from influxdb import InfluxDBClient
>>> json_body = [
    {
        "measurement": "account_<external_id>",
        "tags": {
            "hostname": "<hostname>",
        },
        "time": "2009-11-10T23:00:00Z",
        "fields": {
            "packet_transmit": 10,
            "packet_receive": 10,
            "packet_loss_rate": 0.0,
            "packet_loss_count": 0,
            "rtt_min": 34.189,
            "rtt_avg": 46.054,
            "rtt_max": 63.246,
            "rtt_mdev": 9.122,
            "packet_duplicate_rate": 0.0,
            "packet_duplicate_count": 0

        }
    }
]
>>> client = InfluxDBClient('localhost', 8086, 'root', 'root', 'example')
>>> client.create_database('example')
>>> client.write_points(json_body)
>>> result = client.query('select * from account_<slug> group by hostname;')
>>> print("Result: {0}".format(result))

### Celery tasks

- scheduler()
- Obtain all host and throw everything to workers

- run(account__name, host)
- execute the ping on host
- parse the ping stats
- insert into influxdb

Celery workers to execute the ping and a celery scheduler to execute each time needed.