From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp11.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id kMKYLYi8QGJhYQEAgWs5BA (envelope-from ) for ; Sun, 27 Mar 2022 21:35:36 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp11.migadu.com with LMTPS id tgPYKoi8QGL5GwEA9RJhRA (envelope-from ) for ; Sun, 27 Mar 2022 21:35:36 +0200 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 3E2B928234 for ; Sun, 27 Mar 2022 21:35:36 +0200 (CEST) Received: from localhost ([::1]:43714 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nYYfm-0007bi-Rd for larch@yhetil.org; Sun, 27 Mar 2022 15:35:34 -0400 Received: from eggs.gnu.org ([209.51.188.92]:59070) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nYYfK-0007AX-7G for guix-patches@gnu.org; Sun, 27 Mar 2022 15:35:06 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:34449) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nYYfF-0003zr-OE for guix-patches@gnu.org; Sun, 27 Mar 2022 15:35:05 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1nYYfF-0001OP-Hr for guix-patches@gnu.org; Sun, 27 Mar 2022 15:35:01 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#54581] Add emacs-sqlite3-api package Resent-From: Maxime Devos Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Sun, 27 Mar 2022 19:35:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 54581 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: To: Roman Scherer Cc: 54581@debbugs.gnu.org Received: via spool by 54581-submit@debbugs.gnu.org id=B54581.16484096725310 (code B ref 54581); Sun, 27 Mar 2022 19:35:01 +0000 Received: (at 54581) by debbugs.gnu.org; 27 Mar 2022 19:34:32 +0000 Received: from localhost ([127.0.0.1]:56579 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYYem-0001Na-AB for submit@debbugs.gnu.org; Sun, 27 Mar 2022 15:34:32 -0400 Received: from laurent.telenet-ops.be ([195.130.137.89]:58254) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1nYYej-0001NQ-TU for 54581@debbugs.gnu.org; Sun, 27 Mar 2022 15:34:31 -0400 Received: from ptr-bvsjgyhxw7psv60dyze.18120a2.ip6.access.telenet.be ([IPv6:2a02:1811:8c09:9d00:3c5f:2eff:feb0:ba5a]) by laurent.telenet-ops.be with bizsmtp id BXaU270054UW6Th01XaUZX; Sun, 27 Mar 2022 21:34:28 +0200 Message-ID: From: Maxime Devos Date: Sun, 27 Mar 2022 21:34:23 +0200 In-Reply-To: <87zglbs1hp.fsf@burningswell.com> References: <87ils0g5uz.fsf@burningswell.com> <87zglbs1hp.fsf@burningswell.com> Content-Type: multipart/signed; micalg="pgp-sha512"; protocol="application/pgp-signature"; boundary="=-iMG2sehPoh8sUYylECfk" User-Agent: Evolution 3.38.3-1 MIME-Version: 1.0 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telenet.be; s=r22; t=1648409668; bh=4oKU5ivFKvTdkncCuRA+M7UHF0cc1DJLzOHtcMuxZq8=; h=Subject:From:To:Cc:Date:In-Reply-To:References; b=XHiwCj4VXhguBlUrpkrQTDxrsXtMdgd6mApMR3JvUPMlCBv7o/EGnb3viNQGlA1r8 oL7Jfkb5/sxqNCvwMiX+rO74EVsNcP0/MNBTbDMiNnu30tC09rXdLwywzdqF+n3Oz4 Xn4e8qRq1BoU3yYCqahqC8q8fSwAc2XdLVMZui5WGGQr5cQFTkGfIrNN+wIFdK3dAQ p5r5tEaR1a/asWiFLIs48RLO9bzSXmaHCyBlICvkR1slRoS3QSCibk27D2be6OZTpx 2seAUOWeFKkBTmPQmBhLWmUMe3W6oICPVK2P9sphwTts8Z03gdvCXzs6OsVPqQHnI2 BaChc4A8FtHHw== 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" X-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1648409736; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:resent-cc:resent-from:resent-sender: resent-message-id:in-reply-to:in-reply-to:references:references: list-id:list-help:list-unsubscribe:list-subscribe:list-post: dkim-signature; bh=4oKU5ivFKvTdkncCuRA+M7UHF0cc1DJLzOHtcMuxZq8=; b=V1QaMlpECCQCv7A507YIeKOn1P7mmf3sWqh9Ti7wbKlC/Au/JjQhuiN7NH3VDIbUJMz+n1 fOgbcRVDOCj00ITiXzvx57v7bqAZUN/7s1i5NYP/nGX4f6a6krU9Ar1rLUlPgR0YvTbU3D L2r9AGXgMBbuEkbCNuBx5HoL+VVexp4wKKNOk13C5hMOYQyHnytCis9B9Q7XKZFWqqPxpT g4RuP+iPjXRNkD5lNqDHwSMDqqtdYisBFrMfd9ZOfgPz+cyB/GCsHdQSBdp0VoyN6tGNNQ ZlKWGoAhfe23QqywTRVm/T9xLq4BrPTd76w4qVyLE0kj9yUiNHYoVD+jbQDGyw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1648409736; a=rsa-sha256; cv=none; b=AMPoFDXMCK0W3cFDeZQxQkfhIh8dNWcNa2eWALj1PsZLBarZtRg20J4TQWPGkw0q13y0pA bbBR6XLIHRUSpN8kkV6WMfb6+GvR0vGzK8J4RDLqwSxq/kxxLxMkOKNIjf6HMp4j+0Wok5 +vqXwwlF/gF7rZQ92tvklCcMROUZBVKQIO1Wz01ceyv8sEMcmdV8JlOd7gFxxlWPMKCwAS 7YdrWKOZyYoRjc+dI1ot7/8YsQWGt0nl8iLL4wAjz96mFAWXfuCjarGZvAG5sfAJXgqJv4 wpAZGlWDUag8INYpJUF9WPm31rKXa/RS8Eb1sTRdjd2Ct6SFJZu6lXco2JRodg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=telenet.be header.s=r22 header.b=XHiwCj4V; dmarc=fail reason="SPF not aligned (relaxed)" header.from=telenet.be (policy=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" X-Migadu-Spam-Score: 3.74 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=telenet.be header.s=r22 header.b=XHiwCj4V; dmarc=fail reason="SPF not aligned (relaxed)" header.from=telenet.be (policy=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" X-Migadu-Queue-Id: 3E2B928234 X-Spam-Score: 3.74 X-Migadu-Scanner: scn1.migadu.com X-TUID: Oh9WUC/XShgb --=-iMG2sehPoh8sUYylECfk Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Roman Scherer schreef op zo 27-03-2022 om 19:55 [+0200]: > But I also wonder if generating the consts.c file is actually better > than just using the checked in consts.c file. The command to generate > the file fetches a web page from the Sqlite website and builds the > consts.c file with this information. And I think this is kind of a > brittle approach. How would this approach would even work with > Software > heritage? As-is, it won't even build, because the build container does not have network access. Something you could try, is adding an origin to the 'inputs': (package (name "emacs-sqlite...") (inputs `(("web-page" ,(origin [...] https://sqlite.org/c3ref/constlist.html [...]))))) and do some appropriate substitutions. Problem is that this page is not stable ... To resolve this, you could modify gen-consts.py to not use the web page to filter things out, basically, delete: useful_codes =3D [] with open(sys.argv[1]) as f: for l in f.readlines(): useful_codes.append(l.rstrip()) and #print("{0}".format(fields[1])) if not fields[1] in useful_codes: #print("{0} excluded".format(fields[1])) continue and strip out the curl stuff from gen-consts.sh. If you do this, don't forget to remove the non-deterministic NOW=3D$(date ...). Greetings, Maxime. --=-iMG2sehPoh8sUYylECfk Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- iI0EABYKADUWIQTB8z7iDFKP233XAR9J4+4iGRcl7gUCYkC8PxccbWF4aW1lZGV2 b3NAdGVsZW5ldC5iZQAKCRBJ4+4iGRcl7jZHAQCttOtKTGAMlpNqykmTNFrp2nu6 dhzvzdsHiC/u3rRPjAD+IIQAbEsjJwCFUaYEZPc4mdvTWjyoI7jqi+5HLJdiDQo= =4jmM -----END PGP SIGNATURE----- --=-iMG2sehPoh8sUYylECfk--