Re: [sqlite] Running sqlite script in Sqlite db using C++

2013-05-14 Thread Simon Slavin
On 14 May 2013, at 1:59pm, Dulini Atapattu wrote: > If anyway I omit these sqlite commands from script, so is there anyway of > providing the script file to API? If you strip out the lines which start with a dot, everything else in the script should be a legitimate

Re: [sqlite] Running sqlite script in Sqlite db using C++

2013-05-14 Thread fnoyanisi
You may want to consider writing a bash/msdos-batch file and do your stuff from your OS command line Bıt C API is quite handy, you can do most of the stuff with it. On 14/05/2013, at 10:29 PM, Dulini Atapattu wrote: > If anyway I omit these sqlite commands from

Re: [sqlite] Running sqlite script in Sqlite db using C++

2013-05-14 Thread Dulini Atapattu
If anyway I omit these sqlite commands from script, so is there anyway of providing the script file to API? On Tue, May 14, 2013 at 6:07 PM, wrote: > If you are dealing with CSV files, there is a simple API I wrote you can > use. > >

Re: [sqlite] Running sqlite script in Sqlite db using C++

2013-05-14 Thread fnoyanisi
If you are dealing with CSV files, there is a simple API I wrote you can use. https://github.com/fnoyanisi/sqlite3_capi_extensions I was looking for .import functionality for C API, but I ended up writing my own fınctions. On 14/05/2013, at 9:39 PM, Richard Hipp wrote: > On

Re: [sqlite] Running sqlite script in Sqlite db using C++

2013-05-14 Thread Richard Hipp
On Tue, May 14, 2013 at 1:53 AM, Dulini Atapattu wrote: > Hi all, > > I have some sqlite scripts with some sqlite commands like: > >- .headers ON >- .mode CSV etc. > > Is there anyway of running this script in SqliteDB using Sqlite interface > for C++, instead