Re: [sqlite] Using CSV.c
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
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
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
[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 list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users