turicas/rows

[CLI] Generalize filenames into URIs to be able to specify table index

Open

#171 opened on Jul 21, 2016

View on GitHubContributor guide
 (0 comments) (0 reactions) (0 assignees)Python (136 forks)github user discovery
clienhancementhelp wantedquestionutils

Repository metrics

Stars
 (886 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Some formats support more than one table, like HTML, SQLite, XLS, XLSX and ODS. We should support a general URI format to specify it for any of these plugins. Some plugins do not have a table name (SQLite has, HTML does not have always -- depends on id or name properties, which aren't present always).

Some thoughts:

  • sqlite:///path/to/db.sqlite/table_name
  • /path/to/file.xls/table_name ?
  • /path/to/file.xls[table_name] ?
  • /path/to/file.xls[table_index] ?

How to deal with HTTP URLs?

Related to #47.

Contributor guide

Research direction
Investigate how each plugin (HTML, SQLite, XLS, XLSX, ODS) handles multiple tables and propose a unified URI format (e.g., file.format[table index] or file.format/table name). Consider HTTP URLs and backward compatibility.
Tech stack
python
Domain
data
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
PythonURI/URL concepts
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50