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;