From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms8.migadu.com with LMTPS id oOxHMCn+1GWlQwEAqHPOHw:P1 (envelope-from ) for ; Tue, 20 Feb 2024 20:31:53 +0100 Received: from aspmx1.migadu.com ([2001:41d0:303:e224::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id oOxHMCn+1GWlQwEAqHPOHw (envelope-from ) for ; Tue, 20 Feb 2024 20:31:53 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "guix-patches-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-patches-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1708457513; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:resent-cc:resent-from:resent-sender: resent-message-id:list-id:list-help:list-unsubscribe:list-subscribe: list-post; bh=QX/don6xEstInddnliLabO9Xl2JgZWUIBQA/I2goJNI=; b=VY86W5Bdrpq4ndtjvUBEAuG/eyeKo/yFvoo1d6p4SXDQXbUPN+qOtIMwRyzT5qgL986rJe ckS1oI43ceTDwDOdl3qTfFjL6kYA/dKr7Xe0M1occy9dFlwqduhLVY3sALdvUAeItU96pw mf8bUrNaw+2cc1SeexVZZPmxL7nZ8RYdGqXnObImbig+p8mVM+8sakZ4+DdwatkL7Rbj0a wOLhZQygyj6hOmIAIrUMpUeDaz9blIE/e5EuCAGN1tegRRiY4jle9UwXmWG/oQCEPdmU7/ 2O7LEPHf/D1lYgTja+SL1D1JaBxLIjnL//sosyq2kj7dM7P6qy8Dt0isqkQ1Fg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; spf=pass (aspmx1.migadu.com: domain of "guix-patches-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-patches-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Seal: i=1; s=key1; d=yhetil.org; t=1708457513; a=rsa-sha256; cv=none; b=CKi+kvjpsNQ35sAG5wp52vabElazMClO+SFSnijRIJBFACZAVYkEFURXfwlncuJSNCiZnw N6DEtJz//v46iR5fU4ZyoCHbUjxoglD4apNcu8fG2ObSIGTWvTBwOnqp6dQBtmZqtCMcaG RIqeNNUzCNAFdo47/rXonVpl+7nrjlnoGjEu5vI3Pr962xgmEDVXPcH8RBTPVOJCsspKvy 9HG9kAEr4QzDVPyBMahk4NGLum6qgNqqf0u8y9KptdAQy5GMNozPhp4BHz0TNXdbc0Lntf 98WQ7bIBwY8AuZabJcG23mnKSlwsny7EqQmIi7WdNXtfqOKYQi5ol9aIJvpQHQ== Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 8F200180BA for ; Tue, 20 Feb 2024 20:31:53 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rcVqC-0005Hx-8Z; Tue, 20 Feb 2024 14:31:44 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rcVq9-0005HI-6I for guix-patches@gnu.org; Tue, 20 Feb 2024 14:31:41 -0500 Received: from debbugs.gnu.org ([2001:470:142:5::43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1rcVq8-0007ap-Ie for guix-patches@gnu.org; Tue, 20 Feb 2024 14:31:40 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1rcVqU-0002FI-CO for guix-patches@gnu.org; Tue, 20 Feb 2024 14:32:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#69292] [PATCH 0/6] Prepare the database code for use in the daemon Resent-From: Christopher Baines Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 20 Feb 2024 19:32:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 69292 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 69292@debbugs.gnu.org X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.17084575148616 (code B ref -1); Tue, 20 Feb 2024 19:32:02 +0000 Received: (at submit) by debbugs.gnu.org; 20 Feb 2024 19:31:54 +0000 Received: from localhost ([127.0.0.1]:46586 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rcVqM-0002Eu-A7 for submit@debbugs.gnu.org; Tue, 20 Feb 2024 14:31:54 -0500 Received: from lists.gnu.org ([209.51.188.17]:36826) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rcVqK-0002Ek-CI for submit@debbugs.gnu.org; Tue, 20 Feb 2024 14:31:53 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rcVpy-0004sR-6d for guix-patches@gnu.org; Tue, 20 Feb 2024 14:31:30 -0500 Received: from mira.cbaines.net ([2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27]) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rcVpw-0007Xd-Lo for guix-patches@gnu.org; Tue, 20 Feb 2024 14:31:29 -0500 Received: from localhost (unknown [212.132.255.10]) by mira.cbaines.net (Postfix) with ESMTPSA id ED49D27BBE2 for ; Tue, 20 Feb 2024 19:31:25 +0000 (GMT) Received: from felis (localhost.lan [127.0.0.1]) by localhost (OpenSMTPD) with ESMTP id b3a37161 for ; Tue, 20 Feb 2024 19:31:25 +0000 (UTC) User-agent: mu4e 1.10.8; emacs 29.1 From: Christopher Baines Date: Tue, 20 Feb 2024 19:20:45 +0000 Message-ID: <87h6i3lyph.fsf@cbaines.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Received-SPF: pass client-ip=2a01:7e00:e000:2f8:fd4d:b5c7:13fb:3d27; envelope-from=mail@cbaines.net; helo=mira.cbaines.net X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-patches-bounces+larch=yhetil.org@gnu.org Sender: guix-patches-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Scanner: mx12.migadu.com X-Migadu-Spam-Score: -8.14 X-Spam-Score: -8.14 X-Migadu-Queue-Id: 8F200180BA X-TUID: cgZTks109fpv --=-=-= Content-Type: text/plain Content-Transfer-Encoding: quoted-printable These changes prepare the database module for use in a Guile implementation of the guix-daemon. There's quite a few procedures that need adding, but these changes just adapt the existing functionality in to something that can be built on. Christopher Baines (6): store: database: Remove call-with-savepoint and associated code. store: database: Remove with-statement and associated code. store: database: Inline SQL to where it's used. store: database: Stop finalizing prepared statements. store: database: Refactor sqlite-register. store: database: Rename a couple of procedures. .dir-locals.el | 3 - guix/store/database.scm | 273 +++++++++++++++++----------------------- 2 files changed, 112 insertions(+), 164 deletions(-) base-commit: f4af19b037826cad90bbcfe400ad864f028cc7d8 =2D-=20 2.41.0 --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKlBAEBCgCPFiEEPonu50WOcg2XVOCyXiijOwuE9XcFAmXU/gpfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcRHG1haWxAY2Jh aW5lcy5uZXQACgkQXiijOwuE9Xewow//ZcJ4ZCY790jv/n5viw4ucJgi/FFr98JY dHQg0ygLvbtVAaTFROFg55+s8R4iZSPf5UKEYaxS4X8L5s7vSeN5CZirR9cEwGdh LNyIzyvjqsUNxKvc1olI/36DRzduS2PIbW5nYBniO2eJ9RKp/3T8rTI+MBccT03N giHSSM0Q9I/MHbmXzGIFDuoQvP+9+4sUwSVvUfk2gXMp4ZEud0oL4LKP/Jq4AJkI fUqhQbiVhCHQOLR1okMhlFM1M5rSyOT5e+hFOWOVMw/jbl5Yy0YQ6mtCCsSjZi6g UY2HOqnfx/uSUNJdfBcQoag6FBZ9nqSm3Zl7QTa2NGLs0TCEK22GzHhY5Fz/NC9b Hx6Q9zMCC4K1FBhM+1lbNn/gEfNABf3MzQeTdUfqQSVey0Xr7EmGJ3hT6dBcEBNO YPtDoTIAfyerNLG/OdHy/pdefZET/Rsh96A/02MZe5ySK5eBtrLC6jL/b7iSnGbg UhKm9n1uV2AsNglExYE/LkdSLFcHdnzkDfwcD/+T45FHp+lyMadeYvpQEyYeLQ8r mupawMZzcwySmfgYLJzDuRFLZkQW8P2w+TFKdOxiW6q2vgg6Ot7ZLbxLuccTW4n1 K455I8AOl3SBl10zVpM4Pc3/lBeRVqW3gX0riSLGYjYhPF6uu2UPSU16Ymu9ZAMJ H//8GBe5NM4= =rx2e -----END PGP SIGNATURE----- --=-=-=--