aboutsummaryrefslogtreecommitdiff
path: root/src/create_database.nim
blob: f210c6fbc04a3adfdbfde79b504cea3c4e69a793 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
import os
import osproc
import strformat
import strutils

# This database will store the following data
# - 1 year worth of samples each 15 minutes
# - average of each day for 10 years
# - min of each day for 10 years
# - max of each day for 10 years

let
    database = getAppDir().parentDir() / "database" / paramStr(1) & ".rrd"
    step = 15 * 60
    heartbeat = 20 * 60
    secondsInDay = 24 * 60 * 60
    samplesInDay = secondsInDay div step
    secondsInYear = 365 * secondsInDay
    samplesInYear = secondsInYear div step
    daysIn10Years = 365 * 10

if fileExists(database):
    echo(&"error: database '{database}' exists")
    quit(1)

echo(&"step = {step} seconds")
echo(&"heartbeat = {heartbeat} seconds")
echo(&"samplesInYear = {samplesInYear}")
echo(&"samplesInDay = {samplesInDay}")
echo(&"daysIn10Years = {daysIn10Years}")

let args = [
    "create", database,
    "--start", "now",
    "--step", $step,
    &"DS:temperature:GAUGE:{heartbeat}:-40:40",
    &"DS:humidity:GAUGE:{heartbeat}:0:100",
    &"DS:pressure:GAUGE:{heartbeat}:U:U",
    &"DS:battery:GAUGE:{heartbeat}:0:4",
    &"RRA:AVERAGE:0.5:1:{samplesInYear}",
    &"RRA:MIN:0.5:{samplesInDay}:{daysIn10Years}",
    &"RRA:MAX:0.5:{samplesInDay}:{daysIn10Years}",
    &"RRA:AVERAGE:0.5:{samplesInDay}:{daysIn10Years}",
]

createDir(database.parentDir())

echo("rrdtool " & args.join(" "))

quit(execCmd("rrdtool " & args.join(" ")))