Example #1
1
  public void updateFavorite(int channelId, boolean isFavorite) {

    synchronized (lock) {
      SQLiteDatabase database = getWritableDatabase();
      Cursor cursor =
          database.query(
              FAVORITE_TABLE_NAME,
              new String[] {KEY_CHANNEL_ID},
              KEY_CHANNEL_ID + "=" + channelId,
              null,
              null,
              null,
              null);

      try {
        ContentValues values = new ContentValues();
        values.put(KEY_CHANNEL_ID, channelId);
        values.put(KEY_IS_FAVORITE, isFavorite ? 1 : 0);

        if (cursor.getCount() > 0) {
          database.update(FAVORITE_TABLE_NAME, values, KEY_CHANNEL_ID + "=" + channelId, null);
        } else {
          database.insert(FAVORITE_TABLE_NAME, null, values);
        }
      } finally {
        cursor.close();
        database.close();
      }
    }
  }
Example #2
1
  @Override
  protected void onActivityResult(int requestCode, int resultCode, Intent data) {
    super.onActivityResult(requestCode, resultCode, data);
    if (requestCode == 1 && resultCode == RESULT_OK && data != null) {
      Uri selectedImage = data.getData();
      String[] filePath = {MediaStore.Images.Media.DATA};

      Cursor cursor = getContentResolver().query(selectedImage, filePath, null, null, null);
      cursor.moveToFirst();

      int columnIndex = cursor.getColumnIndex(filePath[0]);
      String picturePath = cursor.getString(columnIndex);
      cursor.close();

      ImageView image = (ImageView) findViewById(R.id.imageView2);
      image.setImageBitmap(BitmapFactory.decodeFile(picturePath));
      imagepath = picturePath;
    } else if (requestCode == 2 && resultCode == RESULT_OK) {
      Bitmap photo = (Bitmap) data.getExtras().get("data");
      ImageView image = (ImageView) findViewById(R.id.imageView2);
      image.setImageBitmap(photo);
      try {
        File imagefile = createImageFile(photo);
        Log.d("dir", imagefile.getAbsolutePath());
        imagepath = imagefile.getAbsolutePath();
      } catch (IOException e) {
        e.printStackTrace();
      }
    }
  }
  @LargeTest
  public void testManyRowsTxt() throws Exception {
    mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
    StringBuilder sql = new StringBuilder(2100);
    sql.append("INSERT INTO test (data) VALUES ('");
    Random random = new Random(System.currentTimeMillis());
    StringBuilder randomString = new StringBuilder(1979);
    for (int i = 0; i < 1979; i++) {
      randomString.append((random.nextInt() & 0xf) % 10);
    }
    sql.append(randomString);
    sql.append("');");

    // if cursor window size changed, adjust this value too
    final int count = 600; // more than two fillWindow needed
    for (int i = 0; i < count; i++) {
      mDatabase.execSQL(sql.toString());
    }

    Cursor c = mDatabase.query("test", new String[] {"data"}, null, null, null, null, null);
    assertNotNull(c);

    int i = 0;
    while (c.moveToNext()) {
      assertEquals(randomString.toString(), c.getString(0));
      i++;
    }
    assertEquals(count, i);
    assertEquals(count, c.getCount());
    c.close();
  }
  void addUserRole(User user, String role) {
    SQLiteDatabase db = this.getWritableDatabase();

    int role_id = 0;

    String selectQuery =
        "SELECT "
            + KEY_ROLE_ID
            + " FROM "
            + TABLE_ROLES
            + " WHERE "
            + KEY_ROLE
            + " = '"
            + role
            + "'";

    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
      role_id = Integer.parseInt(cursor.getString(0));
    }

    ContentValues values = new ContentValues();
    values.put(KEY_USER_ID, user.getUserId());
    values.put(KEY_ROLE_ID, role_id);

    // Insert Row
    db.insert(TABLE_USER_ROLES, null, values);
    db.close();
  }
  @MediumTest
  public void testCursor2() throws Exception {
    populateDefaultTable();

    Cursor c = mDatabase.query("test", null, "_id > 1000", null, null, null, null);
    assertEquals(0, c.getCount());
    assertTrue(c.isBeforeFirst());

    try {
      c.getInt(0);
      fail("CursorIndexOutOfBoundsException expected");
    } catch (CursorIndexOutOfBoundsException ex) {
      // expected
    }

    int i;
    for (c.moveToFirst(), i = 0; !c.isAfterLast(); c.moveToNext(), i++) {
      c.getInt(0);
    }
    assertEquals(0, i);
    try {
      c.getInt(0);
      fail("CursorIndexOutOfBoundsException expected");
    } catch (CursorIndexOutOfBoundsException ex) {
      // expected
    }
    c.close();
  }
 @Override
 public long getItemId(int position) {
   if (mDataValid && mCursor != null && mCursor.moveToPosition(position)) {
     return mCursor.getLong(mRowIdColumn);
   }
   return 0;
 }
  private void sendResults(Long attemptId) {
    dbHelper = new DbHelper(this);
    Cursor cur = dbHelper.getUnsubmitted(attemptId.intValue());
    cur.moveToFirst();
    String content = "";
    while (cur.isAfterLast() == false) {
      content = dbHelper.createSubmitResponseObject(cur);
      cur.moveToNext();
    }
    cur.close();
    dbHelper.close();

    APIRequest[] resultsToSend = new APIRequest[1];
    APIRequest r = new APIRequest();
    r.fullurl =
        prefs.getString("prefServer", getString(R.string.prefServerDefault))
            + "api/?method=submit&format=json";
    r.rowId = attemptId.intValue();
    r.username = prefs.getString("prefUsername", "");
    r.password = prefs.getString("prefPassword", "");
    r.timeoutConnection = Integer.parseInt(prefs.getString("prefServerTimeoutConnection", "10000"));
    r.timeoutSocket = Integer.parseInt(prefs.getString("prefServerTimeoutResponse", "10000"));
    r.content = content;
    resultsToSend[0] = r;

    Toast.makeText(this, "Sending results", Toast.LENGTH_SHORT).show();

    // send results to server
    SubmitResultsTask task = new SubmitResultsTask(QuizActivityEnd.this);
    task.setDownloaderListener(this);
    task.execute(resultsToSend);
  }
  /**
   * Add only the SectionHeaders that have history items within their range to a SparseArray, where
   * the array index is the position of the header in the history-only (no clients) ordering.
   *
   * @param c data Cursor
   * @param sparseArray SparseArray to populate
   */
  private static void populateSectionHeaders(Cursor c, SparseArray<SectionHeader> sparseArray) {
    sparseArray.clear();

    if (c == null || !c.moveToFirst()) {
      return;
    }

    SectionHeader section = null;

    do {
      final int historyPosition = c.getPosition();
      final long visitTime =
          c.getLong(c.getColumnIndexOrThrow(BrowserContract.History.DATE_LAST_VISITED));
      final SectionHeader itemSection = CombinedHistoryPanel.getSectionFromTime(visitTime);

      if (section != itemSection) {
        section = itemSection;
        sparseArray.append(historyPosition + sparseArray.size(), section);
      }

      if (section == SectionHeader.OLDER_THAN_SIX_MONTHS) {
        break;
      }
    } while (c.moveToNext());
  }
 @Override
 public int getNextWaypointNumber(long trackId, boolean statistics) {
   if (trackId < 0) {
     return -1;
   }
   Cursor cursor = null;
   try {
     String[] projection = {WaypointsColumns._ID};
     String selection = WaypointsColumns.TRACKID + "=?  AND " + WaypointsColumns.TYPE + "=?";
     int type = statistics ? Waypoint.TYPE_STATISTICS : Waypoint.TYPE_WAYPOINT;
     String[] selectionArgs = new String[] {Long.toString(trackId), Integer.toString(type)};
     cursor = getWaypointCursor(projection, selection, selectionArgs, WaypointsColumns._ID, 0);
     if (cursor != null) {
       int count = cursor.getCount();
       /*
        * For statistics markers, the first marker is for the track statistics,
        * so return the count as the next user visible number.
        */
       return statistics ? count : count + 1;
     }
   } finally {
     if (cursor != null) {
       cursor.close();
     }
   }
   return -1;
 }
