Ejemplo n.º 1
0
  public static Shift load(Context aContext, int aId) {
    ShiftCalendarDbOpenHelper dbOpener = new ShiftCalendarDbOpenHelper(aContext);
    SQLiteDatabase db = dbOpener.getReadableDatabase();
    Cursor query =
        db.query(TABLE_NAME, null, "id=" + String.valueOf(aId), new String[0], null, null, null);

    try {
      if (query.moveToNext()) {
        Shift shift =
            new Shift(
                query.getInt(query.getColumnIndex(ID_COLUMN)),
                query.getString(query.getColumnIndex(NAME_COLUMN)),
                query.getInt(query.getColumnIndex(COLOUR_COLUMN)),
                query.getString(query.getColumnIndex(TIME_FROM_COLUMN)),
                query.getString(query.getColumnIndex(TIME_TO_COLUMN)),
                query.getInt(query.getColumnIndex(SORT_ORDER_COLUMN)));
        db.close();
        dbOpener.close();
        return shift;
      } else {
        db.close();
        dbOpener.close();
        return null;
      }
    } finally {
      query.close();
    }
  }
Ejemplo n.º 2
0
  public void delete(Context aContext) {
    ShiftCalendarDbOpenHelper dbOpener = new ShiftCalendarDbOpenHelper(aContext);
    SQLiteDatabase db = dbOpener.getWritableDatabase();

    db.delete(TABLE_NAME, ID_COLUMN + "=" + getId(), null);
    db.delete(ShiftCalendar.TABLE_NAME, ShiftCalendar.SHIFT_ID_COLUMN + "=" + getId(), null);
    db.close();
    dbOpener.close();
  }
Ejemplo n.º 3
0
 public void save(Context aContext) {
   if (mSortOrder < 0) {
     mSortOrder = loadAll(aContext).size();
   }
   ShiftCalendarDbOpenHelper dbOpener = new ShiftCalendarDbOpenHelper(aContext);
   SQLiteDatabase db = dbOpener.getWritableDatabase();
   ContentValues contentValues = toContentValues();
   contentValues.remove(ID_COLUMN);
   if (getId() < 0) {
     mId = Long.valueOf(db.insert(TABLE_NAME, null, contentValues)).intValue();
   } else {
     Long.valueOf(db.update(TABLE_NAME, contentValues, ID_COLUMN + "=" + getId(), null))
         .intValue();
   }
   db.close();
   dbOpener.close();
 }
Ejemplo n.º 4
0
  public static List<Shift> loadAll(Context aContext) {
    ShiftCalendarDbOpenHelper dbOpener = new ShiftCalendarDbOpenHelper(aContext);
    SQLiteDatabase db = dbOpener.getReadableDatabase();
    Cursor query = db.query(Shift.TABLE_NAME, null, "", new String[0], "", "", SORT_ORDER_COLUMN);
    ArrayList<Shift> shifts = new ArrayList<Shift>();

    try {
      while (query.moveToNext()) {
        shifts.add(
            new Shift(
                query.getInt(query.getColumnIndex(ID_COLUMN)),
                query.getString(query.getColumnIndex(NAME_COLUMN)),
                query.getInt(query.getColumnIndex(COLOUR_COLUMN)),
                query.getString(query.getColumnIndex(TIME_FROM_COLUMN)),
                query.getString(query.getColumnIndex(TIME_TO_COLUMN)),
                query.getInt(query.getColumnIndex(SORT_ORDER_COLUMN))));
      }
    } finally {
      query.close();
    }

    return shifts;
  }