Convert SQLite to JSON

Question

Is there a way to convert sqlite to json? All other questions are parsing json and saving to sqlite. I can't seem to find any reference on this, please help me.

I have a sqlite db inside the app and i need it to be converted to json, upgrade db version, parse earlier converted json and add another table. Any suggestions on how should I do this?

Thanks in advance.

Answer 1

Reference Link

private JSONArray getResults() {  String myPath = DB_PATH + DB_NAME;// Set path to your database   String myTable = TABLE_NAME;//Set name of your table  //or you can use `context.getDatabasePath("my_db_test.db")`  SQLiteDatabase myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);   String searchQuery = "SELECT  * FROM " + myTable; Cursor cursor = myDataBase.rawQuery(searchQuery, null );  JSONArray resultSet     = new JSONArray();   cursor.moveToFirst(); while (cursor.isAfterLast() == false) {              int totalColumn = cursor.getColumnCount();             JSONObject rowObject = new JSONObject();              for( int i=0 ;  i< totalColumn ; i++ )             {                 if( cursor.getColumnName(i) != null )                  {                      try                      {                          if( cursor.getString(i) != null )                         {                             Log.d("TAG_NAME", cursor.getString(i) );                             rowObject.put(cursor.getColumnName(i) ,  cursor.getString(i) );                         }                         else                         {                             rowObject.put( cursor.getColumnName(i) ,  "" );                          }                     }                     catch( Exception e )                     {                         Log.d("TAG_NAME", e.getMessage()  );                     }                 }              }              resultSet.put(rowObject);             cursor.moveToNext();         }          cursor.close();          Log.d("TAG_NAME", resultSet.toString() );         return resultSet;   } 

Answer 2

Quick and easy way if you don't feel like coding it:

• Download DB Browser for SQLite: https://sqlitebrowser.org/ (yes, it's free)
• Open the SQLite DB
• Go to File > Export > Table(s) to JSON
• Voila

Beware, for some reason it does not correctly convert NULL values. It converts this to an empty string... Besides that it works like a charm as far as I now.