Example #10
0
  // 查找下载完成后本地保存路径
  public synchronized String getLocalByUrl(String sMovieurl) {
    // TODO Auto-generated method stub
    try {
      database = pipiDBHelp.getReadableDatabase();

      String sql =
          "select * from "
              + PipiDBHelp.STORE_TABLENAME
              + " where "
              + TableName.MovieUrl
              + "= '"
              + sMovieurl
              + "'";
      cursor = database.rawQuery(sql, null);
      if (cursor.moveToNext()) {
        return cursor.getString(cursor.getColumnIndex(TableName.MovieLocalUrl));
      }
    } catch (Exception e) {
      // TODO: handle exception
    } finally {
      closeCursor();
    }

    return null;
  }
Example #11
0
  public static Uri getUserImageUri(Context context) {
    if (Build.VERSION.SDK_INT > 14) {
      String[] mProjection =
          new String[] {
            ContactsContract.Profile._ID,
            ContactsContract.Profile.DISPLAY_NAME_PRIMARY,
            ContactsContract.Profile.LOOKUP_KEY,
            ContactsContract.Profile.PHOTO_THUMBNAIL_URI
          };
      Cursor mProfileCursor =
          context
              .getContentResolver()
              .query(ContactsContract.Profile.CONTENT_URI, mProjection, null, null, null);

      try {
        if (mProfileCursor.moveToFirst()) {
          String photo =
              mProfileCursor.getString(
                  mProfileCursor.getColumnIndex(ContactsContract.Profile.PHOTO_THUMBNAIL_URI));
          if (!TextUtils.isEmpty(photo)) {
            return Uri.parse(photo);
          }
        }
      } finally {
        if (mProfileCursor != null) {
          mProfileCursor.close();
        }
      }
    }
    return null;
  }
 /**
  * Calculate where this task should appear on the list for the given project. If no project is
  * defined, order is meaningless, so return -1. New tasks go on the end of the list, so the
  * highest current order value for tasks for this project and add one to this. For existing tasks,
  * check if the project changed, and if so treat like a new task, otherwise leave the order as is.
  *
  * @param projectId the project selected for this task
  * @return 0-indexed order of task when displayed in the project view
  */
 private Integer calculateTaskOrder(Id projectId) {
   if (!projectId.isInitialised()) return -1;
   int order;
   if (mState == State.STATE_INSERT || !projectId.equals(mOriginalItem.getProjectId())) {
     // get current highest order value
     Cursor cursor =
         getContentResolver()
             .query(
                 TaskProvider.Tasks.CONTENT_URI,
                 new String[] {TaskProvider.Tasks.PROJECT_ID, TaskProvider.Tasks.DISPLAY_ORDER},
                 TaskProvider.Tasks.PROJECT_ID + " = ?",
                 new String[] {String.valueOf(projectId.getId())},
                 TaskProvider.Tasks.DISPLAY_ORDER + " desc");
     if (cursor.moveToFirst()) {
       // first entry is current highest value
       int highest = cursor.getInt(1);
       order = highest + 1;
     } else {
       // no tasks in the project yet.
       order = 0;
     }
     cursor.close();
   } else {
     order = mOriginalItem.getOrder();
   }
   return order;
 }
