Convert CSVW metadata to DuckDB SQL syntax.
Project description
CSVW DuckDB tool
Convert a CSVW document (CSV metadata) to a DuckDB query to load a CSV file into a database.
See also: Python csvw package.
Installation
pip install csvw-duckdb
Usage
To use this tool, call it from the command line and provide the path of the CSVW document. The SQL code will be written to the screen.
csvw-duckdb --help
usage: csvw-duckdb [-h] [--loglevel {DEBUG,INFO,WARNING,ERROR,CRITICAL}] [--version] csvw_path
Load a CSVW document and generate simple SQL SELECT statements. One SQL file will be generated per table in the CSVW table group.
positional arguments:
csvw_path CSVW file
options:
-h, --help show this help message and exit
--loglevel {DEBUG,INFO,WARNING,ERROR,CRITICAL}, -l {DEBUG,INFO,WARNING,ERROR,CRITICAL}
--version show program's version number and exi
Examples
csvw-duckdb my_metadata.csvw
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file csvw_duckdb-0.0.1.tar.gz.
File metadata
- Download URL: csvw_duckdb-0.0.1.tar.gz
- Upload date:
- Size: 4.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.0.1 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
06a465795eefe5f16238859165558bc1dd0c5ed26153378f0925c6e3106a4e71
|
|
| MD5 |
fdd2bb1cd786be67f27c6ea662b21567
|
|
| BLAKE2b-256 |
c1402325bfe8c8c22dee70511647f9788c4c06cd808b0455298f24dcd80cb0b2
|
Provenance
The following attestation bundles were made for csvw_duckdb-0.0.1.tar.gz:
Publisher:
publish.yaml on CUREd-Plus/csvw-duckdb
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
csvw_duckdb-0.0.1.tar.gz -
Subject digest:
06a465795eefe5f16238859165558bc1dd0c5ed26153378f0925c6e3106a4e71 - Sigstore transparency entry: 156638602
- Sigstore integration time:
-
Permalink:
CUREd-Plus/csvw-duckdb@3b542b16e0ee98bc8788aead81af53d03c228529 -
Branch / Tag:
refs/tags/v0.0.1 - Owner: https://github.com/CUREd-Plus
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yaml@3b542b16e0ee98bc8788aead81af53d03c228529 -
Trigger Event:
release
-
Statement type:
File details
Details for the file csvw_duckdb-0.0.1-py3-none-any.whl.
File metadata
- Download URL: csvw_duckdb-0.0.1-py3-none-any.whl
- Upload date:
- Size: 5.0 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.0.1 CPython/3.12.8
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a1a9c077da4964ad32debe640d5489da2720ba1f8dc1b76aa27e8b09d12edb95
|
|
| MD5 |
056d3b4adce91d3bf721b9f980d06c2a
|
|
| BLAKE2b-256 |
d26db154f7db3e25040adc4c9afef41884870fcb4946450bfc6c5aee061f0363
|
Provenance
The following attestation bundles were made for csvw_duckdb-0.0.1-py3-none-any.whl:
Publisher:
publish.yaml on CUREd-Plus/csvw-duckdb
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
csvw_duckdb-0.0.1-py3-none-any.whl -
Subject digest:
a1a9c077da4964ad32debe640d5489da2720ba1f8dc1b76aa27e8b09d12edb95 - Sigstore transparency entry: 156638605
- Sigstore integration time:
-
Permalink:
CUREd-Plus/csvw-duckdb@3b542b16e0ee98bc8788aead81af53d03c228529 -
Branch / Tag:
refs/tags/v0.0.1 - Owner: https://github.com/CUREd-Plus
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
publish.yaml@3b542b16e0ee98bc8788aead81af53d03c228529 -
Trigger Event:
release
-
Statement type: