Exemplo n.º 1
0
  public List<ReminderItem> getAllReminders() {
    ArrayList<ReminderItem> alarmJobList = new ArrayList<ReminderItem>();

    ReminderItem alarmJob = null;
    SQLiteDatabase db = null;
    synchronized (this) {
      db = this.getWritableDatabase();

      try {
        Cursor cursor = db.query(TABLE_NAME, null, null, null, null, null, null);
        if (cursor != null) {
          while (cursor.moveToNext()) {
            alarmJob = createAlarmJobFromCursor(cursor);
            if (alarmJob != null) {
              alarmJobList.add(alarmJob);
            }
          }
          cursor.close();
        } else {
          AIOLog.d(AIOConstant.TAG, "[getAlarmJobs]: Cursor is null.");
        }
      } catch (SQLiteException e) {
        e.printStackTrace();
      }
    }

    return alarmJobList;
  }
Exemplo n.º 2
0
  private void createTables(SQLiteDatabase db) {

    db.beginTransaction();

    db.execSQL(
        "CREATE TABLE IF NOT EXISTS "
            + ReminderDBHelper.TABLE_NAME
            + " ("
            + ReminderDBHelper.JobsColumns._ID
            + " "
            + DB_PRIMARY_KEY_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.CLASS_NAME
            + " "
            + DB_NAME_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.CUSTOM_ID
            + " "
            + DB_NAME_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.TRIGGERTIME
            + " "
            + DB_NAME_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.INTERVALTIME
            + " "
            + DB_NAME_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.REPEATCOUNT
            + " "
            + DB_INTEGER_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.REPEATMODE
            + " "
            + DB_INTEGER_TYPE
            + ","
            + ReminderDBHelper.JobsColumns.RAWDATA
            + " "
            + DB_BYTE_TYPE
            + ");");

    AIOLog.d(AIOConstant.TAG, "DB TABLE(" + ReminderDBHelper.TABLE_NAME + ") Has been created.");

    db.setTransactionSuccessful();

    db.endTransaction();
  }
Exemplo n.º 3
0
  public long addJob(
      String className,
      String id,
      long triggerAtMillis,
      long intervalMillis,
      int repeatCount,
      boolean repeatMode) {

    long rowId = -1;

    if (deleteJob(className, id) > 0) {
      AIOLog.d(AIOConstant.TAG, "addJob: delete a jobs");
    }

    rowId = insert(className, id, triggerAtMillis, intervalMillis, repeatCount, repeatMode);

    if (rowId < 0) {
      AIOLog.e(AIOConstant.TAG, "Fail to insert a job for schdule");
      return rowId;
    } else return rowId;
  }
Exemplo n.º 4
0
 @Override
 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   AIOLog.d(
       AIOConstant.TAG, "Upgrading database from version " + oldVersion + " to " + newVersion);
   upgradeTables(db);
 }