From d08ae9402429bfca69d72c7a7d99975aa356539f Mon Sep 17 00:00:00 2001
From: sinanmohd <sinan@sinanmohd.com>
Date: Mon, 8 Jul 2024 06:05:08 +0530
Subject: bpf/filter: init

---
 db/query.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'db/query.sql')

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;
-- 
cgit v1.2.3