summaryrefslogblamecommitdiff
path: root/db/query.sql
blob: 9ba172f4b9d60070ba9521059b4f332716d1a95d (plain) (tree) 
e2f6799






87b230e


60aa1b7













1
2
3
4
5
6

7
8

9
10
11
12
13
14
15
16
17
18
19
20
21






                                                    

                      












                                                     
-- name: EnterUsage :exec
INSERT INTO Usage (
  HardwareAddr, StartTime, StopTime, Egress, Ingress
) VALUES (
  $1, $2, $3, $4, $5
);

-- name: GetUsage :one
SELECT SUM(Ingress) AS Ingress, SUM(Egress) AS Egress
FROM Usage;

-- name: EnterDnsBlackList :exec
INSERT INTO DnsBlackList (
  Name
) VALUES (
  $1
);

-- name: GetDnsBlackList :many
SELECT *
FROM DnsBlackList;