Android sqlite tables to json file -

-

i new json. trying 2 sqlite tables json text file. able fetch each table , send text file results invalid if try read string file.

here code:

    file f = new file(constants.default_backup_file_path);     fileoutputstream fos = new fileoutputstream(f,true);     printstream ps = new printstream(fos);      string query1 = "select " + col_1  + "," + col_2 + " " + table_1;     cursor cursor1 = db.rawquery(query1, null);     cursor1.movetofirst();      jsonobject mobject = new jsonobject();     jsonarray tab1array = new jsonarray();       int = 0;     while (!cursor1.isafterlast()) {         jsonobject robject = new jsonobject();         try {             robject.put("id", cursor1.getstring(cursor1.getcolumnindex(col_1)));             robject.put("user", cursor1.getstring(cursor1.getcolumnindex(col_2)));              cursor1.movetonext();              tab1array.put(i, robject);             i++;          } catch (jsonexception e) {              e.printstacktrace();         }     }       mobject.put("table1", tab1array);     ps.append(mobject.tostring());       string query2 = "select " + col_1  + "," + col_2 + " " + table_2;     cursor cursor2 = db.rawquery(query2, null);     cursor2.movetofirst();      jsonobject mobject2 = new jsonobject();     jsonarray tab2array = new jsonarray();       int i2 = 0;     while (!cursor2.isafterlast()) {         jsonobject robject2 = new jsonobject();         try {             robject2.put("id", cursor2.getstring(cursor2.getcolumnindex(col_1)));             robject2.put("name", cursor2.getstring(cursor2.getcolumnindex(col_2)));              cursor2.movetonext();              tab2array.put(i2, robject2);             i2++;          } catch (jsonexception e) {              e.printstacktrace();         }     }       mobject2.put("table2", tab1array);     ps.append(mobject2.tostring());

my text file looks (note no comma between two):

{"table1":[{"id":"1", "user":"larry"},{"id":"2", "user":"mo"},{"id":"4", "user":"curly"},{"id":"5", "user":"shemp"}]} {"table2":[{"id":"1", "name":"ticky"},{"id":"2", "name":"tky"},{"id":"4", "name":"tem"},{"id":"5", "name":"bo"}]}

it should like: { "table1": [{ "id": "1", "user": "larry" }, { "id": "2", "user": "mo" }, { "id": "4", "user": "curly" }, { "id": "5", "user": "shemp" }], "table2": [{ "id": "1", "name": "ticky" }, { "id": "2", "name": "tky" }, { "id": "4", "name": "tem" }, { "id": "5", "name": "bo" }] }

i can parse table1 by:

        try {         jsonobject jsonobject = new jsonobject(backup);         jsonarray jsonarray = jsonobject.getjsonarray("table1");         (int i=0;i<jsonarray.length();i++)     {              jsonobject jsonobject1 = jsonarray.getjsonobject(i);             string theid = jsonobject1.getstring("_id");

but table2 can't found using same code. great in building exporting tables correctly.

remove ps.append(mobject.tostring()); middle of code, , change last 2 lines to:

mobject.put("table2", tab2array); ps.append(mobject.tostring());

Comments

Post a Comment

Popular posts from this blog

SVG stroke-linecap doesn't work for circles in Firefox? -

-
i've got problem svg stroke-linecap attribute. i've got circular progress bar in angularjs , set outer circle (blue one) have rounded "ends". @ fiddle . <svg ... height="130" width="130"> <!-- ngif: background --> <circle ... ng-if="background" fill="#fff" class="ng-scope" stroke-width="13" stroke="#cc3399" r="57.5" cy="65" cx="65" stroke-linecap="round" /> <!-- end ngif: background --> <circle ... fill="none" stroke-dashoffset="36.12831551628261" stroke-dasharray="361.28315516282623" stroke-width="13" stroke="#432db3" stroke-linecap="round" r="57.5" cy="65" cx="65" transform="rotate(-89.9, 65, 65)" /> </svg> how can that? ...
Read more

routes - Laravel 4 Wildcard Routing to Different Controllers -

-
realizing i'm going take beating this, have several questions "best practices" when constructing laravel route. do laravel routes run "first come first serve" top bottom? if route found, pass control controller (or perform action) , terminate? i have part of application acts url shortner. so, route looks this: route::get('/{id}', array('as' => 'home.text', 'uses' => 'homecontroller@text'), function($id){ //make sure id exists before pushing controller. if (storage::where('shortcode','=', $id)->count() > 0) { // route found } }); how can improved? one, i'm not sure how pass processing on controller conditionally.. sort of controller::make() ..? 3) there better way in laravel check if record exists versus doing mode::where('column','=','value')->count() 4) have legacy urls http://url.com/?...
Read more

cross browser - XSLT namespace-alias Not Working in Firefox or Chrome -

-
i transforming xhtml xhtml, need xslt stylesheet part of resulting document (the stylesheet contained in <script type"text/template"> element. using the xsl:namespace-alias instruction, works fine in ie, fails in both chrome , firefox. here relevant code: <xsl:output doctype-system="about:legacy-compat" omit-xml-declaration="yes" indent="yes" method="html" media-type="application/xhml" encoding="utf-8"/> <xsl:namespace-alias stylesheet-prefix="wxsl" result-prefix="xsl" /> <xsl:template match="head"> <!-- code omitted clarity --> <script type="text/template"> <wxsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns="http://www.w3.org/1999/xhtml" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:eli="local"> ...
Read more