From patchwork Mon Dec 16 16:00:02 2019 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Armin Kuster X-Patchwork-Id: 181745 Delivered-To: patch@linaro.org Received: by 2002:ac9:44c4:0:0:0:0:0 with SMTP id t4csp4482172och; Mon, 16 Dec 2019 08:02:22 -0800 (PST) X-Google-Smtp-Source: APXvYqzjPCs8mUlk4XiwGzpjD/o6qy3Gx5mWeyfUpUssF5wXWOLW+NR1gsdVreLesiOB+Qnddb92 X-Received: by 2002:a17:902:9f88:: with SMTP id g8mr16985088plq.100.1576512142054; Mon, 16 Dec 2019 08:02:22 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1576512142; cv=none; d=google.com; s=arc-20160816; b=T7dEGQO/gne5w7niUPQepMePMTNai5rCFDzbDl7KHemPwxBG2LZ5Tpt6PAmeLOBMVs YvzKPmoCjQf5158sNyDLEPWeU+bz22T3cLSUslFPDekEbwj0AnPYVutoAGeXctpAfOOT hVJumyZhih0FEg9fzNBlppP5PYYsKx+X86yTogY1WXyJW52IA5miQKCNphAeSabh8oB5 ACzeB/YntqZEa5btqlrnqsNZuy+TY61zfx6Io5iIwFneXB9YZZKT8FGayTrqJD/bOwyC 5J7tNOHGgTUyVLQ0zl2omtjAcSkNfi+H7kHiKH2ez95Gqf94DD72GegGodBCrIMeDraR TMqw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=errors-to:sender:content-transfer-encoding:mime-version :list-subscribe:list-help:list-post:list-archive:list-unsubscribe :list-id:precedence:subject:references:in-reply-to:message-id:date :to:from:dkim-signature:delivered-to; bh=kbAFI19BVgh819QgX8ZGRrxKkVvWxdlIJmlDXkkJboI=; b=0DLX0qekNMMOJoj/OJw2xaio7wYJZLuRSh2S62QgutncPrDXMl4wvqAdwKAESxOWlj B4CkbdxZemgF8g/200Adn6zUEu70SuwUEWeFkpGXSY2Xr4gEOHMwsa0F/uV/VfWbCmUW veBxnO2P1P7/SjYPSqAoSYnaXQLGng+rl2T5wNLKKgK6uYcN0FEKvQA2JG09DbKM9f4x VRk2z/V6G8Dt41H26a4LG0Exk0z/hjHscpgjfzRfBTb4UjZ/0J9x/xsILcDRWH1GVz6o +isUAccJ99QKzCPUgkUuyyztHvnGF80XKSMvshRMpO0eDu8S/7c05ilaz65os6hxVTjY NFsg== ARC-Authentication-Results: i=1; mx.google.com; dkim=neutral (body hash did not verify) header.i=@gmail.com header.s=20161025 header.b=aCdfNsG3; spf=pass (google.com: best guess record for domain of openembedded-core-bounces@lists.openembedded.org designates 140.211.169.62 as permitted sender) smtp.mailfrom=openembedded-core-bounces@lists.openembedded.org; dmarc=fail (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com Return-Path: Received: from mail.openembedded.org (mail.openembedded.org. [140.211.169.62]) by mx.google.com with ESMTP id x5si17310000pll.276.2019.12.16.08.02.21; Mon, 16 Dec 2019 08:02:22 -0800 (PST) Received-SPF: pass (google.com: best guess record for domain of openembedded-core-bounces@lists.openembedded.org designates 140.211.169.62 as permitted sender) client-ip=140.211.169.62; Authentication-Results: mx.google.com; dkim=neutral (body hash did not verify) header.i=@gmail.com header.s=20161025 header.b=aCdfNsG3; spf=pass (google.com: best guess record for domain of openembedded-core-bounces@lists.openembedded.org designates 140.211.169.62 as permitted sender) smtp.mailfrom=openembedded-core-bounces@lists.openembedded.org; dmarc=fail (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com Received: from ec2-34-214-78-129.us-west-2.compute.amazonaws.com (localhost [127.0.0.1]) by mail.openembedded.org (Postfix) with ESMTP id 900C37FE10; Mon, 16 Dec 2019 16:00:47 +0000 (UTC) X-Original-To: openembedded-core@lists.openembedded.org Delivered-To: openembedded-core@lists.openembedded.org Received: from mail-pj1-f51.google.com (mail-pj1-f51.google.com [209.85.216.51]) by mail.openembedded.org (Postfix) with ESMTP id DFA877FDCF for ; Mon, 16 Dec 2019 16:00:22 +0000 (UTC) Received: by mail-pj1-f51.google.com with SMTP id ep17so3167568pjb.4 for ; Mon, 16 Dec 2019 08:00:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:date:message-id:in-reply-to:references; bh=8Le6d7C523lNb84zEbuxPQle3X0mR+I5HfoAKRveFIs=; b=aCdfNsG38KCFe8j9XkrxvlnTM/OLCTYXorhcmHF8A+WMYBhIyIjSmd96Bw50vico2D WZiybBCmaCXCwr/MivQXXL5Au2G1++ryskDV90eoARC9xZAUF1sDBWcN+j69C2dYxHRi qtVd2lFvHWuXh0r+ynq8RGcry6JTmup+jh6fdD6iaf5Xav5tOWBNb+cbN3+kGLJ3DjQO X33jzUxITVQw2OO0P6AXd/P9wiPMIXO5ww8abTzyRQMxGReLkbDDgIzaVAawNOOa1TvV t+kaqbHbp2iHKbG7Dh0bf6LgcyvhoZ7eABbQcwUA6jdouYYBJqNLiAUunNaiKSzKMuY3 5PrQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:date:message-id:in-reply-to :references; bh=8Le6d7C523lNb84zEbuxPQle3X0mR+I5HfoAKRveFIs=; b=FMrneETUu7YK4PdjAx7lptlzAQYECOROloENTqtERkML0E+qg4c6XTN0uIuc+lWdfp pmOuC2pXGhsO0TNuXD/4ZAqrnluFaRbNf46kcRJdWJcAs0KJJbH44nQ9eN+s6s0ueQWw LEX2GjvDnZNpLck/FfOQk1xA6fOwWhaghNsnCNpfoLhjpLtIdzD3szWWw033/SOk9geZ 92xqk91PjTk1UabmE/cKDu4Vnyi0e8l26o3k2rw0NWZim9SbqD4MszOd6zxnEuwYFXap wo5o0yp3cHYIF0bzHnUgKPgSR5DI0AUncG1Edd9r5dQUqRgGfKK75UMZWZC32xj1JXQf /39A== X-Gm-Message-State: APjAAAXRNWB6Z5HhC4OqugYeEaD4NxtKsu6VRCputVeWWUKaMn5VFhub C9nyoFAIHQU8aNeRYVnAspPrJd+DKy8= X-Received: by 2002:a17:902:b08d:: with SMTP id p13mr1884999plr.109.1576512023861; Mon, 16 Dec 2019 08:00:23 -0800 (PST) Received: from akuster-ThinkPad-T460s.mvista.com ([2601:202:4180:a5c0:e5c5:31c9:a010:f145]) by smtp.gmail.com with ESMTPSA id g6sm19568697pjl.25.2019.12.16.08.00.23 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-SHA bits=128/128); Mon, 16 Dec 2019 08:00:23 -0800 (PST) From: Armin Kuster To: openembedded-core@lists.openembedded.org Date: Mon, 16 Dec 2019 08:00:02 -0800 Message-Id: <27ee95bd1ec2076509cfc2230eadb876fb35d6c2.1576511913.git.akuster808@gmail.com> X-Mailer: git-send-email 2.7.4 In-Reply-To: References: Subject: [OE-core] [thud 12/18] cve-update-db-native: add an index on the CVE ID column X-BeenThere: openembedded-core@lists.openembedded.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: Patches and discussions about the oe-core layer List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , MIME-Version: 1.0 Sender: openembedded-core-bounces@lists.openembedded.org Errors-To: openembedded-core-bounces@lists.openembedded.org From: Ross Burton 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 Signed-off-by: Richard Purdie Signed-off-by: Armin Kuster --- meta/recipes-core/meta/cve-update-db-native.bb | 3 +++ 1 file changed, 3 insertions(+) -- 2.7.4 -- _______________________________________________ Openembedded-core mailing list Openembedded-core@lists.openembedded.org http://lists.openembedded.org/mailman/listinfo/openembedded-core diff --git a/meta/recipes-core/meta/cve-update-db-native.bb b/meta/recipes-core/meta/cve-update-db-native.bb index c15534d..08b18f0 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() { def initialize_db(c): c.execute("CREATE TABLE IF NOT EXISTS META (YEAR INTEGER UNIQUE, DATE TEXT)") + c.execute("CREATE TABLE IF NOT EXISTS NVD (ID TEXT UNIQUE, SUMMARY TEXT, \ SCOREV2 TEXT, SCOREV3 TEXT, MODIFIED INTEGER, VECTOR TEXT)") + c.execute("CREATE TABLE IF NOT EXISTS PRODUCTS (ID TEXT, \ VENDOR TEXT, PRODUCT TEXT, VERSION_START TEXT, OPERATOR_START TEXT, \ VERSION_END TEXT, OPERATOR_END TEXT)") + c.execute("CREATE INDEX IF NOT EXISTS PRODUCT_ID_IDX on PRODUCTS(ID);") def parse_node_and_insert(c, node, cveId): # Parse children node if needed