diff options
author | sinanmohd <sinan@sinanmohd.com> | 2024-07-08 06:05:08 +0530 |
---|---|---|
committer | sinanmohd <sinan@sinanmohd.com> | 2024-07-08 06:05:08 +0530 |
commit | d08ae9402429bfca69d72c7a7d99975aa356539f (patch) | |
tree | bb4d4d4ddc28030ab419eb4ce3377c3d0426af9e /db/query.sql | |
parent | 3da7837e2e51763b00b2f7af80973b2d5d61933d (diff) |
bpf/filter: init
Diffstat (limited to 'db/query.sql')
-rw-r--r-- | db/query.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/db/query.sql b/db/query.sql index f4b17dd..624442f 100644 --- a/db/query.sql +++ b/db/query.sql @@ -21,3 +21,17 @@ WHERE Name = $1; -- name: GetDnsBlackList :many SELECT * FROM DnsBlackList; + +-- name: EnterMacBlackList :exec +INSERT INTO MacBlackList ( + HardwareAddr +) VALUES ( + $1 +); + +-- name: DeleteMacBlackList :exec +DELETE FROM MacBlackList +WHERE HardwareAddr = $1; + +-- name: GetMacBlackList :many +SELECT * FROM MacBlackList; |