From 87b230e71a830e191dd5c14aa94a025c39792145 Mon Sep 17 00:00:00 2001 From: sinanmohd Date: Sun, 7 Jul 2024 08:32:11 +0530 Subject: api/usage: init --- db/query.sql.go | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'db/query.sql.go') diff --git a/db/query.sql.go b/db/query.sql.go index 7afe159..d6304a7 100644 --- a/db/query.sql.go +++ b/db/query.sql.go @@ -37,3 +37,19 @@ func (q *Queries) EnterUsage(ctx context.Context, arg EnterUsageParams) error { ) return err } + +const getUsage = `-- name: GetUsage :one +SELECT SUM(Ingress) AS Ingress, SUM(Egress) AS Egress FROM Usage +` + +type GetUsageRow struct { + Ingress int64 + Egress int64 +} + +func (q *Queries) GetUsage(ctx context.Context) (GetUsageRow, error) { + row := q.db.QueryRow(ctx, getUsage) + var i GetUsageRow + err := row.Scan(&i.Ingress, &i.Egress) + return i, err +} -- cgit v1.2.3