Itban Saeed
Itban Saeed

Reputation: 1666

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?

Upvotes: 0

Views: 338

Answers (2)

Lunch Basketball
Lunch Basketball

Reputation: 442

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

Upvotes: 1

15kokos
15kokos

Reputation: 698

I think that what you need is to implement datacontrol provider functionality in your native service application and datacontrol consumer functionality in your UI Web application.

Provider can implement SQL data provisioning and update, consumer can then use data provided using Web API.

Upvotes: 2

Related Questions