SQLite importing CSV with custom separator

Edit

Author: Meet Rajesh Gor

#sqlite

explaination about how i learned how to write a command for importing a csv into a sqlite3 db with cusotm Separator with a single command inline

Introduction

I was exploring some Issues that I can solve given the context of the problem and the intution for the solution.

I have some github repositories that I always look for to learn more. Some of them are:

So, navigating around for a few minutes, I landed on this issue.

The issue is really well explained in terms of what the feature is to be added, how the usage should be, which for a contributor is half the job done.

What?

The turso-cli is a CLI for Turso that is used to manage libsql databases with the turso platform.

This issue is about adding a flag to the db create command to allow the user to pass in a custom separator while imporing a csv file into a sqlite3 database.

The only puzzle piece left is to answer the question how?

How?

So, I went in to the Codebase and found where the db create command has been handled and landed on this file

While controbuting to open source, I try to do the small steps and solve try to maintain the excitment with that progress. Because if you cannot find the solution, you try to procastinate and in the end nothing gets accomplished. So, breaking down the problem into small chunks is much helpful than solving the entire problem.

In this case, I tried to add the flag in the cli which is pretty straight forward. We just add one more entry in the list of flags in the db create command. This step is just to add a functional CLI for taking the input of csv-separator string, however, this won't do anything for the functionality part of things, just allow the user to specify the separator/delimitor to use for parsing the CSV file.

Currently, the command that turso db create uses under the hood for creating a db from a csv file is:


bash
sqlite3 "-csv" "dbName" ".import <FileName> <TableName>"

The above command is found in the group flag file. To parse in the separator, we can use another string as .separator ";", here the ; is the character that should be used as the separator for the csv file into the db.


bash
sqlite3 "-csv" "dbname" ".separator" ";" ".import <FileName> <TableName>"

Thank you, Happy Coding :)

<a class='prev' href='/git-ssh-multiple-accounts'>

    <svg width="50px" height="50px" viewbox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
        <path d="M13.5 8.25L9.75 12L13.5 15.75" stroke="var(--prevnext-color-angle)" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"> </path>
    </svg>
    <div class='prevnext-text'>
        <p class='prevnext-subtitle'>prev</p>
        <p class='prevnext-title'>Adding SSH Keys for Multiple Accounts in Git</p>
    </div>
</a>

<a class='next' href='/docker-port-forward'>

    <div class='prevnext-text'>
        <p class='prevnext-subtitle'>next</p>
        <p class='prevnext-title'>Docker Port Forwarding</p>
    </div>
    <svg width="50px" height="50px" viewbox="0 0 24 24" fill="none" xmlns="http://www.w3.org/2000/svg">
        <path d="M10.5 15.75L14.25 12L10.5 8.25" stroke="var(--prevnext-color-angle)" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"></path>
    </svg>
</a>