From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id qG7QGOB0xGNnegEAbAwnHQ (envelope-from ) for ; Sun, 15 Jan 2023 22:49:20 +0100 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id 4Pj1F+B0xGPYxgAAG6o9tA (envelope-from ) for ; Sun, 15 Jan 2023 22:49:20 +0100 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 1E8F3D66E for ; Sun, 15 Jan 2023 22:49:20 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1pHAsC-0005oK-8Z; Sun, 15 Jan 2023 16:49:04 -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 1pHAsB-0005oA-4u for guix-patches@gnu.org; Sun, 15 Jan 2023 16:49:03 -0500 Received: from debbugs.gnu.org ([209.51.188.43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1pHAsA-00050x-Kp for guix-patches@gnu.org; Sun, 15 Jan 2023 16:49:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1pHAsA-0004ea-4N for guix-patches@gnu.org; Sun, 15 Jan 2023 16:49:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils. Resent-From: Felix Gruber Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Sun, 15 Jan 2023 21:49:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 60838 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 60838@debbugs.gnu.org Cc: Felix Gruber X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.167381929117777 (code B ref -1); Sun, 15 Jan 2023 21:49:01 +0000 Received: (at submit) by debbugs.gnu.org; 15 Jan 2023 21:48:11 +0000 Received: from localhost ([127.0.0.1]:59672 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1pHArL-0004ce-D6 for submit@debbugs.gnu.org; Sun, 15 Jan 2023 16:48:11 -0500 Received: from lists.gnu.org ([209.51.188.17]:42418) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1pHArK-0004cQ-3D for submit@debbugs.gnu.org; Sun, 15 Jan 2023 16:48:10 -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 1pHArJ-0005fF-SU for guix-patches@gnu.org; Sun, 15 Jan 2023 16:48:09 -0500 Received: from mout02.posteo.de ([185.67.36.66]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pHArH-0004wK-If for guix-patches@gnu.org; Sun, 15 Jan 2023 16:48:09 -0500 Received: from submission (posteo.de [185.67.36.169]) by mout02.posteo.de (Postfix) with ESMTPS id EF4C02401AF for ; Sun, 15 Jan 2023 22:48:03 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1673819284; bh=Z8J0dm6KP/ASRAJ4+BlZyYi95cljPatF9J3bGVBK8r8=; h=From:To:Cc:Subject:Date:From; b=ZdOv9XFA35yR7jBZUHzCWtD8Dwl3kyyBA3RgjaqdUd7kGpB8fAIg6BvLLZw+uCVNF VAlET2EoOV4lkTwSQY+jPlH3urjDE5/FFabV2A0D6z7c0gvBY/CXHN5FlJO4+3811L O47GJQD1q1sYlWOjCRf4athzxgyCXvyUcp/2AA9Jok+1aRzDwJ+qpL5SXFWy3Juzox UoDf4I7hdlDC8WY6F8crcU+B2SwqYT5AqyGEN3PfAWgisdPMQRP5pZD1TFmq5lU6bo 0uHlf4rldSKgAzzULU3mDy1+bIy5yp2dDCEY4tgihf02yzv/zA1zPubp4RnHJ5xCwI qlbhc1sTdwKvA== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4Nw80M3DH3z9rxB; Sun, 15 Jan 2023 22:48:03 +0100 (CET) From: Felix Gruber Date: Sun, 15 Jan 2023 21:47:53 +0000 Message-Id: <20230115214753.25034-1-felgru@posteo.net> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=185.67.36.66; envelope-from=felgru@posteo.net; helo=mout02.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 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 ARC-Seal: i=1; s=key1; d=yhetil.org; t=1673819360; a=rsa-sha256; cv=none; b=qmQPFyJZXWJsbnDj5nRzuE6kdywMtSKXMYd5s2eBtUlX0PGzXdAoHtluStb2BMp1XPryp7 8JSg5YSkzm/Z5Zc+rdj73TTQGx88O9FZGvoomn1cvVf3EKCk36tBK8N6Enc7EWPcrs711J sjN62DsI9esqPc+5xpyo1KFpmEmLsiSuQ52CPqa4kfc7IHmsdwe8RRfUnQQBBAkh9yHAuM nswzm5YGzzDSD6AcCr9VMB97OdQnZ8ewH/d4YA9zi6Qd1kKFcQEYG64t9Yr4Z9oWjVzL1y vI5InVvlHMjzUNKwaaspqusuu1jdT1KRYXL4IKdKZHLxsi7rom7Qq6SoAY7n5g== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=posteo.net header.s=2017 header.b=ZdOv9XFA; 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=fail reason="SPF not aligned (strict)" header.from=posteo.net (policy=none) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1673819360; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding:resent-cc: resent-from:resent-sender:resent-message-id:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=zUz+wjYdJjpdaAoy70/B6DUxwu030SnnrA3pmbJ8qmE=; b=c0+kn++fLlIgtbpSZNuR53o//fHK0Wo7+NDMLnJ9xXql7fYLgHbdZxUUlP9Ccr9ULQphW5 ThL4ff1Gqh56wGZiaQ0Aeq6zOUE8sC/SvWpv0drRX1zYXuQVMkkbs8CvWKrCLMscxJ694+ VmKemjyjhHMRALQQslDXQj8R3JU2eW9j7FS4yNazSqKBSwPfroWoO+Qve7cVZzTpehaqgk Sr1+m9m2ebxJR90GJdOrtO8GX22l8rJCMZ0MCJR3Mobt1HlHfFiXtfFDDRyGi+NhHxDj/C 7JEgnp1/q+03OO1GcR9DLCn/mhdExX4n7e6ZG5PsQvPQ0ARqQpTVonBlloQ/ag== X-Migadu-Spam-Score: -0.92 X-Spam-Score: -0.92 X-Migadu-Queue-Id: 1E8F3D66E X-Migadu-Scanner: scn1.migadu.com Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=posteo.net header.s=2017 header.b=ZdOv9XFA; 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=fail reason="SPF not aligned (strict)" header.from=posteo.net (policy=none) X-TUID: Kzg7rUJzyTsa This patchset adds new packages for the database exploration and manipulation tools datasette and sqlite-utils, as well as some missing dependencies of those two packages. Since datasette and sqlite-utils do not contain any tests in their pypi source archives, I've tested both on the global power plant database, which can be downloaded as CSV file from https://datasets.wri.org/dataset/globalpowerplantdatabase First, I tested sqlite-utils by converting the power plants CSV file to a sqlite database, using sqlite-utils insert powerplants.db powerplants \ global_power_plant_database.csv --csv Then I used datasette to explore the newly created database with datasette serve powerplants.db -o (Note the -o option to automatically open the datasette instance in your webbrowser.) So far everything seems to work. Felix Gruber (8): gnu: Add python-click-default-group-wheel. gnu: Add python-sqlite-fts4. gnu: Add python-sqlite-utils. gnu: python-janus: Update to 1.0.0. gnu: Add python-pluggy-next. gnu: Add python-asgi-lifespan. gnu: Add python-asgi-csrf. gnu: Add datasette. gnu/packages/databases.scm | 104 ++++++++++++++++++++++++++++++++++++ gnu/packages/python-web.scm | 50 ++++++++++++++++- gnu/packages/python-xyz.scm | 45 ++++++++++++++-- 3 files changed, 195 insertions(+), 4 deletions(-) -- 2.38.1