Import CSV?

[geo-systems]

Hi team,

I went through the documentation, but couldn't find a way to import a CSV via this library.

Is there a way to invoke the .import special command via the library?

[theogravity]

If the sqlite3 library supports it, we can as well, but need the documentation to know how to do the implementation.

If you can point out the documentation, I can look into it.

Edit:

I noticed that you created an issue on sqlite3 referencing this PR - TryGhost/node-sqlite3#1086

Since it's not in the library, we can't add support to wrap the call.

However, you can extend the Database class to add the method on your side.

// not working code, just a rough idea of how you can do it
import { Database } from 'sqlite'

class CSVDatabase extends Database {
  import () {
    // definition here
  }  
}

const db = new CSVDatabase(config)

await db.open()

db.import()

[theogravity]

Closing as this is more for the sqlite3 library and this project is designed to wrap around it.