From d3ae0601b33a6cb73301e664dd1cceb2faf96df3 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Thu, 17 Feb 2022 23:42:11 -0500
Subject: dbstore: add DbStore#CpeMatchSearch() and backing query

---
 dbstore/sql/cpe-match/search.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 dbstore/sql/cpe-match/search.sql

(limited to 'dbstore/sql')

diff --git a/dbstore/sql/cpe-match/search.sql b/dbstore/sql/cpe-match/search.sql
new file mode 100644
index 0000000..45dd1f6
--- /dev/null
+++ b/dbstore/sql/cpe-match/search.sql
@@ -0,0 +1,11 @@
+SELECT c.cpe23
+
+  FROM cpe_matches a
+  JOIN cpe_match_cpes b
+    ON (b.cpe_match_id = a.cpe_match_id)
+  JOIN cpes c
+    ON (c.cpe_id = b.cpe_id)
+
+ WHERE a.cpe23 = ?
+
+ ORDER BY c.cpe23
-- 
cgit v1.2.3