create sqlite3 db from sql statements from file in c++

Question

I am trying to write c++ application to create sqlite db or update existing db from sql statements which are present in text file. I am not able to find right way to do. As a workaround i used system() with "cat sqlfile.txt | sqlite3 mydb FYI. I am using sqlite3 3071502

Validus Oculus · Accepted Answer · 2015-10-28 06:07:23Z

1

You need to use STL fstream library to read the content of file. Tutorials are here: http://www.cplusplus.com/doc/tutorial/files/

After that, you need to use sqlite c++ api to execute sql commands. Tutorials are here: https://www.sqlite.org/c3ref/exec.html

answered Oct 28, 2015 at 6:07

Validus Oculus

2,7911 gold badge31 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

create sqlite3 db from sql statements from file in c++

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related