Example #13
0
  public boolean hasFavorites() {
    boolean found = false;
    synchronized (lock) {
      SQLiteDatabase database = getReadableDatabase();

      Cursor cursor =
          database.query(
              FAVORITE_TABLE_NAME,
              new String[] {KEY_IS_FAVORITE},
              KEY_IS_FAVORITE + "=1",
              null,
              null,
              null,
              null);

      try {
        if (cursor.getCount() > 0) {
          found = true;
        }
      } finally {
        cursor.close();
        database.close();
      }
    }

    return found;
  }
  private Word cursorToWord(Cursor cursor) {
    Word word = new Word();
    word.setWord(cursor.getString(cursor.getColumnIndex(NewWordsTable.Cols.ORIGINAL_WORD)));
    word.setTranslation(cursor.getString(cursor.getColumnIndex(NewWordsTable.Cols.TRANSLATION)));

    return word;
  }
  void revokeUserRole(User user, String role) {
    SQLiteDatabase db = this.getWritableDatabase();

    int role_id = 0;

    String selectQuery =
        "SELECT "
            + KEY_ROLE_ID
            + " FROM "
            + TABLE_ROLES
            + " WHERE "
            + KEY_ROLE
            + " = '"
            + role
            + "'";

    Cursor cursor = db.rawQuery(selectQuery, null);

    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
      role_id = Integer.parseInt(cursor.getString(0));
    }

    if (role_id > 0) {
      // Delete Row
      db.delete(
          TABLE_USER_ROLES,
          KEY_USER_ID + " = ? AND " + KEY_ROLE_ID + " = ?",
          new String[] {String.valueOf(user.getUserId()), String.valueOf(role_id)});
    }

    db.close();
  }
