dbcli / dbcli/litecli

".separator" command missing

Open
#123 0 comments 2 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.