Re: [sqlite] Using CSV.c

[Warren Young]

On Jan 10, 2017, at 3:03 AM, tbuck...@frontier.com wrote:
> 
> I can manually do it with the dot (.) tools, but I want to automate this by 
> executing one exe file.

Ah, I see, you want to reinvent the wheel[*] because your platform of choice 
doesn’t have shell scripts.  Got it.

In that case, I’d dig into the implementation for those existing commands, and 
wrap them the same way src/shell.c in the SQLite source base does.


[*]: https://sqlite.org/cli.html#csv_import
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using CSV.c

[Edward Lau]

Maybe the following example may help:


https://github.com/elau1004/TFR4SQLite/blob/master/src/test/031_testColumn.init


Check out the wiki too regarding using the "-init" command line option.




-Original Message-
From: tbuckner 
To: sqlite-users 
Sent: Tue, Jan 10, 2017 2:03 am
Subject: [sqlite] Using CSV.c

Hello,I am having a little trouble implementing the csv.c program for SQLite.  
Are their any programming examples available?All I want to do is import a csv 
file to a database, sort the file and output the results to another csv file 
all in c code.  I can manually do it with the dot (.) tools, but I want to 
automate this by executing one exe 
file.Tom...___sqlite-users mailing 
listsqlite-users@mailinglists.sqlite.orghttp://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using CSV.c

[Don V Nielsen]

I would recommend using a script or batch file to automate the process
using the command line tool. It would be easier to maintain and remove a
level or two of complexity.


On Tue, Jan 10, 2017 at 4:03 AM, tbuck...@frontier.com <
tbuck...@frontier.com> wrote:

> Hello,I am having a little trouble implementing the csv.c program for
> SQLite.  Are their any programming examples available?
> All I want to do is import a csv file to a database, sort the file and
> output the results to another csv file all in c code.  I can manually do it
> with the dot (.) tools, but I want to automate this by executing one exe
> file.Tom...
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users