Search code examples
sqlitetizentizen-native-app

Tizen Wearable Native Application: How do we dump a SQLite database?

I'm implementing a Tizen Wearable Hybrid Application (Web UI + Native Service). Native Service uses the SQLite Database for record maintenance. I need to export a SQLite dump file of the database in csv format to share that with the Web UI. Unfortunately I couldn't find anything with the web search. Someone please guide me how can I create a dump file from SQLite in Tizen Wearable Native Application?

Solution

  • Method 1. Converting db files to csv file

    1) Copy db files to res
https://developer.tizen.org/ko/forums/native-application-development/how-copy-sqlite-data.db-file-application-runtime?langredirect=1#comment-25969

2) Converting db files to csv file
https://www.tutlane.com/tutorial/sqlite/sqlite-export-data-from-table-to-csv-file

    Method 2. Coding read data and write them to csv file directly Exporting the sqlite3 table into file using "C" execute API