unofficial mirror of guix-patches@gnu.org 
 help / color / mirror / code / Atom feed
From: Felix Gruber <felgru@posteo.net>
To: 60838@debbugs.gnu.org
Cc: Felix Gruber <felgru@posteo.net>
Subject: [bug#60838] [PATCH 3/8] gnu: Add python-sqlite-utils.
Date: Sun, 15 Jan 2023 21:51:53 +0000	[thread overview]
Message-ID: <20230115215153.25235-1-felgru@posteo.net> (raw)
In-Reply-To: <20230115214753.25034-1-felgru@posteo.net>

* gnu/packages/databases.scm (python-sqlite-utils): New variable.
---
 gnu/packages/databases.scm | 39 ++++++++++++++++++++++++++++++++++++++
 1 file changed, 39 insertions(+)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index 375d34b051..9831a3b761 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -3575,6 +3575,45 @@ (define-public python-sqlite-fts4
 documents indexed using the SQLite's FTS4 full text search extension.")
     (license license:asl2.0)))
 
+(define-public python-sqlite-utils
+  (package
+    (name "python-sqlite-utils")
+    (version "3.30")
+    (source (origin
+              (method url-fetch)
+              (uri (pypi-uri "sqlite-utils" version))
+              (sha256
+               (base32
+                "0cvfbyvkh7gjh3ws3gj2yhjhr459nsz6c5vrkxjlad7isl95q01h"))))
+    (build-system python-build-system)
+    (arguments
+     '(#:tests? #f)) ; No tests provided in pypi package.
+    (propagated-inputs (list python-click python-click-default-group-wheel
+                             python-dateutil python-sqlite-fts4
+                             python-tabulate))
+    (home-page "https://github.com/simonw/sqlite-utils")
+    (synopsis
+     "CLI tool and Python utility functions for manipulating SQLite databases")
+    (description
+     "This package provides a CLI tool and Python utility functions for
+manipulating SQLite databases.
+
+It's main features are:
+@itemize
+@item Pipe JSON (or CSV or TSV) directly into a new SQLite database file,
+      automatically creating a table with the appropriate schema.
+@item Run in-memory SQL queries, including joins, directly against data
+      in CSV, TSV or JSON files and view the results.
+@item Configure SQLite full-text search against your database tables and
+      run search queries against them, ordered by relevance.
+@item Run transformations against your tables to make schema changes
+      that SQLite ALTER TABLE does not directly support, such as
+      changing the type of a column.
+@item Extract columns into separate tables to better normalize your
+      existing data.
+@end itemize")
+    (license license:asl2.0)))
+
 (define-public python-pickleshare
   (package
     (name "python-pickleshare")
-- 
2.38.1





  parent reply	other threads:[~2023-01-15 21:53 UTC|newest]

Thread overview: 38+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2023-01-15 21:47 [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Felix Gruber
2023-01-15 21:50 ` [bug#60838] [PATCH 1/8] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-22  1:04   ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-01-15 21:51 ` [bug#60838] [PATCH 2/8] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-22  1:05   ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-01-15 21:51 ` Felix Gruber [this message]
2023-03-22  1:08   ` Maxim Cournoyer
2023-01-15 21:52 ` [bug#60838] [PATCH 4/8] gnu: python-janus: Update to 1.0.0 Felix Gruber
2023-01-15 21:52 ` [bug#60838] [PATCH 5/8] gnu: Add python-pluggy-next Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 6/8] gnu: Add python-asgi-lifespan Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 7/8] gnu: Add python-asgi-csrf Felix Gruber
2023-01-15 21:53 ` [bug#60838] [PATCH 8/8] gnu: Add datasette Felix Gruber
2023-03-17 19:19 ` [bug#60838] [PATCH v2 0/7] Add datasette and python-sqlite-utils Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 1/7] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 2/7] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 3/7] gnu: Add python-sqlite-utils Felix Gruber
2023-03-17 19:19   ` [bug#60838] [PATCH v2 4/7] gnu: Add python-pluggy-next Felix Gruber
2023-03-22  1:13     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 5/7] gnu: Add python-asgi-lifespan Felix Gruber
2023-03-22  1:17     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 6/7] gnu: Add python-asgi-csrf Felix Gruber
2023-03-22  1:19     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-17 19:19   ` [bug#60838] [PATCH v2 7/7] gnu: Add datasette Felix Gruber
2023-03-22  1:26     ` [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-18  8:13   ` [bug#60838] [PATCH v2 0/7] " Liliana Marie Prikler
2023-03-22  0:59 ` [bug#60838] [PATCH 0/8] " Maxim Cournoyer
2023-03-26 19:43   ` [bug#60838] [PATCH v3 0/9] " Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 1/9] gnu: Add python-click-default-group-wheel Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 2/9] gnu: Add python-sqlite-fts4 Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 3/9] gnu: Add python-sqlite-utils Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 4/9] gnu: Add python-asgi-lifespan Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 5/9] gnu: Add python-asgi-csrf Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 6/9] gnu: Add python-trustme-next Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 7/9] gnu: Add python-cogapp Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 8/9] gnu: python-pytest-7.1: Depend on python-pluggy-next Felix Gruber
2023-03-26 19:43     ` [bug#60838] [PATCH v3 9/9] gnu: Add datasette Felix Gruber
2023-03-29 17:22       ` bug#60838: [PATCH 0/8] Add datasette and python-sqlite-utils Maxim Cournoyer
2023-03-29 19:38         ` [bug#60838] " Felix Gruber

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://guix.gnu.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20230115215153.25235-1-felgru@posteo.net \
    --to=felgru@posteo.net \
    --cc=60838@debbugs.gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/guix.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).