Example #16
0
  public void setAsCurrent() {
    if (mUri == null) {
      return;
    }
    Cursor cur = mContext.getContentResolver().query(mUri, null, null, null, null);
    cur.moveToFirst();
    int index = cur.getColumnIndex("_id");
    String apnId = cur.getString(index);
    cur.close();

    ContentValues values = new ContentValues();
    values.put("apn_id", apnId);
    if (mSlot == -1) {
      mContext
          .getContentResolver()
          .update(Uri.parse("content://telephony/carriers/preferapn"), values, null, null);
    } else {
      int simNo = mSlot + 1;
      mContext
          .getContentResolver()
          .update(
              Uri.parse("content://telephony/carriers_sim" + simNo + "/preferapn"),
              values,
              null,
              null);
    }
  }
 @Override
 public Waypoint getLastStatisticsWaypoint(long trackId) {
   if (trackId < 0) {
     return null;
   }
   Cursor cursor = null;
   try {
     String selection =
         WaypointsColumns.TRACKID
             + "=? AND "
             + WaypointsColumns.TYPE
             + "="
             + Waypoint.TYPE_STATISTICS;
     String[] selectionArgs = new String[] {Long.toString(trackId)};
     cursor = getWaypointCursor(null, selection, selectionArgs, WaypointsColumns._ID + " DESC", 1);
     if (cursor != null && cursor.moveToFirst()) {
       return createWaypoint(cursor);
     }
   } finally {
     if (cursor != null) {
       cursor.close();
     }
   }
   return null;
 }
Example #18
0
  // 查找第几集播放进度
  public synchronized long getHistroyProgressByID(String sMovieID, int position) {
    // TODO Auto-generated method stub
    try {
      database = pipiDBHelp.getReadableDatabase();

      String sql =
          "select * from "
              + PipiDBHelp.HISTROY_TABLENAME
              + " where "
              + TableName.MovieID
              + "= '"
              + sMovieID
              + "'";
      cursor = database.rawQuery(sql, null);
      if (cursor.moveToNext()) {
        if (position == cursor.getInt(cursor.getColumnIndex(TableName.MoviePlayPosition))) {
          long progress = cursor.getLong(cursor.getColumnIndex(TableName.MoviePlayProgress));
          Log.i("TAG999", "insertMovieHistroy  = " + position + "*******" + progress);
          return progress;
        }
      }
    } catch (Exception e) {
      // TODO: handle exception
    } finally {
      closeCursor();
    }

    return 0;
  }
 @Override
 public long getLastTrackPointId(long trackId) {
   if (trackId < 0) {
     return -1L;
   }
   Cursor cursor = null;
   try {
     String selection =
         TrackPointsColumns._ID
             + "=(select max("
             + TrackPointsColumns._ID
             + ") from "
             + TrackPointsColumns.TABLE_NAME
             + " WHERE "
             + TrackPointsColumns.TRACKID
             + "=?)";
     String[] selectionArgs = new String[] {Long.toString(trackId)};
     cursor =
         getTrackPointCursor(
             new String[] {TrackPointsColumns._ID},
             selection,
             selectionArgs,
             TrackPointsColumns._ID);
     if (cursor != null && cursor.moveToFirst()) {
       return cursor.getLong(cursor.getColumnIndexOrThrow(TrackPointsColumns._ID));
     }
   } finally {
     if (cursor != null) {
       cursor.close();
     }
   }
   return -1L;
 }
Example #20
0
  // 查找播放当前第几集
  public synchronized int getHistroyPositionByID(String sMovieID) {
    // TODO Auto-generated method stub
    int position = 0;
    try {
      database = pipiDBHelp.getReadableDatabase();

      String sql =
          "select * from "
              + PipiDBHelp.HISTROY_TABLENAME
              + " where "
              + TableName.MovieID
              + "= '"
              + sMovieID
              + "'";
      cursor = database.rawQuery(sql, null);
      if (cursor.moveToNext()) {
        position = cursor.getInt(cursor.getColumnIndex(TableName.MoviePlayPosition));
        if (position < 0) position = 0;
        ;
      }
    } catch (Exception e) {
      // TODO: handle exception
    } finally {
      closeCursor();
    }

    return position;
  }
