[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[bug#60838] [PATCH 3/8] gnu: Add python-sqlite-utils.
From: |
Felix Gruber |
Subject: |
[bug#60838] [PATCH 3/8] gnu: Add python-sqlite-utils. |
Date: |
Sun, 15 Jan 2023 21:51:53 +0000 |
* 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
- [bug#60838] [PATCH 0/8] Add datasette and python-sqlite-utils., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 1/8] gnu: Add python-click-default-group-wheel., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 2/8] gnu: Add python-sqlite-fts4., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 4/8] gnu: python-janus: Update to 1.0.0., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 3/8] gnu: Add python-sqlite-utils.,
Felix Gruber <=
- [bug#60838] [PATCH 5/8] gnu: Add python-pluggy-next., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 6/8] gnu: Add python-asgi-lifespan., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 7/8] gnu: Add python-asgi-csrf., Felix Gruber, 2023/01/15
- [bug#60838] [PATCH 8/8] gnu: Add datasette., Felix Gruber, 2023/01/15