List of usage examples for android.database DatabaseUtils dumpCursorToString
public static String dumpCursorToString(Cursor cursor)
From source file:Main.java
public static void logTableDump(SQLiteDatabase db, String tablename) { Cursor cursor = db.query(tablename, null, null, null, null, null, null); try {// w ww . j a v a2 s. c om String dump = DatabaseUtils.dumpCursorToString(cursor); } finally { cursor.close(); } }
From source file:course1778.mobileapp.safeMedicare.Main.FamMemFrag.java
public void onClick(DialogInterface di, int whichButton) { // get strings from edittext boxes, then insert them into database ContentValues values = new ContentValues(DatabaseHelper.CONTENT_VALUE_COUNT); ContentValues drugInteractionValues = new ContentValues(4); Dialog dlg = (Dialog) di; EditText title = (EditText) dlg.findViewById(R.id.title); TimePicker tp = (TimePicker) dlg.findViewById(R.id.timePicker); Spinner mySpinner = (Spinner) dlg.findViewById(R.id.spinner); String fre = mySpinner.getSelectedItem().toString(); EditText dosage = (EditText) dlg.findViewById(R.id.dosage); EditText instruction = (EditText) dlg.findViewById(R.id.instruction); RadioGroup radioButtonGroup = (RadioGroup) dlg.findViewById(R.id.radioGroup); int radioButtonID = radioButtonGroup.getCheckedRadioButtonId(); View radioButton = radioButtonGroup.findViewById(radioButtonID); int shape = radioButtonGroup.indexOfChild(radioButton) / 2; int Fre;/* w w w. j ava 2s .c om*/ //int day = 0; int monday = 0, tuesday = 0, wednesday = 0, thursday = 0, friday = 0, saturday = 0, sunday = 0; // clear array list drug_interaction_list.clear(); curr_drug_interaction_list.clear(); // loop through database crsInteractions.moveToPosition(-1); while (crsInteractions.moveToNext()) { // drug names drugName = crsInteractions.getString(crsInteractions.getColumnIndex(DatabaseHelper.SHEET_1_DRUG_NAMES)); // corresponding interacted drugs/foods interactionName = crsInteractions .getString(crsInteractions.getColumnIndex(DatabaseHelper.SHEET_1_DRUG_INTERACTIONS)); // interaction result interactionResult = crsInteractions .getString(crsInteractions.getColumnIndex(DatabaseHelper.SHEET_1_INTERACTION_RESULT)); // medication name entered by user medNameFieldTxt = textView.getText().toString(); // check if newly entered medication name matches current drug name if (drugName.equals(medNameFieldTxt)) { /**if found, check if the corresponding interaction * drug in the list of all added drugs by user */ if (db.isNameExitOnDB(interactionName)) { // interaction found Log.d("myinteraction", "Found Interaction"); String interaction_result = medNameFieldTxt + "/" + interactionName + "\n"; // only insert new drug interactions if they have not yet exist if (!dbInteraction.isDrugInteractionExist(medNameFieldTxt, interactionName)) { // insert the drug interaction into our new dynamic drug interaction db drugInteractionValues.put(DatabaseInteractionHelper.USR_NAME, ParseUser.getCurrentUser().getUsername()); drugInteractionValues.put(DatabaseInteractionHelper.DRUG_NAME, medNameFieldTxt); drugInteractionValues.put(DatabaseInteractionHelper.DRUG_INTERACTION, interactionName); drugInteractionValues.put(DatabaseInteractionHelper.DRUG_INTERACTION_SHOW, DatabaseInteractionHelper.DRUG_INTERACTION_SHOW_TRUE); dbInteraction.getWritableDatabase().insert(DatabaseInteractionHelper.TABLE, DatabaseInteractionHelper.DRUG_NAME, drugInteractionValues); } drug_interaction_list.add(interaction_result); curr_drug_interaction_list.add(interactionName); } } } Log.d("mydatabase3", DatabaseUtils.dumpCursorToString(dbInteraction.getCursor())); // display all iteractions in pop window if there is any String interaction_results = "\n"; for (int i = 0; i < curr_drug_interaction_list.size(); i++) { String interaction = medNameFieldTxt + " & " + curr_drug_interaction_list.get(i) + "\n\n"; interaction_results = interaction_results.concat(interaction); } if (drug_interaction_list.size() != 0) { // inflate a dialog to display the drug interactions warning LayoutInflater inflater = getActivity().getLayoutInflater(); View resultView = inflater.inflate(R.layout.drug_interaction_result, null); AlertDialog.Builder builder = new AlertDialog.Builder(getActivity()); builder.setTitle(R.string.drug_interaction_result_title).setView(resultView) // go to drug interaction list button .setNegativeButton(R.string.drug_interaction_list, new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { // drug interaction page DrugInteractions drugInterac = new DrugInteractions(); FragmentTransaction transaction; transaction = getFragmentManager().beginTransaction(); transaction.replace(R.id.fragmentContainer, drugInterac); transaction.addToBackStack(null); // Commit the transaction transaction.commit(); } }) // ok button .setPositiveButton(R.string.dismiss, null).show(); TextView interactionResultView = (TextView) resultView.findViewById(R.id.resultView); // add warning message into the pop up window interaction_results = interaction_results.concat(getString(R.string.interaction_warning)); // display on pop up window interactionResultView.setText(interaction_results); } // write the list of drug interactions into file Helpers.writeToFile(getContext(), drug_interaction_list, "drug_interaction_list"); Log.d("mydatabase", DatabaseUtils.dumpCursorToString(db.getCursor())); if (fre == "Ten Times a Day") { Fre = 10; } else if (fre == "Twice a Day") { Fre = 2; } else if (fre == "Three Times a Day") { Fre = 3; } else if (fre == "Four Times a Day") { Fre = 4; } else if (fre == "Five Times a Day") { Fre = 5; } else if (fre == "Six Times a Day") { Fre = 6; } else if (fre == "Seven Times a Day") { Fre = 7; } else if (fre == "Eight Times a Day") { Fre = 8; } else if (fre == "Nine Times a Day") { Fre = 9; } else { Fre = 1; } if (((CheckBox) dlg.findViewById(R.id.MonCheck)).isChecked()) { monday = monday + 1; } if (((CheckBox) dlg.findViewById(R.id.TueCheck)).isChecked()) { tuesday = tuesday + 1; } if (((CheckBox) dlg.findViewById(R.id.WedCheck)).isChecked()) { wednesday = wednesday + 1; } if (((CheckBox) dlg.findViewById(R.id.ThuCheck)).isChecked()) { thursday = thursday + 1; } if (((CheckBox) dlg.findViewById(R.id.FriCheck)).isChecked()) { friday = friday + 1; } if (((CheckBox) dlg.findViewById(R.id.SatCheck)).isChecked()) { saturday = saturday + 1; } if (((CheckBox) dlg.findViewById(R.id.SunCheck)).isChecked()) { sunday = sunday + 1; } // clear focus before retrieving the min and hr tp.clearFocus(); int tpMinute = tp.getCurrentMinute(); int tpHour = tp.getCurrentHour(); // an order number to order the list view items int orderNum = tpHour * 60 + tpMinute; tp.setIs24HourView(true); String titleStr = title.getText().toString(); String timeHStr = Helpers.StringFormatter(tpHour, "00"); String timeMStr = Helpers.StringFormatter(tpMinute, "00"); String dosageStr = dosage.getText().toString(); String instructionStr = instruction.getText().toString(); Log.d("mytime", Integer.toString(tpHour)); Log.d("mytime", Integer.toString(tpMinute)); values.put(DatabaseHelper.USRNAME, ParseUser.getCurrentUser().getUsername()); values.put(DatabaseHelper.TITLE, titleStr); values.put(DatabaseHelper.TIME_H, timeHStr); values.put(DatabaseHelper.TIME_M, timeMStr); values.put(DatabaseHelper.FREQUENCY, Fre); //values.put(DatabaseHelper.DAY, day); values.put(DatabaseHelper.MONDAY, monday); values.put(DatabaseHelper.TUESDAY, tuesday); values.put(DatabaseHelper.WEDNESDAY, wednesday); values.put(DatabaseHelper.THURSDAY, thursday); values.put(DatabaseHelper.FRIDAY, friday); values.put(DatabaseHelper.SATURDAY, saturday); values.put(DatabaseHelper.SUNDAY, sunday); values.put(DatabaseHelper.DOSAGE, dosageStr); values.put(DatabaseHelper.INSTRUCTION, instructionStr); values.put(DatabaseHelper.SHAPE, shape); values.put(DatabaseHelper.ORDER_NUM, orderNum); Bundle bundle = new Bundle(); // add extras here.. bundle.putString(DatabaseHelper.TITLE, title.getText().toString()); bundle.putString(DatabaseHelper.TIME_H, timeHStr); bundle.putString(DatabaseHelper.TIME_M, timeMStr); bundle.putInt(DatabaseHelper.FREQUENCY, Fre); //bundle.putInt(DatabaseHelper.DAY, day); bundle.putInt(DatabaseHelper.MONDAY, monday); bundle.putInt(DatabaseHelper.TUESDAY, tuesday); bundle.putInt(DatabaseHelper.WEDNESDAY, wednesday); bundle.putInt(DatabaseHelper.THURSDAY, thursday); bundle.putInt(DatabaseHelper.FRIDAY, friday); bundle.putInt(DatabaseHelper.SATURDAY, saturday); bundle.putInt(DatabaseHelper.SUNDAY, sunday); bundle.putString(DatabaseHelper.DOSAGE, dosageStr); bundle.putString(DatabaseHelper.INSTRUCTION, instructionStr); bundle.putInt(DatabaseHelper.SHAPE, shape); bundle.putInt(DatabaseHelper.ORDER_NUM, orderNum); //Alarm alarm = new Alarm(getActivity().getApplicationContext(), bundle); // get unique notifyId for each alarm int length = title.length(); for (int i = 0; i < length; i++) { notifyId = (int) titleStr.charAt(i) + notifyId; } notifyId = Integer.parseInt(timeHStr + timeMStr); // saving it into parse.com ParseObject parseObject = new ParseObject(Helpers.PARSE_OBJECT); parseObject.put(DatabaseHelper.USRNAME, ParseUser.getCurrentUser().getUsername()); parseObject.put(DatabaseHelper.TITLE, titleStr); parseObject.put(DatabaseHelper.TIME_H, timeHStr); parseObject.put(DatabaseHelper.TIME_M, timeMStr); parseObject.put(DatabaseHelper.FREQUENCY, Fre); //parseObject.put(DatabaseHelper.DAY, day); parseObject.put(DatabaseHelper.MONDAY, monday); parseObject.put(DatabaseHelper.TUESDAY, tuesday); parseObject.put(DatabaseHelper.WEDNESDAY, wednesday); parseObject.put(DatabaseHelper.THURSDAY, thursday); parseObject.put(DatabaseHelper.FRIDAY, friday); parseObject.put(DatabaseHelper.SATURDAY, saturday); parseObject.put(DatabaseHelper.SUNDAY, sunday); parseObject.put(DatabaseHelper.DOSAGE, dosageStr); parseObject.put(DatabaseHelper.INSTRUCTION, instructionStr); parseObject.put(DatabaseHelper.SHAPE, shape); parseObject.put(DatabaseHelper.NOFITY_ID, notifyId); parseObject.put(DatabaseHelper.ORDER_NUM, orderNum); parseObject.saveInBackground(); task = new InsertTask().execute(values); }
From source file:com.android.providers.contacts.ContactsSyncAdapter.java
private static void addExtensionsToContactEntry(ContentResolver cr, long personId, ContactEntry entry) throws ParseException { Cursor c = cr.query(Extensions.CONTENT_URI, null, "person=" + personId, null, null); try {/*from w ww. ja v a2 s. c om*/ JSONObject jsonObject = new JSONObject(); int nameIndex = c.getColumnIndexOrThrow(Extensions.NAME); int valueIndex = c.getColumnIndexOrThrow(Extensions.VALUE); if (c.getCount() == 0) return; while (c.moveToNext()) { try { jsonObject.put(c.getString(nameIndex), c.getString(valueIndex)); } catch (JSONException e) { throw new ParseException("bad key or value", e); } } ExtendedProperty extendedProperty = new ExtendedProperty(); extendedProperty.setName("android"); final String jsonString = jsonObject.toString(); if (jsonString == null) { throw new ParseException( "unable to convert cursor into a JSON string, " + DatabaseUtils.dumpCursorToString(c)); } extendedProperty.setXmlBlob(jsonString); entry.addExtendedProperty(extendedProperty); } finally { if (c != null) c.close(); } }