From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from eggs.gnu.org ([2001:4830:134:3::10]:34742) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fRDoU-00088l-BG for guix-patches@gnu.org; Fri, 08 Jun 2018 05:36:07 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fRDoS-0006Vc-W8 for guix-patches@gnu.org; Fri, 08 Jun 2018 05:36:06 -0400 Received: from debbugs.gnu.org ([208.118.235.43]:59116) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fRDoS-0006Ub-Rx for guix-patches@gnu.org; Fri, 08 Jun 2018 05:36:04 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1fRDoS-0000cP-MI for guix-patches@gnu.org; Fri, 08 Jun 2018 05:36:04 -0400 Subject: [bug#31755] [PATCH 10/19] database: Replace existing entries in Refs. Resent-Message-ID: From: Ludovic =?UTF-8?Q?Court=C3=A8s?= Date: Fri, 8 Jun 2018 11:34:42 +0200 Message-Id: <20180608093451.27760-10-ludo@gnu.org> In-Reply-To: <20180608093451.27760-1-ludo@gnu.org> References: <20180608093451.27760-1-ludo@gnu.org> List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+kyle=kyleam.com@gnu.org Sender: "Guix-patches" To: 31755@debbugs.gnu.org * guix/store/database.scm (add-reference-sql): Add "OR REPLACE". --- guix/store/database.scm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/guix/store/database.scm b/guix/store/database.scm index bfd2c3626..094dea3ec 100644 --- a/guix/store/database.scm +++ b/guix/store/database.scm @@ -141,7 +141,7 @@ of course. Returns the row id of the row that was modified or inserted." (last-insert-row-id db))))) (define add-reference-sql - "INSERT INTO Refs (referrer, reference) VALUES (:referrer, :reference);") + "INSERT OR REPLACE INTO Refs (referrer, reference) VALUES (:referrer, :reference);") (define (add-references db referrer references) "REFERRER is the id of the referring store item, REFERENCES is a list -- 2.17.1