How to run a dot command like ".import file.csv test"?

Question

evt opened this issue 9 years ago · 2 comments

_, err = db.Exec(".import epf.csv video")
if err != nil {
    log.Fatal(err)
}

Error: near ".": syntax error

Answer 1 · 2016-05-15T22:27:34.000Z

In my experience, those commands are not supported by this library. .schema will result in the same thing.

Answer 2 · 2016-05-16T00:29:45.000Z

it's a feature of sqlite3 command not this library. if you want, you need to implement the feature or call sqlite3 command.

exec.Command("sqlite3", "-cmd", ".import sample.csv ").CaptureOutput()