".separator" command missing
- Dominant language
- Python
- Stars
- 3.3k
- Forks
- 95
- PR merge metrics
- No merged PRs in 30d
Description
When trying to load a CSV into a table, one might have to define the CSV-Separator used. Litecli throws a Syntaxerror.
in sqlite3 (working)
sqlite> .mode csv
sqlite> .separator ,
sqlite> .import examples/test.csv test
sqlite> .schema
CREATE TABLE test(
"field_a" TEXT,
"field_b" TEXT,
"field_c" TEXT,
"field_d" TEXT,
"field_e" TEXT
);
in litecli (not working)
csvtest.db> .mode csv
Changed table format to csv
Time: 0.000s
csvtest.db> .separator ,
near ".": syntax error
Contributor guide
Research direction
Reproduce the issue from the .mode csv and .separator command sequence shown in the report, then trace the CLI entry point that handles dot commands. The work is done when .separator accepts a delimiter in litecli and the subsequent CSV import succeeds without a syntax error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- cli, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100