Skip to content

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

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Closed
evt opened this issue May 15, 2016 · 3 comments
Closed

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

evt opened this issue May 15, 2016 · 3 comments

Comments

@evt
Copy link

evt commented May 15, 2016

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

Error: near ".": syntax error

@otoolep
Copy link
Contributor

otoolep commented May 15, 2016

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

@mattn
Copy link
Owner

mattn commented May 16, 2016

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()

gjrtimmer added a commit to gjrtimmer/go-sqlite3 that referenced this issue May 26, 2018
Compile Section Closes mattn#175
Compile Section Closes mattn#201
Compile Section Closes mattn#206
Compile Section Closes mattn#404
Compile Section Closes mattn#217
Compile Section Closes mattn#224
Compile Section Closes mattn#234
Compile Section Closes mattn#242
Feature table Closes mattn#255
Description Section Closes mattn#232
Golang:1.6 not supported Closes mattn#272
Golang:1.5 not supported + compilation section Closes mattn#283
usleep Implemented Closes mattn#285
FAQ Section Closes mattn#289
Compile Section closes mattn#295
FAQ Section Closes mattn#305
PR339 Closes mattn#318 mattn#321
Compilation Section Closes mattn#341
PR407 Closes mattn#364
Feature `sqlite_vtable` Closes mattn#393
Compile Section Closes mattn#416
sqlite_trace feature Closes mattn#433
Compilation Section Closes mattn#435
Compilation Section Closes mattn#443
Golang:1.6 Not Supported Closes mattn#445
Compilation Section Closes mattn#451
Compilation Section Closes mattn#467
Compilation Section Closes mattn#491
Compilation Section Closes mattn#495
Compilation Section Closes mattn#505
Compilation Section Closes mattn#557
Compilation Section Closes mattn#560
@mattn mattn closed this as completed in c9394b1 May 27, 2018
@dileepamax
Copy link

dileepamax commented Dec 17, 2024

Is it possible to get support for dot command future like

r, err = db.Exec(".tables")
if err != nil {
log.Fatal(err)
}

or

r, err = db.Query(".schema")
if err != nil {
log.Fatal(err)
}

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants