Idea: insert-files mechanism for adding extra columns with fixed values
Open
Nobody has claimed this yet.
cli-tool
research
- Dominant language
- Python
- Stars
- 2.2k
- Forks
- 172
- Avg merge
- 9m
- Merged PRs (30d)
- 1
Description
Say for example you want to populate a file_type column with the value gif. That could work like this:
sqlite-utils insert-files gifs.db images *.gif \
-c path -c md5 -c last_modified:mtime \
-c file_type:text:gif --pk=path
So a column defined as a text column with a value that follows a second colon.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the insert-files CLI command and trace how -c column definitions are parsed and applied when files are inserted. Verify the proposed file_type:text:gif syntax against the example, then add coverage showing that each inserted row receives the fixed value while existing column options and --pk=path still work.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- cli, database
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100