Android Calendar, get Event Id
I extracted a list of columns used to store events into android calendar. Here the list:
[0] "originalEvent" (id=830007842672)
[1] "availabilityStatus" (id=830007842752)
[2] "ownerAccount" (id=830007842840)
[3] "_sync_account_type" (id=830007842920)
[4] "visibility" (id=830007843008)
[5] "rrule" (id=830007843080)
[6] "lastDate" (id=830007843144)
[7] "hasAlarm" (id=830007843216)
[8] "guestsCanModify" (id=830007843288)
[9] "guestsCanSeeGuests" (id=830007843376)
[10] "exrule" (id=830007843464)
[11] "rdate" (id=830007843528)
[12] "transparency" (id=830007843592)
[13] "timezone" (id=830007843672)
[14] "selected" (id=830007843744)
[15] "dtstart" (id=830007843816)
[16] "title" (id=830007843888)
[17] "_sync_time" (id=830007843952)
[18] "_id" (id=830007844024)
[19] "hasAttendeeData" (id=830007844088)
[20] "_sync_id" (id=830007844176)
[21] "commentsUri" (id=830007844248)
[22] "description" (id=830007844328)
[23] "htmlUri" (id=830007844408)
[24] "_sync_account" (id=830007844480)
[25] "_sync_version" (id=830007844560)
[26] "hasExtendedProperties" (id=830007844640)
[27] "calendar_id" (id=830007844736)
Then if i want to get the new event id for my event:
public static long getNewEventId(ContentResolver cr, Uri cal_uri){
Uri local_uri = cal_uri;
if(cal_uri == null){
local_uri = Uri.parse(calendar_uri+"events");
}
Cursor cursor = cr.query(local_uri, new String [] {"MAX(_id) as max_id"}, null, null, "_id");
cursor.moveToFirst();
long max_val = cursor.getLong(cursor.getColumnIndex("max_id"));
return max_val+1;
}
ANd for insert event:
public void insertDomainEntry(Date exp_date, String name, long event_id){
SQLiteDatabase db = getWritableDatabase();
ContentValues values = new ContentValues();
values.put("exp_date", exp_date.getTime()/1000);
values.put("event_id", event_id);
values.put("domainname", name);
db.insertOrThrow("domains_events", null, values);
}
That solution seems to work, even if probably this is not a very good solution.
EDIT 02/2015 The purpose of getNextEventId is to create a new Event Entry for the event table, here the code with the usage of this method:
@Override
public void onItemClick(AdapterView<?> adapter, View curview, int position,
long id) {
WhoisEntry entry = this.adapter.getItem(position);
long event_id = CalendarUtils.getNewEventId(getContentResolver(), null);
Toast.makeText(getApplicationContext(), "Domain: " + entry.getDomainName(),
Toast.LENGTH_SHORT).show();
Intent intent = new Intent(Intent.ACTION_EDIT);
intent.setType("vnd.android.cursor.item/event");
intent.putExtra("beginTime", entry.getExpiration().getTime());
intent.putExtra("_id", event_id);
intent.putExtra("allDay", false);
intent.putExtra("endTime", entry.getExpiration().getTime()+60*30);
intent.putExtra("title", "Expiration of " + entry.getDomainName());
startActivity(intent);
database.insertDomainEntry(entry.getExpiration(),
entry.getDomainName(), event_id);
}
Update 09/2015
As requested in the comment i add how to get the Calendar URI (it is basically where the calendar is stored, and the application try to guess it, searching in all known possible calendar paths)
public static String getCalendarUriBase(Activity act) {
String calendarUriBase = null;
Uri calendars = Uri.parse("content://calendar/calendars");
Cursor managedCursor = null;
try {
managedCursor = act.getContentResolver().query(calendars,
null, null, null, null);
} catch (Exception e) {
}
if (managedCursor != null) {
calendarUriBase = "content://calendar/";
} else {
calendars = Uri.parse("content://com.android.calendar/calendars");
try {
managedCursor = act.getContentResolver().query(calendars,
null, null, null, null);
} catch (Exception e) {
}
if (managedCursor != null) {
calendarUriBase = "content://com.android.calendar/";
}
}
calendar_uri= calendarUriBase;
return calendarUriBase;
}