lundi 11 janvier 2016

Create table in SQLite from ArrayList and store data from Volley

I have a ArrayList, for each item from the ArrayList Volley downloads JSON data in click() method, I would like to store this data in SQLite.

The question is: How to create for each item from the ArrayList respectively table in SQLite and add downloaded data(JSONArray stopTime) for each table from Volley request?

Method click():

void click() {
        Pattern MY_PATTERN = Pattern.compile("var data = (.*)");
        String url = "http://ift.tt/1P2DpsP";
        RequestQueue queue = Volley.newRequestQueue(this);
        Iterator itr = routeList.iterator();

        while (itr.hasNext()) {

            String currentState = (String) itr.next();


            StringRequest stringRequest = new StringRequest(Request.Method.GET, url + currentState,
                    new Response.Listener<String>() {
                        @Override
                        //here you are downloading your page into a response string
                        public void onResponse(String response) {
                            //regexp search for data
                            Matcher m = MY_PATTERN.matcher(response);

                            if (m.find()) {
                                String extracted = m.group(1).trim();
                                try {
                                    //HERE is Json obj you are looking for
                                    JSONObject obj = new JSONObject(extracted);

                                    JSONArray stationArray = new JSONObject(extracted).getJSONArray("stations");
                                    int spacesToIndentEachLevel = 2;
                                    for (int i = 0; i < stationArray.length(); i++) {
                                        JSONArray stopTime = stationArray.getJSONObject(i).getJSONArray("wtlist");


                                    }


                                } catch (JSONException e) {
                                    e.printStackTrace();
                                }
                            }
                        }
                    }, new Response.ErrorListener() {
                @Override
                public void onErrorResponse(VolleyError error) {
                    mTextView.setText("error");
                }
            });

            queue.add(stringRequest);
        }

    }

List:

void addToRouteList() {
    routeList = new ArrayList<>();
    String[] arr = {"/tramvajs-nr-1-butlerova-iela-stacija",
            "/autobuss-nr-1-autoosta-regionala-slimnica-celinieku-ciemats",
            "/autobuss-nr-1a-autoosta-celinieku-ciemats",
            "/tramvajs-nr-2-butlerova-iela-maizes-kombinats",
            "/autobuss-nr-2-garazas-autoosta",
            "/tramvajs-nr-3-stropu-ezers-cietoksnis",
            "/autobuss-nr-3-autoosta-kooperativs",
            "/autobuss-nr-3b-autoosta-ziglier-masinbuve",
            "/autobuss-nr-3c-autoosta-ziglier-masinbuve",
            "/autobuss-nr-4-autoosta-cietoksnis-mezciems-autoosta",
            "/autobuss-nr-5-autoosta-mezciems-cietoksnis-autoosta",
            "/autobuss-nr-6-autoosta-niderkuni",
            "/autobuss-nr-7-autoosta-kalkuni",
            "/autobuss-nr-7b-autoosta-micurinietis",
            "/autobuss-nr-8-autoosta-judovka",
            "/autobuss-nr-9-autoosta-kirsu-iela",
            "/autobuss-nr-10-autoosta-rugeli",
            "/autobuss-nr-10a-autoosta-rugeli",
            "/autobuss-nr-11-jaunforstadte-slimnica",
            "/autobuss-nr-12-autoosta-krizi",
            "/autobuss-nr-13-autoosta-mezciema-arodskola",
            "/autobuss-nr-13a-autoosta-cietoksnis",
            "/autobuss-nr-15-autoosta-liginiski-autoosta",
            "/autobuss-nr-17-autoosta-stacijas-jaunforstadte",
            "/autobuss-nr-17a-autoosta-csdd-jaunforstadte",
            "/autobuss-nr-18-viduspogulanka-autoosta",
            "/autobuss-nr-19-jaunforstadte-kimiku-ciemats-jaunbuve-jaunforstadte",
            "/autobuss-nr-20-jaunforstadte-jaunbuve-kimiku-jaunforstadte",
            "/autobuss-nr-20a2-jaunforstadte-kimiku-ciemats-slimnica",
            "/autobuss-nr-20a-jaunforstadte-jaunbuve",
            "/autobuss-nr-20b-jaunforstadte-smiltenes-jaunbuve-kimiku-ciemats",
            "/autobuss-nr-21-autobusu-parks-daugavpils-ao-jaunforstadte",
            "/autobuss-nr-22-autobusu-parks-krizi",
            "/autobuss-nr-23-rugeli-regionala-slimnica"};
    routeList = Arrays.asList(arr);

}

Aucun commentaire:

Enregistrer un commentaire