Re: dbext with DBI and SQLite

On Wed, Sep 7, 2016 at 9:24 PM, Josef Fortier <josef.fortier@gmail.com> wrote:

I'm attempting to use DBI with SQLite and am seeing an error:
...
I've tested with a simple perl connection with the same connection string (driver=SQLite:dbname=db.sq3) which works.

Looking at the help, I see examples for mysql, oracle etc, but not for SQLite.

True enough, I just added the following for dbext 24.00

    let g:dbext_default_profile_POPFile = 'type=SQLITE:SQLITE_bin=C:\Programs\POPFile\sqlite.exe:dbname=C:\Programs\POPFile\popfile.db'

    let g:dbext_default_profile_SQLite = 'type=SQLITE:SQLITE_bin=C:\download\OpenSrc\Databases\SQLite\sqlite3.exe:dbname=\vim\test\dbext\sqlite\test.db'

    let g:dbext_default_profile_SQLite_DBI = 'type=DBI:driver=SQLite:conn_parms=dbname=\vim\test\dbext\sqlite\test.db'

    let g:dbext_default_profile_SQLite_diff_cmdT = 'type=SQLITE:dbname=C:\vim\test\dbext\sqlite\test.db:cmd_terminator=~'

 

Has SQLite through the DBI driver been tested?

No, I didn't realize they have a driver.

I just installed it and came up with this which works perfectly.

Here is a normal SQLite standard connection.

    let g:dbext_default_profile_SQLite = 'type=SQLITE:SQLITE_bin=C:\download\OpenSrc\Databases\SQLite\sqlite3.exe:dbname=\vim\test\dbext\sqlite\test.db'

Here is the equivalent using DBI:

    let g:dbext_default_profile_SQLite_DBI = 'type=DBI:driver=SQLite:conn_parms=dbname=\vim\test\dbext\sqlite\test.db'

HTH,

David

--
--
You received this message from the "vim_use" maillist.
Do not top-post! Type your reply below the text you are replying to.
For more information, visit http://www.vim.org/maillist.php

---
You received this message because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.