diff options
author | sinanmohd <sinan@sinanmohd.com> | 2024-07-07 15:04:52 +0530 |
---|---|---|
committer | sinanmohd <sinan@sinanmohd.com> | 2024-07-07 15:07:34 +0530 |
commit | 60aa1b7adbd133a5b1679ab2feac4ec17e3b48b5 (patch) | |
tree | 082f64ac3ef625fb364227c138a99ba5c571016b /db/query.sql | |
parent | 38bf443cb2f52bd4cc822e69f9339094d846396f (diff) |
dns: block blacklisted domains in the database
Diffstat (limited to 'db/query.sql')
-rw-r--r-- | db/query.sql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/db/query.sql b/db/query.sql index cfea3f1..9ba172f 100644 --- a/db/query.sql +++ b/db/query.sql @@ -6,4 +6,16 @@ INSERT INTO Usage ( ); -- name: GetUsage :one -SELECT SUM(Ingress) AS Ingress, SUM(Egress) AS Egress FROM Usage; +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; |