// Returns schedule pointed to by cursor.
private ScheduleData scheduleFromCursor(Cursor cursor) {
ScheduleData schedule = new ScheduleData();
schedule.id = cursor.getLong(0);
schedule.sid = cursor.getLong(1);
schedule.name = cursor.getString(2);
schedule.active = cursor.getInt(3) > 0;
schedule.ownerId = cursor.getInt(4);
schedule.lastModified = cursor.getString(5);
return schedule;
}
// Creates a new schedule entry in table.
public ScheduleData createSchedule(
long sid, String name, boolean active, long ownerId, String lastModified) {
ScheduleData schedule = getScheduleFromSid(sid);
// Only create if the schedule does not already exist.
if (schedule == null) {
ContentValues values = new ContentValues();
values.put(SchedulesSQLiteHelper.COLUMN_SID, sid);
values.put(SchedulesSQLiteHelper.COLUMN_NAME, name);
values.put(SchedulesSQLiteHelper.COLUMN_ACTIVE, active);
values.put(SchedulesSQLiteHelper.COLUMN_OWNER_ID, ownerId);
values.put(SchedulesSQLiteHelper.COLUMN_LAST_MODIFIED, lastModified);
long insertId = this.database.insert(SchedulesSQLiteHelper.TABLE_SCHEDULE, null, values);
Cursor cursor =
this.database.query(
SchedulesSQLiteHelper.TABLE_SCHEDULE,
SchedulesDataSource.allScheduleColumns,
SchedulesSQLiteHelper.COLUMN_ID + " = " + insertId,
null,
null,
null,
null);
cursor.moveToFirst();
return scheduleFromCursor(cursor);
} else {
schedule.name = name;
schedule.active = active;
schedule.ownerId = ownerId;
schedule.lastModified = lastModified;
updateSchedule(schedule);
return schedule;
}
}