Example #21
0
 @Override
 public Cursor query(
     Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
   // TODO Auto-generated method stub
   // check uri
   // first 通过SQLiteQueryBuilder,设置数据库查询的信息.Uri有两种情况,一种是collect,
   // 一种已经指定某个item,两者需要区别对待,item将获取_ID,并在where中增加一个匹配条件.
   SQLiteQueryBuilder dbQuery = new SQLiteQueryBuilder();
   final int match = sUriMatch.match(uri);
   switch (match) {
     case HISTORY_COLLECTION_URI_INDICATOR:
       dbQuery.setTables(ChatHistoryTable.TABLE_NAME);
       dbQuery.setProjectionMap(sHistoryProjectionMap);
       break;
     case HISTORY_ITEM_URI_INDICATION:
       dbQuery.setTables(ChatHistoryTable.TABLE_NAME);
       dbQuery.setProjectionMap(sHistoryProjectionMap);
       dbQuery.appendWhere(ChatHistoryTable._ID + "=" + uri.getPathSegments().get(1));
       break;
     default:
       throw new IllegalArgumentException("Unknow uri=" + uri);
   }
   // second v 对排序进行缺省设置
   // String order = TextUtils.isEmpty(sortOrder) ? HistoryTable.DEFAULE_SORT_ORDER : sortOrder;
   SQLiteDatabase db = mOpenHelper.getReadableDatabase();
   // third start query
   final Cursor c = dbQuery.query(db, projection, selection, selectionArgs, null, null, sortOrder);
   // fourth 向系统注册通知:观察所要查询的数据,即Uri对应的数据是否发生变化
   // 开发者通过provider接口获取数据,可通过通知获知数据已经发生变更
   if (c != null) {
     c.setNotificationUri(mContentResolver, ChatHistoryTable.CONTENT_URI);
   }
   return c;
 }
 public Indices(Cursor cursor) {
   type = cursor.getColumnIndex(Suggestions.TYPE);
   title = cursor.getColumnIndex(Suggestions.TITLE);
   summary = cursor.getColumnIndex(Suggestions.SUMMARY);
   icon = cursor.getColumnIndex(Suggestions.ICON);
   extra_id = cursor.getColumnIndex(Suggestions.EXTRA_ID);
 }
  private void updateCalendarInfoFromListItem(int position) {
    Cursor cursor = (Cursor) calendarListView.getItemAtPosition(position);
    currentSelection.setDisplayName(cursor.getString(0));
    currentSelection.setId(cursor.getInt(1));

    updateListener.onUpdate(getCurrentSelection());
  }
Example #24
0
  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    requestWindowFeature(Window.FEATURE_NO_TITLE);
    overridePendingTransition(R.anim.pull_in_from_left, R.anim.pull_out_to_left);
    setContentView(R.layout.pass);

    close = (Button) findViewById(R.id.pass_cl);
    login = (Button) findViewById(R.id.pass_yes);
    forget = (Button) findViewById(R.id.pass_no);
    uName = (EditText) findViewById(R.id.pass_username);
    pass = (EditText) findViewById(R.id.pass_pwd);
    tView = (TextView) findViewById(R.id.pass_title);

    close.setOnClickListener(this);
    login.setOnClickListener(this);
    forget.setOnClickListener(this);

    db.open();
    Cursor mCursor = db.getAllRecords();
    mCursor.moveToFirst();
    rName = mCursor.getString(1);
    if (mCursor.getCount() > 0) {
      uName.setClickable(false);
      uName.setBackgroundResource(R.drawable.keypad1);
    }
    db.close();
    tView.setText(rName + " @ MoneyMan");
    uName.setText(rName);
  } // end onCreate()
  @Override
  protected void executeBadge(int badgeCount) throws ShortcutBadgeException {
    Uri mUri = Uri.parse(CONTENT_URI);
    ContentResolver contentResolver = mContext.getContentResolver();
    Cursor cursor = null;
    try {
      cursor =
          contentResolver.query(
              mUri, CONTENT_PROJECTION, "package=?", new String[] {getContextPackageName()}, null);
      if (cursor != null) {
        String entryActivityName = getEntryActivityName();
        boolean entryActivityExist = false;
        while (cursor.moveToNext()) {
          int id = cursor.getInt(0);
          ContentValues contentValues = getContentValues(badgeCount, false);
          contentResolver.update(mUri, contentValues, "_id=?", new String[] {String.valueOf(id)});
          if (entryActivityName.equals(cursor.getString(cursor.getColumnIndex("class")))) {
            entryActivityExist = true;
          }
        }

        if (!entryActivityExist) {
          ContentValues contentValues = getContentValues(badgeCount, true);
          contentResolver.insert(mUri, contentValues);
        }
      }
    } finally {
      CloseHelper.close(cursor);
    }
  }
