public static String singleValueFromQuery(SQLiteDatabase database, String query) {
   Cursor cursor = database.rawQuery(query, new String[] {});
   String value = "";
   if (cursor != null) {
     cursor.moveToFirst();
     value = cursor.getString(0);
     cursor.close();
   }
   return value;
 }
Esempio n. 2
0
  @Override
  protected JSONArray doInBackground(String... params) {
    JSONArray json = null;

    SQLiteDatabase db = mDBHelper.getReadableDatabase();
    try {
      json = constructResponse(db.rawQuery(generateQuery(params[0]), new String[] {}), params[0]);
    } catch (JSONException e) {
      e.printStackTrace();
    }
    return json;
  }
  @Override
  public boolean execute(SQLiteDatabase database) {

    database.execSQL("create table t1(a INTEGER, b INTEGER);");
    database.execSQL("insert into t1(a,b) values(123, 456);");
    Cursor cursor = database.rawQuery("select * from t1;", new String[] {});
    if (cursor != null) {
      cursor.moveToFirst();
      cursor.copyStringToBuffer(1, charArrayBuffer);
      String actualValue = new String(charArrayBuffer.data, 0, charArrayBuffer.sizeCopied);
      return "456".equals(actualValue);
    }
    return false;
  }
    private void buildSQL() throws SQLException {
      StringBuilder sb = new StringBuilder(128);
      sb.append("INSERT INTO ");
      sb.append(mTableName);
      sb.append(" (");

      StringBuilder sbv = new StringBuilder(128);
      sbv.append("VALUES (");

      int i = 1;
      Cursor cur = null;
      try {
        cur = mDb.rawQuery("PRAGMA table_info(" + mTableName + ")", null);
        mColumns = new HashMap<String, Integer>(cur.getCount());
        while (cur.moveToNext()) {
          String columnName = cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX);
          String defaultValue = cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX);

          mColumns.put(columnName, i);
          sb.append("'");
          sb.append(columnName);
          sb.append("'");

          if (defaultValue == null) {
            sbv.append("?");
          } else {
            sbv.append("COALESCE(?, ");
            sbv.append(defaultValue);
            sbv.append(")");
          }

          sb.append(i == cur.getCount() ? ") " : ", ");
          sbv.append(i == cur.getCount() ? ");" : ", ");
          ++i;
        }
      } finally {
        if (cur != null) cur.close();
      }

      sb.append(sbv);

      mInsertSQL = sb.toString();
      if (LOCAL_LOGV) Log.v(TAG, "insert statement is " + mInsertSQL);
    }
 public JSONArray getObservationsFor(JSONObject params) throws JSONException {
   String patientUuid = params.getString("patientUuid");
   JSONArray conceptNamesArray = params.getJSONArray("conceptNames");
   String conceptNames = conceptNamesArray.toString();
   JSONArray visitUuidsArray = params.getJSONArray("visitUuids");
   String visitUuids = visitUuidsArray.toString();
   SQLiteDatabase db = mDBHelper.getReadableDatabase();
   JSONArray observations = new JSONArray();
   String inClauseConceptNameList =
       conceptNamesArray.length() > 0
           ? conceptNames.substring(2, conceptNames.length() - 2)
           : conceptNames;
   String inClauseVisitUuidsList =
       visitUuidsArray.length() > 0
           ? visitUuids.substring(2, visitUuids.length() - 2)
           : visitUuids;
   Cursor c =
       db.rawQuery(
           "SELECT observationJson from observation"
               + " WHERE patientUuid = '"
               + patientUuid
               + "'"
               + " AND conceptName in (\""
               + inClauseConceptNameList
               + "\") "
               + " AND ( visitUuid in (\""
               + inClauseVisitUuidsList
               + "\") OR visitUuid is NULL )",
           new String[] {});
   if (c.getCount() < 1) {
     c.close();
     return new JSONArray();
   }
   c.moveToFirst();
   for (int index = 0; index < c.getCount(); index++) {
     JSONObject observationJson = new JSONObject();
     observationJson.put(
         "observation", new JSONObject(c.getString(c.getColumnIndex("observationJson"))));
     observations.put(index, observationJson);
     c.moveToNext();
   }
   c.close();
   return observations;
 }
  public JSONArray getObservationsForVisit(String visitUuid) throws JSONException {
    SQLiteDatabase db = mDBHelper.getReadableDatabase();
    Cursor c =
        db.rawQuery(
            "SELECT observationJson FROM observation WHERE visitUuid = '" + visitUuid + "'",
            new String[] {});
    JSONArray observations = new JSONArray();

    if (c.getCount() < 1) {
      c.close();
      return observations;
    }

    c.moveToFirst();
    for (int index = 0; index < c.getCount(); index++) {
      JSONObject observationJson = new JSONObject();
      observationJson.put(
          "observation", new JSONObject(c.getString(c.getColumnIndex("observationJson"))));
      observations.put(index, observationJson);
      c.moveToNext();
    }

    return observations;
  }