Skip to main content

Convert CSVW metadata to DuckDB SQL syntax.

Project description

Test Python code

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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

csvw_duckdb-0.0.1.tar.gz (4.1 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

csvw_duckdb-0.0.1-py3-none-any.whl (5.0 kB view details)

Uploaded Python 3

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

Hashes for csvw_duckdb-0.0.1.tar.gz
Algorithm Hash digest
SHA256 06a465795eefe5f16238859165558bc1dd0c5ed26153378f0925c6e3106a4e71
MD5 fdd2bb1cd786be67f27c6ea662b21567
BLAKE2b-256 c1402325bfe8c8c22dee70511647f9788c4c06cd808b0455298f24dcd80cb0b2

See more details on using hashes here.

Provenance

The following attestation bundles were made for csvw_duckdb-0.0.1.tar.gz:

Publisher: publish.yaml on CUREd-Plus/csvw-duckdb

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

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

Hashes for csvw_duckdb-0.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 a1a9c077da4964ad32debe640d5489da2720ba1f8dc1b76aa27e8b09d12edb95
MD5 056d3b4adce91d3bf721b9f980d06c2a
BLAKE2b-256 d26db154f7db3e25040adc4c9afef41884870fcb4946450bfc6c5aee061f0363

See more details on using hashes here.

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

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page