Example #26
0
 /** @inheritdoc */
 @Override
 public void readEntity(Cursor cursor, Category entity, int offset) {
   entity.setId(cursor.isNull(offset + 0) ? null : cursor.getLong(offset + 0));
   entity.setTitle(cursor.getString(offset + 1));
   entity.setDescription(cursor.getString(offset + 2));
   entity.setImage(cursor.getString(offset + 3));
 }
  public static ArrayList<Long> getCalendarList(Context c) {
    ArrayList<Long> calendarIdList = new ArrayList<Long>();
    try {
      Cursor cur =
          c.getApplicationContext()
              .getContentResolver()
              .query(
                  CalendarContract.Calendars.CONTENT_URI,
                  CALENDAR_PROJECTION,
                  selection,
                  selectionArgs,
                  null);
      while (cur.moveToNext()) {
        long calID = 0;

        // Get the field values
        calID = cur.getLong(PROJECTION_ID_INDEX);

        calendarIdList.add(calID);
      }
    } catch (SecurityException e) {
      e.printStackTrace();
    } catch (Exception e) {
      e.printStackTrace();
    }
    return calendarIdList;
  }
  // TODO: if uploadingComplete() when activity backgrounded, won't work.
  public void uploadingComplete(ArrayList<String> result) {

    int resultSize = result.size();
    boolean success = false;
    if (resultSize == totalCount) {
      Toast.makeText(
              this, getString(R.string.upload_all_successful, totalCount), Toast.LENGTH_SHORT)
          .show();

      success = true;
    } else {
      String s = totalCount - resultSize + " of " + totalCount;
      Toast.makeText(this, getString(R.string.upload_some_failed, s), Toast.LENGTH_LONG).show();
    }

    Intent in = new Intent();
    in.putExtra(GlobalConstants.KEY_SUCCESS, success);
    setResult(RESULT_OK, in);

    // for each path, update the status
    FileDbAdapter fda = new FileDbAdapter(this);
    fda.open();
    for (int i = 0; i < resultSize; i++) {
      Cursor c = fda.fetchFilesByPath(result.get(i), null);
      if (c != null) {
        if (c.getString(c.getColumnIndex(FileDbAdapter.KEY_STATUS))
            .equals(FileDbAdapter.STATUS_COMPLETED))
          fda.updateFile(result.get(i), FileDbAdapter.STATUS_SUBMITTED, null);
      }
    }
    fda.close();
    finish();
  }
  @Override
  public Cursor query(
      Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
    // Uisng SQLiteQueryBuilder instead of query() method
    SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();

    // Check if the caller has requested a column which does not exists
    checkColumns(projection);

    // Set the table
    queryBuilder.setTables(DontForgetMomDbInformation.Trip.CONTENT_PROVIDER_TABLE_NAME);

    int uriType = sURIMatcher.match(uri);
    switch (uriType) {
      case TRIPS:
        break;
      case TRIP_ID:
        // Adding the ID to the original query
        queryBuilder.appendWhere(
            DontForgetMomDbInformation.Trip._ID + "=" + uri.getLastPathSegment());
        break;
      default:
        throw new IllegalArgumentException("Unknown URI: " + uri);
    }

    SQLiteDatabase db = dbHelper.getWritableDatabase();
    Cursor cursor =
        queryBuilder.query(db, projection, selection, selectionArgs, null, null, sortOrder);
    // Make sure that potential listeners are getting notified
    cursor.setNotificationUri(getContext().getContentResolver(), uri);

    return cursor;
  }
  public String getDDESetting(String mode, String setting) {
    String result = "";

    // Select All Query
    String selectQuery =
        "SELECT "
            + setting
            + " FROM "
            + TABLE_DDE_SETTINGS
            + " WHERE "
            + KEY_MODE
            + " = '"
            + mode
            + "'";

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    // looping through all rows and adding to list
    if (cursor.moveToFirst()) {
      result = cursor.getString(0);
    }

    cursor.close();

    return result;
  }