diff options
author | Ross Burton <ross.burton@intel.com> | 2019-11-18 16:46:43 +0000 |
---|---|---|
committer | Richard Purdie <richard.purdie@linuxfoundation.org> | 2019-11-21 23:08:20 +0000 |
commit | bb9b44caf6b243f953d20ebbb2f7cc93d03b624b (patch) | |
tree | 9145d52a0d979f5b53fc05689fab4147c7e0e61c | |
parent | dff0a33d3c9b362deef6427d53ed988026242fad (diff) | |
download | poky-bb9b44caf6b243f953d20ebbb2f7cc93d03b624b.tar.gz |
cve-update-db-native: add an index on the CVE ID column
Create an index on the PRODUCTS table which contains a row for each CPE,
drastically increasing the performance of lookups for a specific CVE.
(From OE-Core rev: b4048b05b3a00d85c40d09961f846eadcebd812e)
Signed-off-by: Ross Burton <ross.burton@intel.com>
Signed-off-by: Richard Purdie <richard.purdie@linuxfoundation.org>
-rw-r--r-- | meta/recipes-core/meta/cve-update-db-native.bb | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/meta/recipes-core/meta/cve-update-db-native.bb b/meta/recipes-core/meta/cve-update-db-native.bb index c15534de08..08b18f064f 100644 --- a/meta/recipes-core/meta/cve-update-db-native.bb +++ b/meta/recipes-core/meta/cve-update-db-native.bb | |||
@@ -120,11 +120,14 @@ python do_populate_cve_db() { | |||
120 | 120 | ||
121 | def initialize_db(c): | 121 | def initialize_db(c): |
122 | c.execute("CREATE TABLE IF NOT EXISTS META (YEAR INTEGER UNIQUE, DATE TEXT)") | 122 | c.execute("CREATE TABLE IF NOT EXISTS META (YEAR INTEGER UNIQUE, DATE TEXT)") |
123 | |||
123 | c.execute("CREATE TABLE IF NOT EXISTS NVD (ID TEXT UNIQUE, SUMMARY TEXT, \ | 124 | c.execute("CREATE TABLE IF NOT EXISTS NVD (ID TEXT UNIQUE, SUMMARY TEXT, \ |
124 | SCOREV2 TEXT, SCOREV3 TEXT, MODIFIED INTEGER, VECTOR TEXT)") | 125 | SCOREV2 TEXT, SCOREV3 TEXT, MODIFIED INTEGER, VECTOR TEXT)") |
126 | |||
125 | c.execute("CREATE TABLE IF NOT EXISTS PRODUCTS (ID TEXT, \ | 127 | c.execute("CREATE TABLE IF NOT EXISTS PRODUCTS (ID TEXT, \ |
126 | VENDOR TEXT, PRODUCT TEXT, VERSION_START TEXT, OPERATOR_START TEXT, \ | 128 | VENDOR TEXT, PRODUCT TEXT, VERSION_START TEXT, OPERATOR_START TEXT, \ |
127 | VERSION_END TEXT, OPERATOR_END TEXT)") | 129 | VERSION_END TEXT, OPERATOR_END TEXT)") |
130 | c.execute("CREATE INDEX IF NOT EXISTS PRODUCT_ID_IDX on PRODUCTS(ID);") | ||
128 | 131 | ||
129 | def parse_node_and_insert(c, node, cveId): | 132 | def parse_node_and_insert(c, node, cveId): |
130 | # Parse children node if needed | 133 | # Parse children node if needed |