content: /*
   * Copyright (C) 2006 The Android Open Source Project
   *
   * Licensed under the Apache License, Version 2.0 (the "License");
   * you may not use this file except in compliance with the License.
   * You may obtain a copy of the License at
   *
   *      http://www.apache.org/licenses/LICENSE-2.0
   *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
   * See the License for the specific language governing permissions and
   * limitations under the License.
   */
  
  package android.provider;
  
  import android.annotation.NonNull;
  import android.annotation.SdkConstant;
  import android.annotation.SdkConstant.SdkConstantType;
  import android.annotation.TestApi;
  import android.annotation.UnsupportedAppUsage;
  import android.app.Activity;
  import android.app.AlarmManager;
  import android.app.PendingIntent;
  import android.app.admin.DevicePolicyManager;
  import android.content.ComponentName;
  import android.content.ContentProviderClient;
  import android.content.ContentResolver;
  import android.content.ContentUris;
  import android.content.ContentValues;
  import android.content.Context;
  import android.content.CursorEntityIterator;
  import android.content.Entity;
  import android.content.EntityIterator;
  import android.content.Intent;
  import android.database.Cursor;
  import android.database.DatabaseUtils;
  import android.net.Uri;
  import android.os.RemoteException;
  import android.text.format.DateUtils;
  import android.text.format.Time;
  import android.util.Log;
  
  import com.android.internal.util.Preconditions;
  
  import java.util.Set;
  
  /**
   * <p>
   * The contract between the calendar provider and applications. Contains
   * definitions for the supported URIs and data columns.
   * </p>
   * <h3>Overview</h3>
   * <p>
   * CalendarContract defines the data model of calendar and event related
   * information. This data is stored in a number of tables:
   * </p>
   * <ul>
   * <li>The {@link Calendars} table holds the calendar specific information. Each
   * row in this table contains the details for a single calendar, such as the
   * name, color, sync info, etc.</li>
   * <li>The {@link Events} table holds the event specific information. Each row
   * in this table has the info for a single event. It contains information such
   * as event title, location, start time, end time, etc. The event can occur
   * one-time or can recur multiple times. Attendees, reminders, and extended
   * properties are stored on separate tables and reference the {@link Events#_ID}
   * to link them with the event.</li>
   * <li>The {@link Instances} table holds the start and end time for occurrences
   * of an event. Each row in this table represents a single occurrence. For
   * one-time events there will be a 1:1 mapping of instances to events. For
   * recurring events, multiple rows will automatically be generated which
   * correspond to multiple occurrences of that event.</li>
   * <li>The {@link Attendees} table holds the event attendee or guest
   * information. Each row represents a single guest of an event. It specifies the
   * type of guest they are and their attendance response for the event.</li>
   * <li>The {@link Reminders} table holds the alert/notification data. Each row
   * represents a single alert for an event. An event can have multiple reminders.
   * The number of reminders per event is specified in
   * {@link Calendars#MAX_REMINDERS} which is set by the Sync Adapter that owns
   * the given calendar. Reminders are specified in minutes before the event and
   * have a type.</li>
   * <li>The {@link ExtendedProperties} table holds opaque data fields used by the
   * sync adapter. The provider takes no action with items in this table except to
   * delete them when their related events are deleted.</li>
   * </ul>
   * <p>
   * Other tables include:
   * </p>
   * <ul>
   * <li>
   * {@link SyncState}, which contains free-form data maintained by the sync
   * adapters</li>
   * </ul>
   *
   */
  public final class CalendarContract {
      private static final String TAG = "Calendar";
  
      /**
       * Broadcast Action: This is the intent that gets fired when an alarm
       * notification needs to be posted for a reminder.
       *
       */
      @SdkConstant(SdkConstantType.ACTIVITY_INTENT_ACTION)
      public static final String ACTION_EVENT_REMINDER = "android.intent.action.EVENT_REMINDER";
  
      /**
       * Activity Action: Display the event to the user in the custom app as
       * specified in {@link EventsColumns#CUSTOM_APP_PACKAGE}. The custom app
       * will be started via {@link Activity#startActivityForResult(Intent, int)}
       * and it should call {@link Activity#setResult(int)} with
       * {@link Activity#RESULT_OK} or {@link Activity#RESULT_CANCELED} to
       * acknowledge whether the action was handled or not.
       *
       * The custom app should have an intent filter like the following:
       * <pre>
       * &lt;intent-filter&gt;
       *    &lt;action android:name="android.provider.calendar.action.HANDLE_CUSTOM_EVENT" /&gt;
       *    &lt;category android:name="android.intent.category.DEFAULT" /&gt;
       *    &lt;data android:mimeType="vnd.android.cursor.item/event" /&gt;
       * &lt;/intent-filter&gt;</pre>
       * <p>
       * Input: {@link Intent#getData} has the event URI. The extra
       * {@link #EXTRA_EVENT_BEGIN_TIME} has the start time of the instance. The
       * extra {@link #EXTRA_CUSTOM_APP_URI} will have the
       * {@link EventsColumns#CUSTOM_APP_URI}.
       * <p>
       * Output: {@link Activity#RESULT_OK} if this was handled; otherwise
       * {@link Activity#RESULT_CANCELED}.
       */
      @SdkConstant(SdkConstantType.ACTIVITY_INTENT_ACTION)
      public static final String ACTION_HANDLE_CUSTOM_EVENT =
          "android.provider.calendar.action.HANDLE_CUSTOM_EVENT";
  
      /**
       * Action used to help apps show calendar events in the managed profile.
       */
      @SdkConstant(SdkConstantType.ACTIVITY_INTENT_ACTION)
      public static final String ACTION_VIEW_MANAGED_PROFILE_CALENDAR_EVENT =
              "android.provider.calendar.action.VIEW_MANAGED_PROFILE_CALENDAR_EVENT";
  
      /**
       * Intent Extras key: {@link EventsColumns#CUSTOM_APP_URI} for the event in
       * the {@link #ACTION_HANDLE_CUSTOM_EVENT} intent
       */
      public static final String EXTRA_CUSTOM_APP_URI = "customAppUri";
  
      /**
       * Intent Extras key: The start time of an event or an instance of a
       * recurring event. (milliseconds since epoch)
       */
      public static final String EXTRA_EVENT_BEGIN_TIME = "beginTime";
  
      /**
       * Intent Extras key: The end time of an event or an instance of a recurring
       * event. (milliseconds since epoch)
       */
      public static final String EXTRA_EVENT_END_TIME = "endTime";
  
      /**
       * Intent Extras key: When creating an event, set this to true to create an
       * all-day event by default
       */
      public static final String EXTRA_EVENT_ALL_DAY = "allDay";
  
      /**
       * Intent Extras key: An extra of type {@code long} holding the id of an event.
       */
      public static final String EXTRA_EVENT_ID = "id";
  
      /**
       * This authority is used for writing to or querying from the calendar
       * provider. Note: This is set at first run and cannot be changed without
       * breaking apps that access the provider.
       */
      public static final String AUTHORITY = "com.android.calendar";
  
      /**
       * The content:// style URL for the top-level calendar authority
       */
      public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY);
  
      /**
       * The content:// style URL for the top-level cross-profile calendar uris.
       * {@link android.database.ContentObserver} for this URL in the primary profile will be
       * notified when there is a change in the managed profile calendar provider.
       *
       * <p>Throw UnsupportedOperationException if another profile doesn't exist or is disabled, or
       * if the calling package is not whitelisted to access cross-profile calendar, or if the
       * feature has been disabled by the user in Settings.
       *
       * @see Events#ENTERPRISE_CONTENT_URI
       * @see Calendars#ENTERPRISE_CONTENT_URI
       * @see Instances#ENTERPRISE_CONTENT_URI
       * @see Instances#ENTERPRISE_CONTENT_BY_DAY_URI
       * @see Instances#ENTERPRISE_CONTENT_SEARCH_URI
       * @see Instances#ENTERPRISE_CONTENT_SEARCH_BY_DAY_URI
       * @hide
       */
      public static final Uri ENTERPRISE_CONTENT_URI = Uri.parse(
              "content://" + AUTHORITY + "/enterprise");
  
      /**
       * An optional insert, update or delete URI parameter that allows the caller
       * to specify that it is a sync adapter. The default value is false. If set
       * to true, the modified row is not marked as "dirty" (needs to be synced)
       * and when the provider calls
       * {@link ContentResolver#notifyChange(android.net.Uri, android.database.ContentObserver, boolean)}
       * , the third parameter "syncToNetwork" is set to false. Furthermore, if
       * set to true, the caller must also include
       * {@link Calendars#ACCOUNT_NAME} and {@link Calendars#ACCOUNT_TYPE} as
       * query parameters.
       *
       * @see Uri.Builder#appendQueryParameter(java.lang.String, java.lang.String)
       */
      public static final String CALLER_IS_SYNCADAPTER = "caller_is_syncadapter";
  
      /**
       * A special account type for calendars not associated with any account.
       * Normally calendars that do not match an account on the device will be
       * removed. Setting the account_type on a calendar to this will prevent it
       * from being wiped if it does not match an existing account.
       *
       * @see SyncColumns#ACCOUNT_TYPE
       */
      public static final String ACCOUNT_TYPE_LOCAL = "LOCAL";
  
      /**
       * This utility class cannot be instantiated
       */
      private CalendarContract() {}
  
      /**
       * Starts an activity to view calendar events in the managed profile.
       *
       * When this API is called, the system will attempt to start an activity
       * in the managed profile with an intent targeting the same caller package.
       * The intent will have its action set to
       * {@link CalendarContract#ACTION_VIEW_MANAGED_PROFILE_CALENDAR_EVENT} and contain extras
       * corresponding to the API's arguments. A calendar app intending to support
       * cross-profile events viewing should handle this intent, parse the arguments
       * and show the appropriate UI.
       *
       * @param context the context.
       * @param eventId the id of the event to be viewed. Will be put into {@link #EXTRA_EVENT_ID}
       *                field of the intent.
       * @param startMs the start time of the event in milliseconds since epoch.
       *                Will be put into {@link #EXTRA_EVENT_BEGIN_TIME} field of the intent.
       * @param endMs the end time of the event in milliseconds since epoch.
       *              Will be put into {@link #EXTRA_EVENT_END_TIME} field of the intent.
       * @param allDay if the event is an all-day event. Will be put into
       *               {@link #EXTRA_EVENT_ALL_DAY} field of the intent.
       * @param flags flags to be set on the intent via {@link Intent#setFlags}
       * @return {@code true} if the activity is started successfully. {@code false} otherwise.
       *
       * @see #EXTRA_EVENT_ID
       * @see #EXTRA_EVENT_BEGIN_TIME
       * @see #EXTRA_EVENT_END_TIME
       * @see #EXTRA_EVENT_ALL_DAY
       */
      public static boolean startViewCalendarEventInManagedProfile(@NonNull Context context,
              long eventId, long startMs, long endMs, boolean allDay, int flags) {
          Preconditions.checkNotNull(context, "Context is null");
          final DevicePolicyManager dpm = (DevicePolicyManager) context.getSystemService(
                  Context.DEVICE_POLICY_SERVICE);
          return dpm.startViewCalendarEventInManagedProfile(eventId, startMs,
                  endMs, allDay, flags);
      }
  
      /**
       * Generic columns for use by sync adapters. The specific functions of these
       * columns are private to the sync adapter. Other clients of the API should
       * not attempt to either read or write this column. These columns are
       * editable as part of the Calendars Uri, but can only be read if accessed
       * through any other Uri.
       */
      protected interface CalendarSyncColumns {
  
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC1 = "cal_sync1";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC2 = "cal_sync2";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC3 = "cal_sync3";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC4 = "cal_sync4";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC5 = "cal_sync5";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC6 = "cal_sync6";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC7 = "cal_sync7";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC8 = "cal_sync8";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC9 = "cal_sync9";
  
          /**
           * Generic column for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CAL_SYNC10 = "cal_sync10";
      }
  
      /**
       * Columns for Sync information used by Calendars and Events tables. These
       * have specific uses which are expected to be consistent by the app and
       * sync adapter.
       *
       */
      protected interface SyncColumns extends CalendarSyncColumns {
          /**
           * The account that was used to sync the entry to the device. If the
           * account_type is not {@link #ACCOUNT_TYPE_LOCAL} then the name and
           * type must match an account on the device or the calendar will be
           * deleted.
           * <P>Type: TEXT</P>
           */
          public static final String ACCOUNT_NAME = "account_name";
  
          /**
           * The type of the account that was used to sync the entry to the
           * device. A type of {@link #ACCOUNT_TYPE_LOCAL} will keep this event
           * form being deleted if there are no matching accounts on the device.
           * <P>Type: TEXT</P>
           */
          public static final String ACCOUNT_TYPE = "account_type";
  
          /**
           * The unique ID for a row assigned by the sync source. NULL if the row
           * has never been synced. This is used as a reference id for exceptions
           * along with {@link BaseColumns#_ID}.
           * <P>Type: TEXT</P>
           */
          public static final String _SYNC_ID = "_sync_id";
  
          /**
           * Used to indicate that local, unsynced, changes are present.
           * <P>Type: INTEGER (long)</P>
           */
  
          public static final String DIRTY = "dirty";
  
          /**
           * Used in conjunction with {@link #DIRTY} to indicate what packages wrote local changes.
           * <P>Type: TEXT</P>
           */
          public static final String MUTATORS = "mutators";
  
          /**
           * Whether the row has been deleted but not synced to the server. A
           * deleted row should be ignored.
           * <P>
           * Type: INTEGER (boolean)
           * </P>
           */
          public static final String DELETED = "deleted";
  
          /**
           * If set to 1 this causes events on this calendar to be duplicated with
           * {@link Events#LAST_SYNCED} set to 1 whenever the event
           * transitions from non-dirty to dirty. The duplicated event will not be
           * expanded in the instances table and will only show up in sync adapter
           * queries of the events table. It will also be deleted when the
           * originating event has its dirty flag cleared by the sync adapter.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String CAN_PARTIALLY_UPDATE = "canPartiallyUpdate";
      }
  
      /**
       * Columns specific to the Calendars Uri that other Uris can query.
       */
      protected interface CalendarColumns {
          /**
           * The color of the calendar. This should only be updated by the sync
           * adapter, not other apps, as changing a calendar's color can adversely
           * affect its display.
           * <P>Type: INTEGER (color value)</P>
           */
          public static final String CALENDAR_COLOR = "calendar_color";
  
          /**
           * A key for looking up a color from the {@link Colors} table. NULL or
           * an empty string are reserved for indicating that the calendar does
           * not use a key for looking up the color. The provider will update
           * {@link #CALENDAR_COLOR} automatically when a valid key is written to
           * this column. The key must reference an existing row of the
           * {@link Colors} table. @see Colors
           * <P>
           * Type: TEXT
           * </P>
           */
          public static final String CALENDAR_COLOR_KEY = "calendar_color_index";
  
          /**
           * The display name of the calendar. Column name.
           * <P>
           * Type: TEXT
           * </P>
           */
          public static final String CALENDAR_DISPLAY_NAME = "calendar_displayName";
  
          /**
           * The level of access that the user has for the calendar
           * <P>Type: INTEGER (one of the values below)</P>
           */
          public static final String CALENDAR_ACCESS_LEVEL = "calendar_access_level";
  
          /** Cannot access the calendar */
          public static final int CAL_ACCESS_NONE = 0;
          /** Can only see free/busy information about the calendar */
          public static final int CAL_ACCESS_FREEBUSY = 100;
          /** Can read all event details */
          public static final int CAL_ACCESS_READ = 200;
          /** Can reply yes/no/maybe to an event */
          public static final int CAL_ACCESS_RESPOND = 300;
          /** not used */
          public static final int CAL_ACCESS_OVERRIDE = 400;
          /** Full access to modify the calendar, but not the access control
           * settings
           */
          public static final int CAL_ACCESS_CONTRIBUTOR = 500;
          /** Full access to modify the calendar, but not the access control
           * settings
           */
          public static final int CAL_ACCESS_EDITOR = 600;
          /** Full access to the calendar */
          public static final int CAL_ACCESS_OWNER = 700;
          /** Domain admin */
          public static final int CAL_ACCESS_ROOT = 800;
  
          /**
           * Is the calendar selected to be displayed?
           * 0 - do not show events associated with this calendar.
           * 1 - show events associated with this calendar
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String VISIBLE = "visible";
  
          /**
           * The time zone the calendar is associated with.
           * <P>Type: TEXT</P>
           */
          public static final String CALENDAR_TIME_ZONE = "calendar_timezone";
  
          /**
           * Is this calendar synced and are its events stored on the device?
           * 0 - Do not sync this calendar or store events for this calendar.
           * 1 - Sync down events for this calendar.
           * <p>Type: INTEGER (boolean)</p>
           */
          public static final String SYNC_EVENTS = "sync_events";
  
          /**
           * The owner account for this calendar, based on the calendar feed.
           * This will be different from the _SYNC_ACCOUNT for delegated calendars.
           * Column name.
           * <P>Type: String</P>
           */
          public static final String OWNER_ACCOUNT = "ownerAccount";
  
          /**
           * Can the organizer respond to the event?  If no, the status of the
           * organizer should not be shown by the UI.  Defaults to 1. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String CAN_ORGANIZER_RESPOND = "canOrganizerRespond";
  
          /**
           * Can the organizer modify the time zone of the event? Column name.
           * <P>Type: INTEGER (boolean)</P>
          */
          public static final String CAN_MODIFY_TIME_ZONE = "canModifyTimeZone";
  
          /**
           * The maximum number of reminders allowed for an event. Column name.
           * <P>Type: INTEGER</P>
           */
          public static final String MAX_REMINDERS = "maxReminders";
  
          /**
           * A comma separated list of reminder methods supported for this
           * calendar in the format "#,#,#". Valid types are
           * {@link Reminders#METHOD_DEFAULT}, {@link Reminders#METHOD_ALERT},
           * {@link Reminders#METHOD_EMAIL}, {@link Reminders#METHOD_SMS},
           * {@link Reminders#METHOD_ALARM}. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String ALLOWED_REMINDERS = "allowedReminders";
  
          /**
           * A comma separated list of availability types supported for this
           * calendar in the format "#,#,#". Valid types are
           * {@link Events#AVAILABILITY_BUSY}, {@link Events#AVAILABILITY_FREE},
           * {@link Events#AVAILABILITY_TENTATIVE}. Setting this field to only
           * {@link Events#AVAILABILITY_BUSY} should be used to indicate that
           * changing the availability is not supported.
           *
           */
          public static final String ALLOWED_AVAILABILITY = "allowedAvailability";
  
          /**
           * A comma separated list of attendee types supported for this calendar
           * in the format "#,#,#". Valid types are {@link Attendees#TYPE_NONE},
           * {@link Attendees#TYPE_OPTIONAL}, {@link Attendees#TYPE_REQUIRED},
           * {@link Attendees#TYPE_RESOURCE}. Setting this field to only
           * {@link Attendees#TYPE_NONE} should be used to indicate that changing
           * the attendee type is not supported.
           *
           */
          public static final String ALLOWED_ATTENDEE_TYPES = "allowedAttendeeTypes";
  
          /**
           * Is this the primary calendar for this account. If this column is not explicitly set, the
           * provider will return 1 if {@link Calendars#ACCOUNT_NAME} is equal to
           * {@link Calendars#OWNER_ACCOUNT}.
           */
          public static final String IS_PRIMARY = "isPrimary";
      }
  
      /**
       * Class that represents a Calendar Entity. There is one entry per calendar.
       * This is a helper class to make batch operations easier.
       */
      public static final class CalendarEntity implements BaseColumns, SyncColumns, CalendarColumns {
  
          /**
           * The default Uri used when creating a new calendar EntityIterator.
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY +
                  "/calendar_entities");
  
          /**
           * This utility class cannot be instantiated
           */
          private CalendarEntity() {}
  
          /**
           * Creates an entity iterator for the given cursor. It assumes the
           * cursor contains a calendars query.
           *
           * @param cursor query on {@link #CONTENT_URI}
           * @return an EntityIterator of calendars
           */
          public static EntityIterator newEntityIterator(Cursor cursor) {
              return new EntityIteratorImpl(cursor);
          }
  
          private static class EntityIteratorImpl extends CursorEntityIterator {
  
              public EntityIteratorImpl(Cursor cursor) {
                  super(cursor);
              }
  
              @Override
              public Entity getEntityAndIncrementCursor(Cursor cursor) throws RemoteException {
                  // we expect the cursor is already at the row we need to read from
                  final long calendarId = cursor.getLong(cursor.getColumnIndexOrThrow(_ID));
  
                  // Create the content value
                  ContentValues cv = new ContentValues();
                  cv.put(_ID, calendarId);
  
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ACCOUNT_NAME);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ACCOUNT_TYPE);
  
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, _SYNC_ID);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, DIRTY);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, MUTATORS);
  
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC1);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC2);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC3);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC4);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC5);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC6);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC7);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC8);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC9);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC10);
  
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, Calendars.NAME);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          Calendars.CALENDAR_DISPLAY_NAME);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          Calendars.CALENDAR_COLOR);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          Calendars.CALENDAR_COLOR_KEY);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, CALENDAR_ACCESS_LEVEL);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, VISIBLE);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, SYNC_EVENTS);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          Calendars.CALENDAR_LOCATION);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CALENDAR_TIME_ZONE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          Calendars.OWNER_ACCOUNT);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          Calendars.CAN_ORGANIZER_RESPOND);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          Calendars.CAN_MODIFY_TIME_ZONE);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          Calendars.MAX_REMINDERS);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          Calendars.CAN_PARTIALLY_UPDATE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          Calendars.ALLOWED_REMINDERS);
  
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, DELETED);
  
                  // Create the Entity from the ContentValue
                  Entity entity = new Entity(cv);
  
                  // Set cursor to next row
                  cursor.moveToNext();
  
                  // Return the created Entity
                  return entity;
              }
          }
       }
  
      /**
       * Constants and helpers for the Calendars table, which contains details for
       * individual calendars. <h3>Operations</h3> All operations can be done
       * either as an app or as a sync adapter. To perform an operation as a sync
       * adapter {@link #CALLER_IS_SYNCADAPTER} should be set to true and
       * {@link #ACCOUNT_NAME} and {@link #ACCOUNT_TYPE} must be set in the Uri
       * parameters. See
       * {@link Uri.Builder#appendQueryParameter(java.lang.String, java.lang.String)}
       * for details on adding parameters. Sync adapters have write access to more
       * columns but are restricted to a single account at a time. Calendars are
       * designed to be primarily managed by a sync adapter and inserting new
       * calendars should be done as a sync adapter. For the most part, apps
       * should only update calendars (such as changing the color or display
       * name). If a local calendar is required an app can do so by inserting as a
       * sync adapter and using an {@link #ACCOUNT_TYPE} of
       * {@link #ACCOUNT_TYPE_LOCAL} .
       * <dl>
       * <dt><b>Insert</b></dt>
       * <dd>When inserting a new calendar the following fields must be included:
       * <ul>
       * <li>{@link #ACCOUNT_NAME}</li>
       * <li>{@link #ACCOUNT_TYPE}</li>
       * <li>{@link #NAME}</li>
       * <li>{@link #CALENDAR_DISPLAY_NAME}</li>
       * <li>{@link #CALENDAR_COLOR}</li>
       * <li>{@link #CALENDAR_ACCESS_LEVEL}</li>
       * <li>{@link #OWNER_ACCOUNT}</li>
       * </ul>
       * The following fields are not required when inserting a Calendar but are
       * generally a good idea to include:
       * <ul>
       * <li>{@link #SYNC_EVENTS} set to 1</li>
       * <li>{@link #CALENDAR_TIME_ZONE}</li>
       * <li>{@link #ALLOWED_REMINDERS}</li>
       * <li>{@link #ALLOWED_AVAILABILITY}</li>
       * <li>{@link #ALLOWED_ATTENDEE_TYPES}</li>
       * </ul>
       * <dt><b>Update</b></dt>
       * <dd>To perform an update on a calendar the {@link #_ID} of the calendar
       * should be provided either as an appended id to the Uri (
       * {@link ContentUris#withAppendedId}) or as the first selection item--the
       * selection should start with "_id=?" and the first selectionArg should be
       * the _id of the calendar. Calendars may also be updated using a selection
       * without the id. In general, the {@link #ACCOUNT_NAME} and
       * {@link #ACCOUNT_TYPE} should not be changed after a calendar is created
       * as this can cause issues for sync adapters.
       * <dt><b>Delete</b></dt>
       * <dd>Calendars can be deleted either by the {@link #_ID} as an appended id
       * on the Uri or using any standard selection. Deleting a calendar should
       * generally be handled by a sync adapter as it will remove the calendar
       * from the database and all associated data (aka events).</dd>
       * <dt><b>Query</b></dt>
       * <dd>Querying the Calendars table will get you all information about a set
       * of calendars. There will be one row returned for each calendar that
       * matches the query selection, or at most a single row if the {@link #_ID}
       * is appended to the Uri.</dd>
       * </dl>
       * <h3>Calendar Columns</h3> The following Calendar columns are writable by
       * both an app and a sync adapter.
       * <ul>
       * <li>{@link #NAME}</li>
       * <li>{@link #CALENDAR_DISPLAY_NAME}</li>
       * <li>{@link #VISIBLE}</li>
       * <li>{@link #SYNC_EVENTS}</li>
       * </ul>
       * The following Calendars columns are writable only by a sync adapter
       * <ul>
       * <li>{@link #ACCOUNT_NAME}</li>
       * <li>{@link #ACCOUNT_TYPE}</li>
       * <li>{@link #CALENDAR_COLOR}</li>
       * <li>{@link #_SYNC_ID}</li>
       * <li>{@link #DIRTY}</li>
       * <li>{@link #MUTATORS}</li>
       * <li>{@link #OWNER_ACCOUNT}</li>
       * <li>{@link #MAX_REMINDERS}</li>
       * <li>{@link #ALLOWED_REMINDERS}</li>
       * <li>{@link #ALLOWED_AVAILABILITY}</li>
       * <li>{@link #ALLOWED_ATTENDEE_TYPES}</li>
       * <li>{@link #CAN_MODIFY_TIME_ZONE}</li>
       * <li>{@link #CAN_ORGANIZER_RESPOND}</li>
       * <li>{@link #CAN_PARTIALLY_UPDATE}</li>
       * <li>{@link #CALENDAR_LOCATION}</li>
       * <li>{@link #CALENDAR_TIME_ZONE}</li>
       * <li>{@link #CALENDAR_ACCESS_LEVEL}</li>
       * <li>{@link #DELETED}</li>
       * <li>{@link #CAL_SYNC1}</li>
       * <li>{@link #CAL_SYNC2}</li>
       * <li>{@link #CAL_SYNC3}</li>
       * <li>{@link #CAL_SYNC4}</li>
       * <li>{@link #CAL_SYNC5}</li>
       * <li>{@link #CAL_SYNC6}</li>
       * <li>{@link #CAL_SYNC7}</li>
       * <li>{@link #CAL_SYNC8}</li>
       * <li>{@link #CAL_SYNC9}</li>
       * <li>{@link #CAL_SYNC10}</li>
       * </ul>
       */
      public static final class Calendars implements BaseColumns, SyncColumns, CalendarColumns {
  
          /**
           * This utility class cannot be instantiated
           */
          private Calendars() {}
  
          /**
           * The content:// style URL for accessing Calendars
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/calendars");
  
          /**
           * The content:// style URL for querying Calendars table in the managed profile. Appending
           * a calendar id using {@link ContentUris#withAppendedId(Uri, long)} specifies
           * a single calendar.
           *
           * <p>The following columns are allowed to be queried via this uri:
           * <ul>
           * <li>{@link #_ID}</li>
           * <li>{@link #CALENDAR_COLOR}</li>
           * <li>{@link #VISIBLE}</li>
           * <li>{@link #CALENDAR_LOCATION}</li>
           * <li>{@link #CALENDAR_TIME_ZONE}</li>
           * <li>{@link #IS_PRIMARY}</li>
           * </ul>
           *
           * <p>{@link IllegalArgumentException} is thrown if there exists columns in the
           * projection of the query to this uri that are not contained in the above list.
           *
           * <p>This uri returns an empty cursor if the calling user is not a parent profile
           * of a managed profile, or the managed profile is disabled, or cross-profile calendar is
           * disabled in Settings, or this uri is queried from a package that is not allowed by
           * the profile owner of the managed profile via
           * {@link DevicePolicyManager#setCrossProfileCalendarPackages(ComponentName, Set)}.
           *
           * <p>Apps can register a {@link android.database.ContentObserver} for this URI to listen
           * to changes.
           *
           * @see DevicePolicyManager#getCrossProfileCalendarPackages(ComponentName)
           * @see Settings.Secure#CROSS_PROFILE_CALENDAR_ENABLED
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/calendars");
  
          /**
           * The default sort order for this table
           */
          public static final String DEFAULT_SORT_ORDER = CALENDAR_DISPLAY_NAME;
  
          /**
           * The name of the calendar. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String NAME = "name";
  
          /**
           * The default location for the calendar. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CALENDAR_LOCATION = "calendar_location";
  
          /**
           * These fields are only writable by a sync adapter. To modify them the
           * caller must include {@link #CALLER_IS_SYNCADAPTER},
           * {@link #ACCOUNT_NAME}, and {@link #ACCOUNT_TYPE} in the Uri's query
           * parameters. TODO move to provider
           *
           * @hide
           */
          @TestApi
          public static final String[] SYNC_WRITABLE_COLUMNS = new String[] {
              ACCOUNT_NAME,
              ACCOUNT_TYPE,
              _SYNC_ID,
              DIRTY,
              MUTATORS,
              OWNER_ACCOUNT,
              MAX_REMINDERS,
              ALLOWED_REMINDERS,
              CAN_MODIFY_TIME_ZONE,
              CAN_ORGANIZER_RESPOND,
              CAN_PARTIALLY_UPDATE,
              CALENDAR_LOCATION,
              CALENDAR_TIME_ZONE,
              CALENDAR_ACCESS_LEVEL,
              DELETED,
              CAL_SYNC1,
              CAL_SYNC2,
              CAL_SYNC3,
              CAL_SYNC4,
              CAL_SYNC5,
              CAL_SYNC6,
              CAL_SYNC7,
              CAL_SYNC8,
              CAL_SYNC9,
              CAL_SYNC10,
          };
      }
  
      /**
       * Columns from the Attendees table that other tables join into themselves.
       */
      protected interface AttendeesColumns {
  
          /**
           * The id of the event. Column name.
           * <P>Type: INTEGER</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The name of the attendee. Column name.
           * <P>Type: STRING</P>
           */
          public static final String ATTENDEE_NAME = "attendeeName";
  
          /**
           * The email address of the attendee. Column name.
           * <P>Type: STRING</P>
           */
          public static final String ATTENDEE_EMAIL = "attendeeEmail";
  
          /**
           * The relationship of the attendee to the user. Column name.
           * <P>Type: INTEGER (one of {@link #RELATIONSHIP_ATTENDEE}, ...}.</P>
           */
          public static final String ATTENDEE_RELATIONSHIP = "attendeeRelationship";
  
          public static final int RELATIONSHIP_NONE = 0;
          public static final int RELATIONSHIP_ATTENDEE = 1;
          public static final int RELATIONSHIP_ORGANIZER = 2;
          public static final int RELATIONSHIP_PERFORMER = 3;
          public static final int RELATIONSHIP_SPEAKER = 4;
  
          /**
           * The type of attendee. Column name.
           * <P>
           * Type: Integer (one of {@link #TYPE_NONE}, {@link #TYPE_REQUIRED},
           * {@link #TYPE_OPTIONAL}, {@link #TYPE_RESOURCE})
           * </P>
           */
          public static final String ATTENDEE_TYPE = "attendeeType";
  
          public static final int TYPE_NONE = 0;
          public static final int TYPE_REQUIRED = 1;
          public static final int TYPE_OPTIONAL = 2;
          /**
           * This specifies that an attendee is a resource, like a room, a
           * cabbage, or something and not an actual person.
           */
          public static final int TYPE_RESOURCE = 3;
  
          /**
           * The attendance status of the attendee. Column name.
           * <P>Type: Integer (one of {@link #ATTENDEE_STATUS_ACCEPTED}, ...).</P>
           */
          public static final String ATTENDEE_STATUS = "attendeeStatus";
  
          public static final int ATTENDEE_STATUS_NONE = 0;
          public static final int ATTENDEE_STATUS_ACCEPTED = 1;
          public static final int ATTENDEE_STATUS_DECLINED = 2;
          public static final int ATTENDEE_STATUS_INVITED = 3;
          public static final int ATTENDEE_STATUS_TENTATIVE = 4;
  
          /**
           * The identity of the attendee as referenced in
           * {@link ContactsContract.CommonDataKinds.Identity#IDENTITY}.
           * This is required only if {@link #ATTENDEE_ID_NAMESPACE} is present. Column name.
           * <P>Type: STRING</P>
           */
          public static final String ATTENDEE_IDENTITY = "attendeeIdentity";
  
          /**
           * The identity name space of the attendee as referenced in
           * {@link ContactsContract.CommonDataKinds.Identity#NAMESPACE}.
           * This is required only if {@link #ATTENDEE_IDENTITY} is present. Column name.
           * <P>Type: STRING</P>
           */
          public static final String ATTENDEE_ID_NAMESPACE = "attendeeIdNamespace";
      }
  
      /**
       * Fields and helpers for interacting with Attendees. Each row of this table
       * represents a single attendee or guest of an event. Calling
       * {@link #query(ContentResolver, long, String[])} will return a list of attendees for
       * the event with the given eventId. Both apps and sync adapters may write
       * to this table. There are six writable fields and all of them except
       * {@link #ATTENDEE_NAME} must be included when inserting a new attendee.
       * They are:
       * <ul>
       * <li>{@link #EVENT_ID}</li>
       * <li>{@link #ATTENDEE_NAME}</li>
       * <li>{@link #ATTENDEE_EMAIL}</li>
       * <li>{@link #ATTENDEE_RELATIONSHIP}</li>
       * <li>{@link #ATTENDEE_TYPE}</li>
       * <li>{@link #ATTENDEE_STATUS}</li>
       * <li>{@link #ATTENDEE_IDENTITY}</li>
       * <li>{@link #ATTENDEE_ID_NAMESPACE}</li>
       * </ul>
       */
      public static final class Attendees implements BaseColumns, AttendeesColumns, EventsColumns {
  
          /**
           * The content:// style URL for accessing Attendees data
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/attendees");
          private static final String ATTENDEES_WHERE = Attendees.EVENT_ID + "=?";
  
          /**
           * This utility class cannot be instantiated
           */
          private Attendees() {}
  
          /**
           * Queries all attendees associated with the given event. This is a
           * blocking call and should not be done on the UI thread.
           *
           * @param cr The content resolver to use for the query
           * @param eventId The id of the event to retrieve attendees for
           * @param projection the columns to return in the cursor
           * @return A Cursor containing all attendees for the event
           */
          public static final Cursor query(ContentResolver cr, long eventId, String[] projection) {
              String[] attArgs = {Long.toString(eventId)};
              return cr.query(CONTENT_URI, projection, ATTENDEES_WHERE, attArgs /* selection args */,
                      null /* sort order */);
          }
      }
  
      /**
       * Columns from the Events table that other tables join into themselves.
       */
      protected interface EventsColumns {
  
          /**
           * The {@link Calendars#_ID} of the calendar the event belongs to.
           * Column name.
           * <P>Type: INTEGER</P>
           */
          public static final String CALENDAR_ID = "calendar_id";
  
          /**
           * The title of the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String TITLE = "title";
  
          /**
           * The description of the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String DESCRIPTION = "description";
  
          /**
           * Where the event takes place. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String EVENT_LOCATION = "eventLocation";
  
          /**
           * A secondary color for the individual event. This should only be
           * updated by the sync adapter for a given account.
           * <P>Type: INTEGER</P>
           */
          public static final String EVENT_COLOR = "eventColor";
  
          /**
           * A secondary color key for the individual event. NULL or an empty
           * string are reserved for indicating that the event does not use a key
           * for looking up the color. The provider will update
           * {@link #EVENT_COLOR} automatically when a valid key is written to
           * this column. The key must reference an existing row of the
           * {@link Colors} table. @see Colors
           * <P>
           * Type: TEXT
           * </P>
           */
          public static final String EVENT_COLOR_KEY = "eventColor_index";
  
          /**
           * This will be {@link #EVENT_COLOR} if it is not null; otherwise, this will be
           * {@link Calendars#CALENDAR_COLOR}.
           * Read-only value. To modify, write to {@link #EVENT_COLOR} or
           * {@link Calendars#CALENDAR_COLOR} directly.
           *<P>
           *     Type: INTEGER
           *</P>
           */
          public static final String DISPLAY_COLOR = "displayColor";
  
          /**
           * The event status. Column name.
           * <P>Type: INTEGER (one of {@link #STATUS_TENTATIVE}...)</P>
           */
          public static final String STATUS = "eventStatus";
  
          public static final int STATUS_TENTATIVE = 0;
          public static final int STATUS_CONFIRMED = 1;
          public static final int STATUS_CANCELED = 2;
  
          /**
           * This is a copy of the attendee status for the owner of this event.
           * This field is copied here so that we can efficiently filter out
           * events that are declined without having to look in the Attendees
           * table. Column name.
           *
           * <P>Type: INTEGER (int)</P>
           */
          public static final String SELF_ATTENDEE_STATUS = "selfAttendeeStatus";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA1 = "sync_data1";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA2 = "sync_data2";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA3 = "sync_data3";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA4 = "sync_data4";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA5 = "sync_data5";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA6 = "sync_data6";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA7 = "sync_data7";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA8 = "sync_data8";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA9 = "sync_data9";
  
          /**
           * This column is available for use by sync adapters. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String SYNC_DATA10 = "sync_data10";
  
          /**
           * Used to indicate that a row is not a real event but an original copy of a locally
           * modified event. A copy is made when an event changes from non-dirty to dirty and the
           * event is on a calendar with {@link Calendars#CAN_PARTIALLY_UPDATE} set to 1. This copy
           * does not get expanded in the instances table and is only visible in queries made by a
           * sync adapter. The copy gets removed when the event is changed back to non-dirty by a
           * sync adapter.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String LAST_SYNCED = "lastSynced";
  
          /**
           * The time the event starts in UTC millis since epoch. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String DTSTART = "dtstart";
  
          /**
           * The time the event ends in UTC millis since epoch. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String DTEND = "dtend";
  
          /**
           * The duration of the event in RFC2445 format. Column name.
           * <P>Type: TEXT (duration in RFC2445 format)</P>
           */
          public static final String DURATION = "duration";
  
          /**
           * The timezone for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String EVENT_TIMEZONE = "eventTimezone";
  
          /**
           * The timezone for the end time of the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String EVENT_END_TIMEZONE = "eventEndTimezone";
  
          /**
           * Is the event all day (time zone independent). Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String ALL_DAY = "allDay";
  
          /**
           * Defines how the event shows up for others when the calendar is
           * shared. Column name.
           * <P>Type: INTEGER (One of {@link #ACCESS_DEFAULT}, ...)</P>
           */
          public static final String ACCESS_LEVEL = "accessLevel";
  
          /**
           * Default access is controlled by the server and will be treated as
           * public on the device.
           */
          public static final int ACCESS_DEFAULT = 0;
          /**
           * Confidential is not used by the app.
           */
          public static final int ACCESS_CONFIDENTIAL = 1;
          /**
           * Private shares the event as a free/busy slot with no details.
           */
          public static final int ACCESS_PRIVATE = 2;
          /**
           * Public makes the contents visible to anyone with access to the
           * calendar.
           */
          public static final int ACCESS_PUBLIC = 3;
  
          /**
           * If this event counts as busy time or is still free time that can be
           * scheduled over. Column name.
           * <P>
           * Type: INTEGER (One of {@link #AVAILABILITY_BUSY},
           * {@link #AVAILABILITY_FREE}, {@link #AVAILABILITY_TENTATIVE})
           * </P>
           */
          public static final String AVAILABILITY = "availability";
  
          /**
           * Indicates that this event takes up time and will conflict with other
           * events.
           */
          public static final int AVAILABILITY_BUSY = 0;
          /**
           * Indicates that this event is free time and will not conflict with
           * other events.
           */
          public static final int AVAILABILITY_FREE = 1;
          /**
           * Indicates that the owner's availability may change, but should be
           * considered busy time that will conflict.
           */
          public static final int AVAILABILITY_TENTATIVE = 2;
  
          /**
           * Whether the event has an alarm or not. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String HAS_ALARM = "hasAlarm";
  
          /**
           * Whether the event has extended properties or not. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String HAS_EXTENDED_PROPERTIES = "hasExtendedProperties";
  
          /**
           * The recurrence rule for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String RRULE = "rrule";
  
          /**
           * The recurrence dates for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String RDATE = "rdate";
  
          /**
           * The recurrence exception rule for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String EXRULE = "exrule";
  
          /**
           * The recurrence exception dates for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String EXDATE = "exdate";
  
          /**
           * The {@link Events#_ID} of the original recurring event for which this
           * event is an exception. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String ORIGINAL_ID = "original_id";
  
          /**
           * The _sync_id of the original recurring event for which this event is
           * an exception. The provider should keep the original_id in sync when
           * this is updated. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String ORIGINAL_SYNC_ID = "original_sync_id";
  
          /**
           * The original instance time of the recurring event for which this
           * event is an exception. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String ORIGINAL_INSTANCE_TIME = "originalInstanceTime";
  
          /**
           * The allDay status (true or false) of the original recurring event
           * for which this event is an exception. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String ORIGINAL_ALL_DAY = "originalAllDay";
  
          /**
           * The last date this event repeats on, or NULL if it never ends. Column
           * name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String LAST_DATE = "lastDate";
  
          /**
           * Whether the event has attendee information.  True if the event
           * has full attendee data, false if the event has information about
           * self only. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String HAS_ATTENDEE_DATA = "hasAttendeeData";
  
          /**
           * Whether guests can modify the event. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String GUESTS_CAN_MODIFY = "guestsCanModify";
  
          /**
           * Whether guests can invite other guests. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String GUESTS_CAN_INVITE_OTHERS = "guestsCanInviteOthers";
  
          /**
           * Whether guests can see the list of attendees. Column name.
           * <P>Type: INTEGER (boolean)</P>
           */
          public static final String GUESTS_CAN_SEE_GUESTS = "guestsCanSeeGuests";
  
          /**
           * Email of the organizer (owner) of the event. Column name.
           * <P>Type: STRING</P>
           */
          public static final String ORGANIZER = "organizer";
  
          /**
           * Are we the organizer of this event. If this column is not explicitly set, the provider
           * will return 1 if {@link #ORGANIZER} is equal to {@link Calendars#OWNER_ACCOUNT}.
           * Column name.
           * <P>Type: STRING</P>
           */
          public static final String IS_ORGANIZER = "isOrganizer";
  
          /**
           * Whether the user can invite others to the event. The
           * GUESTS_CAN_INVITE_OTHERS is a setting that applies to an arbitrary
           * guest, while CAN_INVITE_OTHERS indicates if the user can invite
           * others (either through GUESTS_CAN_INVITE_OTHERS or because the user
           * has modify access to the event). Column name.
           * <P>Type: INTEGER (boolean, readonly)</P>
           */
          public static final String CAN_INVITE_OTHERS = "canInviteOthers";
  
          /**
           * The package name of the custom app that can provide a richer
           * experience for the event. See the ACTION TYPE
           * {@link CalendarContract#ACTION_HANDLE_CUSTOM_EVENT} for details.
           * Column name.
           * <P> Type: TEXT </P>
           */
          public static final String CUSTOM_APP_PACKAGE = "customAppPackage";
  
          /**
           * The URI used by the custom app for the event. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String CUSTOM_APP_URI = "customAppUri";
  
          /**
           * The UID for events added from the RFC 2445 iCalendar format.
           * Column name.
           * <P>Type: TEXT</P>
           */
          public static final String UID_2445 = "uid2445";
      }
  
      /**
       * Class that represents an Event Entity. There is one entry per event.
       * Recurring events show up as a single entry. This is a helper class to
       * make batch operations easier. A {@link ContentResolver} or
       * {@link ContentProviderClient} is required as the helper does additional
       * queries to add reminders and attendees to each entry.
       */
      public static final class EventsEntity implements BaseColumns, SyncColumns, EventsColumns {
          /**
           * The content:// style URL for this table
           */
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY +
                  "/event_entities");
  
          /**
           * This utility class cannot be instantiated
           */
          private EventsEntity() {}
  
          /**
           * Creates a new iterator for events
           *
           * @param cursor An event query
           * @param resolver For performing additional queries
           * @return an EntityIterator containing one entity per event in the
           *         cursor
           */
          public static EntityIterator newEntityIterator(Cursor cursor, ContentResolver resolver) {
              return new EntityIteratorImpl(cursor, resolver);
          }
  
          /**
           * Creates a new iterator for events
           *
           * @param cursor An event query
           * @param provider For performing additional queries
           * @return an EntityIterator containing one entity per event in the
           *         cursor
           */
          public static EntityIterator newEntityIterator(Cursor cursor,
                  ContentProviderClient provider) {
              return new EntityIteratorImpl(cursor, provider);
          }
  
          private static class EntityIteratorImpl extends CursorEntityIterator {
              private final ContentResolver mResolver;
              private final ContentProviderClient mProvider;
  
              private static final String[] REMINDERS_PROJECTION = new String[] {
                      Reminders.MINUTES,
                      Reminders.METHOD,
              };
              private static final int COLUMN_MINUTES = 0;
              private static final int COLUMN_METHOD = 1;
  
              private static final String[] ATTENDEES_PROJECTION = new String[] {
                      Attendees.ATTENDEE_NAME,
                      Attendees.ATTENDEE_EMAIL,
                      Attendees.ATTENDEE_RELATIONSHIP,
                      Attendees.ATTENDEE_TYPE,
                      Attendees.ATTENDEE_STATUS,
                      Attendees.ATTENDEE_IDENTITY,
                      Attendees.ATTENDEE_ID_NAMESPACE
              };
              private static final int COLUMN_ATTENDEE_NAME = 0;
              private static final int COLUMN_ATTENDEE_EMAIL = 1;
              private static final int COLUMN_ATTENDEE_RELATIONSHIP = 2;
              private static final int COLUMN_ATTENDEE_TYPE = 3;
              private static final int COLUMN_ATTENDEE_STATUS = 4;
              private static final int COLUMN_ATTENDEE_IDENTITY = 5;
              private static final int COLUMN_ATTENDEE_ID_NAMESPACE = 6;
  
              private static final String[] EXTENDED_PROJECTION = new String[] {
                      ExtendedProperties._ID,
                      ExtendedProperties.NAME,
                      ExtendedProperties.VALUE
              };
              private static final int COLUMN_ID = 0;
              private static final int COLUMN_NAME = 1;
              private static final int COLUMN_VALUE = 2;
  
              private static final String WHERE_EVENT_ID = "event_id=?";
  
              public EntityIteratorImpl(Cursor cursor, ContentResolver resolver) {
                  super(cursor);
                  mResolver = resolver;
                  mProvider = null;
              }
  
              public EntityIteratorImpl(Cursor cursor, ContentProviderClient provider) {
                  super(cursor);
                  mResolver = null;
                  mProvider = provider;
              }
  
              @Override
              public Entity getEntityAndIncrementCursor(Cursor cursor) throws RemoteException {
                  // we expect the cursor is already at the row we need to read from
                  final long eventId = cursor.getLong(cursor.getColumnIndexOrThrow(Events._ID));
                  ContentValues cv = new ContentValues();
                  cv.put(Events._ID, eventId);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, CALENDAR_ID);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, TITLE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, DESCRIPTION);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EVENT_LOCATION);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, STATUS);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, SELF_ATTENDEE_STATUS);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, DTSTART);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, DTEND);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, DURATION);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EVENT_TIMEZONE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EVENT_END_TIMEZONE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ALL_DAY);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, ACCESS_LEVEL);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, AVAILABILITY);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, EVENT_COLOR);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EVENT_COLOR_KEY);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, HAS_ALARM);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv,
                          HAS_EXTENDED_PROPERTIES);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, RRULE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, RDATE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EXRULE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, EXDATE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ORIGINAL_SYNC_ID);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ORIGINAL_ID);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv,
                          ORIGINAL_INSTANCE_TIME);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, ORIGINAL_ALL_DAY);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, LAST_DATE);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, HAS_ATTENDEE_DATA);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv,
                          GUESTS_CAN_INVITE_OTHERS);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, GUESTS_CAN_MODIFY);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, GUESTS_CAN_SEE_GUESTS);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CUSTOM_APP_PACKAGE);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CUSTOM_APP_URI);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, UID_2445);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, ORGANIZER);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, IS_ORGANIZER);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, _SYNC_ID);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, DIRTY);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, MUTATORS);
                  DatabaseUtils.cursorLongToContentValuesIfPresent(cursor, cv, LAST_SYNCED);
                  DatabaseUtils.cursorIntToContentValuesIfPresent(cursor, cv, DELETED);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA1);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA2);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA3);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA4);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA5);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA6);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA7);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA8);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA9);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, SYNC_DATA10);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC1);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC2);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC3);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC4);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC5);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC6);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC7);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC8);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC9);
                  DatabaseUtils.cursorStringToContentValuesIfPresent(cursor, cv, CAL_SYNC10);
  
                  Entity entity = new Entity(cv);
                  Cursor subCursor;
                  if (mResolver != null) {
                      subCursor = mResolver.query(Reminders.CONTENT_URI, REMINDERS_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) }  /* selectionArgs */,
                              null /* sortOrder */);
                  } else {
                      subCursor = mProvider.query(Reminders.CONTENT_URI, REMINDERS_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) }  /* selectionArgs */,
                              null /* sortOrder */);
                  }
                  try {
                      while (subCursor.moveToNext()) {
                          ContentValues reminderValues = new ContentValues();
                          reminderValues.put(Reminders.MINUTES, subCursor.getInt(COLUMN_MINUTES));
                          reminderValues.put(Reminders.METHOD, subCursor.getInt(COLUMN_METHOD));
                          entity.addSubValue(Reminders.CONTENT_URI, reminderValues);
                      }
                  } finally {
                      subCursor.close();
                  }
  
                  if (mResolver != null) {
                      subCursor = mResolver.query(Attendees.CONTENT_URI, ATTENDEES_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) } /* selectionArgs */,
                              null /* sortOrder */);
                  } else {
                      subCursor = mProvider.query(Attendees.CONTENT_URI, ATTENDEES_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) } /* selectionArgs */,
                              null /* sortOrder */);
                  }
                  try {
                      while (subCursor.moveToNext()) {
                          ContentValues attendeeValues = new ContentValues();
                          attendeeValues.put(Attendees.ATTENDEE_NAME,
                                  subCursor.getString(COLUMN_ATTENDEE_NAME));
                          attendeeValues.put(Attendees.ATTENDEE_EMAIL,
                                  subCursor.getString(COLUMN_ATTENDEE_EMAIL));
                          attendeeValues.put(Attendees.ATTENDEE_RELATIONSHIP,
                                  subCursor.getInt(COLUMN_ATTENDEE_RELATIONSHIP));
                          attendeeValues.put(Attendees.ATTENDEE_TYPE,
                                  subCursor.getInt(COLUMN_ATTENDEE_TYPE));
                          attendeeValues.put(Attendees.ATTENDEE_STATUS,
                                  subCursor.getInt(COLUMN_ATTENDEE_STATUS));
                          attendeeValues.put(Attendees.ATTENDEE_IDENTITY,
                                  subCursor.getString(COLUMN_ATTENDEE_IDENTITY));
                          attendeeValues.put(Attendees.ATTENDEE_ID_NAMESPACE,
                                  subCursor.getString(COLUMN_ATTENDEE_ID_NAMESPACE));
                          entity.addSubValue(Attendees.CONTENT_URI, attendeeValues);
                      }
                  } finally {
                      subCursor.close();
                  }
  
                  if (mResolver != null) {
                      subCursor = mResolver.query(ExtendedProperties.CONTENT_URI, EXTENDED_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) } /* selectionArgs */,
                              null /* sortOrder */);
                  } else {
                      subCursor = mProvider.query(ExtendedProperties.CONTENT_URI, EXTENDED_PROJECTION,
                              WHERE_EVENT_ID,
                              new String[] { Long.toString(eventId) } /* selectionArgs */,
                              null /* sortOrder */);
                  }
                  try {
                      while (subCursor.moveToNext()) {
                          ContentValues extendedValues = new ContentValues();
                          extendedValues.put(ExtendedProperties._ID,
                                  subCursor.getString(COLUMN_ID));
                          extendedValues.put(ExtendedProperties.NAME,
                                  subCursor.getString(COLUMN_NAME));
                          extendedValues.put(ExtendedProperties.VALUE,
                                  subCursor.getString(COLUMN_VALUE));
                          entity.addSubValue(ExtendedProperties.CONTENT_URI, extendedValues);
                      }
                  } finally {
                      subCursor.close();
                  }
  
                  cursor.moveToNext();
                  return entity;
              }
          }
      }
  
      /**
       * Constants and helpers for the Events table, which contains details for
       * individual events. <h3>Operations</h3> All operations can be done either
       * as an app or as a sync adapter. To perform an operation as a sync adapter
       * {@link #CALLER_IS_SYNCADAPTER} should be set to true and
       * {@link #ACCOUNT_NAME} and {@link #ACCOUNT_TYPE} must be set in the Uri
       * parameters. See
       * {@link Uri.Builder#appendQueryParameter(java.lang.String, java.lang.String)}
       * for details on adding parameters. Sync adapters have write access to more
       * columns but are restricted to a single account at a time.
       * <dl>
       * <dt><b>Insert</b></dt>
       * <dd>When inserting a new event the following fields must be included:
       * <ul>
       * <li>dtstart</li>
       * <li>dtend if the event is non-recurring</li>
       * <li>duration if the event is recurring</li>
       * <li>rrule or rdate if the event is recurring</li>
       * <li>eventTimezone</li>
       * <li>a calendar_id</li>
       * </ul>
       * There are also further requirements when inserting or updating an event.
       * See the section on Writing to Events.</dd>
       * <dt><b>Update</b></dt>
       * <dd>To perform an update of an Event the {@link Events#_ID} of the event
       * should be provided either as an appended id to the Uri (
       * {@link ContentUris#withAppendedId}) or as the first selection item--the
       * selection should start with "_id=?" and the first selectionArg should be
       * the _id of the event. Updates may also be done using a selection and no
       * id. Updating an event must respect the same rules as inserting and is
       * further restricted in the fields that can be written. See the section on
       * Writing to Events.</dd>
       * <dt><b>Delete</b></dt>
       * <dd>Events can be deleted either by the {@link Events#_ID} as an appended
       * id on the Uri or using any standard selection. If an appended id is used
       * a selection is not allowed. There are two versions of delete: as an app
       * and as a sync adapter. An app delete will set the deleted column on an
       * event and remove all instances of that event. A sync adapter delete will
       * remove the event from the database and all associated data.</dd>
       * <dt><b>Query</b></dt>
       * <dd>Querying the Events table will get you all information about a set of
       * events except their reminders, attendees, and extended properties. There
       * will be one row returned for each event that matches the query selection,
       * or at most a single row if the {@link Events#_ID} is appended to the Uri.
       * Recurring events will only return a single row regardless of the number
       * of times that event repeats.</dd>
       * </dl>
       * <h3>Writing to Events</h3> There are further restrictions on all Updates
       * and Inserts in the Events table:
       * <ul>
       * <li>If allDay is set to 1 eventTimezone must be {@link Time#TIMEZONE_UTC}
       * and the time must correspond to a midnight boundary.</li>
       * <li>Exceptions are not allowed to recur. If rrule or rdate is not empty,
       * original_id and original_sync_id must be empty.</li>
       * <li>In general a calendar_id should not be modified after insertion. This
       * is not explicitly forbidden but many sync adapters will not behave in an
       * expected way if the calendar_id is modified.</li>
       * </ul>
       * The following Events columns are writable by both an app and a sync
       * adapter.
       * <ul>
       * <li>{@link #CALENDAR_ID}</li>
       * <li>{@link #ORGANIZER}</li>
       * <li>{@link #TITLE}</li>
       * <li>{@link #EVENT_LOCATION}</li>
       * <li>{@link #DESCRIPTION}</li>
       * <li>{@link #EVENT_COLOR}</li>
       * <li>{@link #DTSTART}</li>
       * <li>{@link #DTEND}</li>
       * <li>{@link #EVENT_TIMEZONE}</li>
       * <li>{@link #EVENT_END_TIMEZONE}</li>
       * <li>{@link #DURATION}</li>
       * <li>{@link #ALL_DAY}</li>
       * <li>{@link #RRULE}</li>
       * <li>{@link #RDATE}</li>
       * <li>{@link #EXRULE}</li>
       * <li>{@link #EXDATE}</li>
       * <li>{@link #ORIGINAL_ID}</li>
       * <li>{@link #ORIGINAL_SYNC_ID}</li>
       * <li>{@link #ORIGINAL_INSTANCE_TIME}</li>
       * <li>{@link #ORIGINAL_ALL_DAY}</li>
       * <li>{@link #ACCESS_LEVEL}</li>
       * <li>{@link #AVAILABILITY}</li>
       * <li>{@link #GUESTS_CAN_MODIFY}</li>
       * <li>{@link #GUESTS_CAN_INVITE_OTHERS}</li>
       * <li>{@link #GUESTS_CAN_SEE_GUESTS}</li>
       * <li>{@link #CUSTOM_APP_PACKAGE}</li>
       * <li>{@link #CUSTOM_APP_URI}</li>
       * <li>{@link #UID_2445}</li>
       * </ul>
       * The following Events columns are writable only by a sync adapter
       * <ul>
       * <li>{@link #DIRTY}</li>
       * <li>{@link #MUTATORS}</li>
       * <li>{@link #_SYNC_ID}</li>
       * <li>{@link #SYNC_DATA1}</li>
       * <li>{@link #SYNC_DATA2}</li>
       * <li>{@link #SYNC_DATA3}</li>
       * <li>{@link #SYNC_DATA4}</li>
       * <li>{@link #SYNC_DATA5}</li>
       * <li>{@link #SYNC_DATA6}</li>
       * <li>{@link #SYNC_DATA7}</li>
       * <li>{@link #SYNC_DATA8}</li>
       * <li>{@link #SYNC_DATA9}</li>
       * <li>{@link #SYNC_DATA10}</li>
       * </ul>
       * The remaining columns are either updated by the provider only or are
       * views into other tables and cannot be changed through the Events table.
       */
      public static final class Events implements BaseColumns, SyncColumns, EventsColumns,
              CalendarColumns {
  
          /**
           * The content:// style URL for interacting with events. Appending an
           * event id using {@link ContentUris#withAppendedId(Uri, long)} will
           * specify a single event.
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI =
                  Uri.parse("content://" + AUTHORITY + "/events");
  
          /**
           * The content:// style URL for querying Events table in the managed profile. Appending an
           * event id using {@link ContentUris#withAppendedId(Uri, long)} specifies a single event.
           *
           * <p>The following columns are allowed to be queried via this uri:
           * <ul>
           * <li>{@link #_ID}</li>
           * <li>{@link #CALENDAR_ID}</li>
           * <li>{@link #TITLE}</li>
           * <li>{@link #EVENT_LOCATION}</li>
           * <li>{@link #EVENT_COLOR}</li>
           * <li>{@link #STATUS}</li>
           * <li>{@link #DTSTART}</li>
           * <li>{@link #DTEND}</li>
           * <li>{@link #EVENT_TIMEZONE}</li>
           * <li>{@link #EVENT_END_TIMEZONE}</li>
           * <li>{@link #DURATION}</li>
           * <li>{@link #ALL_DAY}</li>
           * <li>{@link #AVAILABILITY}</li>
           * <li>{@link #RRULE}</li>
           * <li>{@link #RDATE}</li>
           * <li>{@link #LAST_DATE}</li>
           * <li>{@link #EXRULE}</li>
           * <li>{@link #EXDATE}</li>
           * <li>{@link #SELF_ATTENDEE_STATUS}</li>
           * <li>{@link #DISPLAY_COLOR}</li>
           * <li>{@link #CALENDAR_COLOR}</li>
           * <li>{@link #VISIBLE}</li>
           * <li>{@link #CALENDAR_TIME_ZONE}</li>
           * <li>{@link #IS_PRIMARY}</li>
           * </ul>
           *
           * <p>{@link IllegalArgumentException} is thrown if there exists columns in the
           * projection of the query to this uri that are not contained in the above list.
           *
           * <p>This uri returns an empty cursor if the calling user is not a parent profile
           * of a managed profile, or the managed profile is disabled, or cross-profile calendar is
           * disabled in Settings, or this uri is queried from a package that is not allowed by
           * the profile owner of the managed profile via
           * {@link DevicePolicyManager#setCrossProfileCalendarPackages(ComponentName, Set)}.
           *
           * <p>Apps can register a {@link android.database.ContentObserver} for this URI to listen
           * to changes.
           *
           * @see DevicePolicyManager#getCrossProfileCalendarPackages(ComponentName)
           * @see Settings.Secure#CROSS_PROFILE_CALENDAR_ENABLED
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/events");
  
          /**
           * The content:// style URI for recurring event exceptions.  Insertions require an
           * appended event ID.  Deletion of exceptions requires both the original event ID and
           * the exception event ID (see {@link Uri.Builder#appendPath}).
           */
          public static final Uri CONTENT_EXCEPTION_URI =
                  Uri.parse("content://" + AUTHORITY + "/exception");
  
          /**
           * This utility class cannot be instantiated
           */
          private Events() {}
  
          /**
           * The default sort order for this table
           */
          private static final String DEFAULT_SORT_ORDER = "";
  
          /**
           * These are columns that should only ever be updated by the provider,
           * either because they are views mapped to another table or because they
           * are used for provider only functionality. TODO move to provider
           *
           * @hide
           */
          @UnsupportedAppUsage
          public static String[] PROVIDER_WRITABLE_COLUMNS = new String[] {
                  ACCOUNT_NAME,
                  ACCOUNT_TYPE,
                  CAL_SYNC1,
                  CAL_SYNC2,
                  CAL_SYNC3,
                  CAL_SYNC4,
                  CAL_SYNC5,
                  CAL_SYNC6,
                  CAL_SYNC7,
                  CAL_SYNC8,
                  CAL_SYNC9,
                  CAL_SYNC10,
                  ALLOWED_REMINDERS,
                  ALLOWED_ATTENDEE_TYPES,
                  ALLOWED_AVAILABILITY,
                  CALENDAR_ACCESS_LEVEL,
                  CALENDAR_COLOR,
                  CALENDAR_TIME_ZONE,
                  CAN_MODIFY_TIME_ZONE,
                  CAN_ORGANIZER_RESPOND,
                  CALENDAR_DISPLAY_NAME,
                  CAN_PARTIALLY_UPDATE,
                  SYNC_EVENTS,
                  VISIBLE,
          };
  
          /**
           * These fields are only writable by a sync adapter. To modify them the
           * caller must include CALLER_IS_SYNCADAPTER, _SYNC_ACCOUNT, and
           * _SYNC_ACCOUNT_TYPE in the query parameters. TODO move to provider.
           *
           * @hide
           */
          @TestApi
          public static final String[] SYNC_WRITABLE_COLUMNS = new String[] {
              _SYNC_ID,
              DIRTY,
              MUTATORS,
              SYNC_DATA1,
              SYNC_DATA2,
              SYNC_DATA3,
              SYNC_DATA4,
              SYNC_DATA5,
              SYNC_DATA6,
              SYNC_DATA7,
              SYNC_DATA8,
              SYNC_DATA9,
              SYNC_DATA10,
          };
      }
  
      /**
       * Fields and helpers for interacting with Instances. An instance is a
       * single occurrence of an event including time zone specific start and end
       * days and minutes. The instances table is not writable and only provides a
       * way to query event occurrences.
       */
      public static final class Instances implements BaseColumns, EventsColumns, CalendarColumns {
  
          private static final String WHERE_CALENDARS_SELECTED = Calendars.VISIBLE + "=?";
          private static final String[] WHERE_CALENDARS_ARGS = {
              "1"
          };
  
          /**
           * This utility class cannot be instantiated
           */
          private Instances() {}
  
          /**
           * Performs a query to return all visible instances in the given range.
           * This is a blocking function and should not be done on the UI thread.
           * This will cause an expansion of recurring events to fill this time
           * range if they are not already expanded and will slow down for larger
           * time ranges with many recurring events.
           *
           * @param cr The ContentResolver to use for the query
           * @param projection The columns to return
           * @param begin The start of the time range to query in UTC millis since
           *            epoch
           * @param end The end of the time range to query in UTC millis since
           *            epoch
           * @return A Cursor containing all instances in the given range
           */
          public static final Cursor query(ContentResolver cr, String[] projection,
                                           long begin, long end) {
              Uri.Builder builder = CONTENT_URI.buildUpon();
              ContentUris.appendId(builder, begin);
              ContentUris.appendId(builder, end);
              return cr.query(builder.build(), projection, WHERE_CALENDARS_SELECTED,
                      WHERE_CALENDARS_ARGS, DEFAULT_SORT_ORDER);
          }
  
          /**
           * Performs a query to return all visible instances in the given range
           * that match the given query. This is a blocking function and should
           * not be done on the UI thread. This will cause an expansion of
           * recurring events to fill this time range if they are not already
           * expanded and will slow down for larger time ranges with many
           * recurring events.
           *
           * @param cr The ContentResolver to use for the query
           * @param projection The columns to return
           * @param begin The start of the time range to query in UTC millis since
           *            epoch
           * @param end The end of the time range to query in UTC millis since
           *            epoch
           * @param searchQuery A string of space separated search terms. Segments
           *            enclosed by double quotes will be treated as a single
           *            term.
           * @return A Cursor of instances matching the search terms in the given
           *         time range
           */
          public static final Cursor query(ContentResolver cr, String[] projection,
                                           long begin, long end, String searchQuery) {
              Uri.Builder builder = CONTENT_SEARCH_URI.buildUpon();
              ContentUris.appendId(builder, begin);
              ContentUris.appendId(builder, end);
              builder = builder.appendPath(searchQuery);
              return cr.query(builder.build(), projection, WHERE_CALENDARS_SELECTED,
                      WHERE_CALENDARS_ARGS, DEFAULT_SORT_ORDER);
          }
  
          /**
           * The content:// style URL for querying an instance range. The begin
           * and end of the range to query should be added as path segments if
           * this is used directly.
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY +
                  "/instances/when");
          /**
           * The content:// style URL for querying an instance range by Julian
           * Day. The start and end day should be added as path segments if this
           * is used directly.
           */
          public static final Uri CONTENT_BY_DAY_URI =
              Uri.parse("content://" + AUTHORITY + "/instances/whenbyday");
          /**
           * The content:// style URL for querying an instance range with a search
           * term. The begin, end, and search string should be appended as path
           * segments if this is used directly.
           */
          public static final Uri CONTENT_SEARCH_URI = Uri.parse("content://" + AUTHORITY +
                  "/instances/search");
          /**
           * The content:// style URL for querying an instance range with a search
           * term. The start day, end day, and search string should be appended as
           * path segments if this is used directly.
           */
          public static final Uri CONTENT_SEARCH_BY_DAY_URI =
              Uri.parse("content://" + AUTHORITY + "/instances/searchbyday");
  
          /**
           * The content:// style URL for querying an instance range in the managed profile.
           * It supports similar semantics as {@link #CONTENT_URI}.
           *
           * <p>The following columns plus the columns that are allowed by
           * {@link Events#ENTERPRISE_CONTENT_URI} are allowed to be queried via this uri:
           * <ul>
           * <li>{@link #_ID}</li>
           * <li>{@link #EVENT_ID}</li>
           * <li>{@link #BEGIN}</li>
           * <li>{@link #END}</li>
           * <li>{@link #START_DAY}</li>
           * <li>{@link #END_DAY}</li>
           * <li>{@link #START_MINUTE}</li>
           * <li>{@link #END_MINUTE}</li>
           * </ul>
           *
           * <p>{@link IllegalArgumentException} is thrown if there exists columns in the
           * projection of the query to this uri that are not contained in the above list.
           *
           * <p>This uri returns an empty cursor if the calling user is not a parent profile
           * of a managed profile, or the managed profile is disabled, or cross-profile calendar is
           * disabled in Settings, or this uri is queried from a package that is not allowed by
           * the profile owner of the managed profile via
           * {@link DevicePolicyManager#setCrossProfileCalendarPackages(ComponentName, Set)}.
           *
           * @see DevicePolicyManager#getCrossProfileCalendarPackages(ComponentName)
           * @see Settings.Secure#CROSS_PROFILE_CALENDAR_ENABLED
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/instances/when");
  
          /**
           * The content:// style URL for querying an instance range by Julian
           * Day in the managed profile. It supports similar semantics as {@link #CONTENT_BY_DAY_URI}
           * and performs similar checks as {@link #ENTERPRISE_CONTENT_URI}.
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_BY_DAY_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/instances/whenbyday");
  
          /**
           * The content:// style URL for querying an instance range with a search
           * term in the managed profile. It supports similar semantics as {@link #CONTENT_SEARCH_URI}
           * and performs similar checks as {@link #ENTERPRISE_CONTENT_URI}.
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_SEARCH_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/instances/search");
  
          /**
           * The content:// style URL for querying an instance range with a search
           * term in the managed profile. It supports similar semantics as
           * {@link #CONTENT_SEARCH_BY_DAY_URI} and performs similar checks as
           * {@link #ENTERPRISE_CONTENT_URI}.
           */
          @NonNull
          public static final Uri ENTERPRISE_CONTENT_SEARCH_BY_DAY_URI =
                  Uri.parse("content://" + AUTHORITY + "/enterprise/instances/searchbyday");
  
          /**
           * The default sort order for this table.
           */
          private static final String DEFAULT_SORT_ORDER = "begin ASC";
  
          /**
           * The beginning time of the instance, in UTC milliseconds. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String BEGIN = "begin";
  
          /**
           * The ending time of the instance, in UTC milliseconds. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String END = "end";
  
          /**
           * The _id of the event for this instance. Column name.
           * <P>Type: INTEGER (long, foreign key to the Events table)</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The Julian start day of the instance, relative to the local time
           * zone. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String START_DAY = "startDay";
  
          /**
           * The Julian end day of the instance, relative to the local time
           * zone. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String END_DAY = "endDay";
  
          /**
           * The start minute of the instance measured from midnight in the
           * local time zone. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String START_MINUTE = "startMinute";
  
          /**
           * The end minute of the instance measured from midnight in the
           * local time zone. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String END_MINUTE = "endMinute";
      }
  
      protected interface CalendarCacheColumns {
          /**
           * The key for the setting. Keys are defined in {@link CalendarCache}.
           */
          public static final String KEY = "key";
  
          /**
           * The value of the given setting.
           */
          public static final String VALUE = "value";
      }
  
      /**
       * CalendarCache stores some settings for calendar including the current
       * time zone for the instances. These settings are stored using a key/value
       * scheme. A {@link #KEY} must be specified when updating these values.
       */
      public static final class CalendarCache implements CalendarCacheColumns {
          /**
           * The URI to use for retrieving the properties from the Calendar db.
           */
          public static final Uri URI =
                  Uri.parse("content://" + AUTHORITY + "/properties");
  
          /**
           * This utility class cannot be instantiated
           */
          private CalendarCache() {}
  
          /**
           * They key for updating the use of auto/home time zones in Calendar.
           * Valid values are {@link #TIMEZONE_TYPE_AUTO} or
           * {@link #TIMEZONE_TYPE_HOME}.
           */
          public static final String KEY_TIMEZONE_TYPE = "timezoneType";
  
          /**
           * The key for updating the time zone used by the provider when it
           * generates the instances table. This should only be written if the
           * type is set to {@link #TIMEZONE_TYPE_HOME}. A valid time zone id
           * should be written to this field.
           */
          public static final String KEY_TIMEZONE_INSTANCES = "timezoneInstances";
  
          /**
           * The key for reading the last time zone set by the user. This should
           * only be read by apps and it will be automatically updated whenever
           * {@link #KEY_TIMEZONE_INSTANCES} is updated with
           * {@link #TIMEZONE_TYPE_HOME} set.
           */
          public static final String KEY_TIMEZONE_INSTANCES_PREVIOUS = "timezoneInstancesPrevious";
  
          /**
           * The value to write to {@link #KEY_TIMEZONE_TYPE} if the provider
           * should stay in sync with the device's time zone.
           */
          public static final String TIMEZONE_TYPE_AUTO = "auto";
  
          /**
           * The value to write to {@link #KEY_TIMEZONE_TYPE} if the provider
           * should use a fixed time zone set by the user.
           */
          public static final String TIMEZONE_TYPE_HOME = "home";
      }
  
      /**
       * A few Calendar globals are needed in the CalendarProvider for expanding
       * the Instances table and these are all stored in the first (and only) row
       * of the CalendarMetaData table.
       *
       * @hide
       */
      protected interface CalendarMetaDataColumns {
          /**
           * The local timezone that was used for precomputing the fields
           * in the Instances table.
           */
          public static final String LOCAL_TIMEZONE = "localTimezone";
  
          /**
           * The minimum time used in expanding the Instances table,
           * in UTC milliseconds.
           * <P>Type: INTEGER</P>
           */
          public static final String MIN_INSTANCE = "minInstance";
  
          /**
           * The maximum time used in expanding the Instances table,
           * in UTC milliseconds.
           * <P>Type: INTEGER</P>
           */
          public static final String MAX_INSTANCE = "maxInstance";
  
          /**
           * The minimum Julian day in the EventDays table.
           * <P>Type: INTEGER</P>
           */
          public static final String MIN_EVENTDAYS = "minEventDays";
  
          /**
           * The maximum Julian day in the EventDays table.
           * <P>Type: INTEGER</P>
           */
          public static final String MAX_EVENTDAYS = "maxEventDays";
      }
  
      /**
       * @hide
       */
      public static final class CalendarMetaData implements CalendarMetaDataColumns, BaseColumns {
  
          /**
           * This utility class cannot be instantiated
           */
          private CalendarMetaData() {}
      }
  
      protected interface EventDaysColumns {
          /**
           * The Julian starting day number. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String STARTDAY = "startDay";
          /**
           * The Julian ending day number. Column name.
           * <P>Type: INTEGER (int)</P>
           */
          public static final String ENDDAY = "endDay";
  
      }
  
      /**
       * Fields and helpers for querying for a list of days that contain events.
       */
      public static final class EventDays implements EventDaysColumns {
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY
                  + "/instances/groupbyday");
          private static final String SELECTION = "selected=1";
  
          /**
           * This utility class cannot be instantiated
           */
          private EventDays() {}
  
          /**
           * Retrieves the days with events for the Julian days starting at
           * "startDay" for "numDays". It returns a cursor containing startday and
           * endday representing the max range of days for all events beginning on
           * each startday.This is a blocking function and should not be done on
           * the UI thread.
           *
           * @param cr the ContentResolver
           * @param startDay the first Julian day in the range
           * @param numDays the number of days to load (must be at least 1)
           * @param projection the columns to return in the cursor
           * @return a database cursor containing a list of start and end days for
           *         events
           */
          public static final Cursor query(ContentResolver cr, int startDay, int numDays,
                  String[] projection) {
              if (numDays < 1) {
                  return null;
              }
              int endDay = startDay + numDays - 1;
              Uri.Builder builder = CONTENT_URI.buildUpon();
              ContentUris.appendId(builder, startDay);
              ContentUris.appendId(builder, endDay);
              return cr.query(builder.build(), projection, SELECTION,
                      null /* selection args */, STARTDAY);
          }
      }
  
      protected interface RemindersColumns {
          /**
           * The event the reminder belongs to. Column name.
           * <P>Type: INTEGER (foreign key to the Events table)</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The minutes prior to the event that the alarm should ring.  -1
           * specifies that we should use the default value for the system.
           * Column name.
           * <P>Type: INTEGER</P>
           */
          public static final String MINUTES = "minutes";
  
          /**
           * Passing this as a minutes value will use the default reminder
           * minutes.
           */
          public static final int MINUTES_DEFAULT = -1;
  
          /**
           * The alarm method, as set on the server. {@link #METHOD_DEFAULT},
           * {@link #METHOD_ALERT}, {@link #METHOD_EMAIL}, {@link #METHOD_SMS} and
           * {@link #METHOD_ALARM} are possible values; the device will only
           * process {@link #METHOD_DEFAULT} and {@link #METHOD_ALERT} reminders
           * (the other types are simply stored so we can send the same reminder
           * info back to the server when we make changes).
           */
          public static final String METHOD = "method";
  
          public static final int METHOD_DEFAULT = 0;
          public static final int METHOD_ALERT = 1;
          public static final int METHOD_EMAIL = 2;
          public static final int METHOD_SMS = 3;
          public static final int METHOD_ALARM = 4;
      }
  
      /**
       * Fields and helpers for accessing reminders for an event. Each row of this
       * table represents a single reminder for an event. Calling
       * {@link #query(ContentResolver, long, String[])} will return a list of reminders for
       * the event with the given eventId. Both apps and sync adapters may write
       * to this table. There are three writable fields and all of them must be
       * included when inserting a new reminder. They are:
       * <ul>
       * <li>{@link #EVENT_ID}</li>
       * <li>{@link #MINUTES}</li>
       * <li>{@link #METHOD}</li>
       * </ul>
       */
      public static final class Reminders implements BaseColumns, RemindersColumns, EventsColumns {
          private static final String REMINDERS_WHERE = CalendarContract.Reminders.EVENT_ID + "=?";
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/reminders");
  
          /**
           * This utility class cannot be instantiated
           */
          private Reminders() {}
  
          /**
           * Queries all reminders associated with the given event. This is a
           * blocking call and should not be done on the UI thread.
           *
           * @param cr The content resolver to use for the query
           * @param eventId The id of the event to retrieve reminders for
           * @param projection the columns to return in the cursor
           * @return A Cursor containing all reminders for the event
           */
          public static final Cursor query(ContentResolver cr, long eventId, String[] projection) {
              String[] remArgs = {Long.toString(eventId)};
              return cr.query(CONTENT_URI, projection, REMINDERS_WHERE, remArgs /*selection args*/,
                      null /* sort order */);
          }
      }
  
      protected interface CalendarAlertsColumns {
          /**
           * The event that the alert belongs to. Column name.
           * <P>Type: INTEGER (foreign key to the Events table)</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The start time of the event, in UTC. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String BEGIN = "begin";
  
          /**
           * The end time of the event, in UTC. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String END = "end";
  
          /**
           * The alarm time of the event, in UTC. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String ALARM_TIME = "alarmTime";
  
          /**
           * The creation time of this database entry, in UTC.
           * Useful for debugging missed reminders. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String CREATION_TIME = "creationTime";
  
          /**
           * The time that the alarm broadcast was received by the Calendar app,
           * in UTC. Useful for debugging missed reminders. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String RECEIVED_TIME = "receivedTime";
  
          /**
           * The time that the notification was created by the Calendar app,
           * in UTC. Useful for debugging missed reminders. Column name.
           * <P>Type: INTEGER (long; millis since epoch)</P>
           */
          public static final String NOTIFY_TIME = "notifyTime";
  
          /**
           * The state of this alert. It starts out as {@link #STATE_SCHEDULED}, then
           * when the alarm goes off, it changes to {@link #STATE_FIRED}, and then when
           * the user dismisses the alarm it changes to {@link #STATE_DISMISSED}. Column
           * name.
           * <P>Type: INTEGER</P>
           */
          public static final String STATE = "state";
  
          /**
           * An alert begins in this state when it is first created.
           */
          public static final int STATE_SCHEDULED = 0;
          /**
           * After a notification for an alert has been created it should be
           * updated to fired.
           */
          public static final int STATE_FIRED = 1;
          /**
           * Once the user has dismissed the notification the alert's state should
           * be set to dismissed so it is not fired again.
           */
          public static final int STATE_DISMISSED = 2;
  
          /**
           * The number of minutes that this alarm precedes the start time. Column
           * name.
           * <P>Type: INTEGER</P>
           */
          public static final String MINUTES = "minutes";
  
          /**
           * The default sort order for this alerts queries
           */
          public static final String DEFAULT_SORT_ORDER = "begin ASC,title ASC";
      }
  
      /**
       * Fields and helpers for accessing calendar alerts information. These
       * fields are for tracking which alerts have been fired. Scheduled alarms
       * will generate an intent using {@link #ACTION_EVENT_REMINDER}. Apps that
       * receive this action may update the {@link #STATE} for the reminder when
       * they have finished handling it. Apps that have their notifications
       * disabled should not modify the table to ensure that they do not conflict
       * with another app that is generating a notification. In general, apps
       * should not need to write to this table directly except to update the
       * state of a reminder.
       */
      public static final class CalendarAlerts implements BaseColumns,
              CalendarAlertsColumns, EventsColumns, CalendarColumns {
  
          /**
           * @hide
           */
          public static final String TABLE_NAME = "CalendarAlerts";
          /**
           * The Uri for querying calendar alert information
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY +
                  "/calendar_alerts");
  
          /**
           * This utility class cannot be instantiated
           */
          private CalendarAlerts() {}
  
          private static final String WHERE_ALARM_EXISTS = EVENT_ID + "=?"
                  + " AND " + BEGIN + "=?"
                  + " AND " + ALARM_TIME + "=?";
  
          private static final String WHERE_FINDNEXTALARMTIME = ALARM_TIME + ">=?";
          private static final String SORT_ORDER_ALARMTIME_ASC = ALARM_TIME + " ASC";
  
          private static final String WHERE_RESCHEDULE_MISSED_ALARMS = STATE + "=" + STATE_SCHEDULED
                  + " AND " + ALARM_TIME + "<?"
                  + " AND " + ALARM_TIME + ">?"
                  + " AND " + END + ">=?";
  
          /**
           * This URI is for grouping the query results by event_id and begin
           * time.  This will return one result per instance of an event.  So
           * events with multiple alarms will appear just once, but multiple
           * instances of a repeating event will show up multiple times.
           */
          public static final Uri CONTENT_URI_BY_INSTANCE =
              Uri.parse("content://" + AUTHORITY + "/calendar_alerts/by_instance");
  
          private static final boolean DEBUG = false;
  
          /**
           * Helper for inserting an alarm time associated with an event TODO move
           * to Provider
           *
           * @hide
           */
          public static final Uri insert(ContentResolver cr, long eventId,
                  long begin, long end, long alarmTime, int minutes) {
              ContentValues values = new ContentValues();
              values.put(CalendarAlerts.EVENT_ID, eventId);
              values.put(CalendarAlerts.BEGIN, begin);
              values.put(CalendarAlerts.END, end);
              values.put(CalendarAlerts.ALARM_TIME, alarmTime);
              long currentTime = System.currentTimeMillis();
              values.put(CalendarAlerts.CREATION_TIME, currentTime);
              values.put(CalendarAlerts.RECEIVED_TIME, 0);
              values.put(CalendarAlerts.NOTIFY_TIME, 0);
              values.put(CalendarAlerts.STATE, STATE_SCHEDULED);
              values.put(CalendarAlerts.MINUTES, minutes);
              return cr.insert(CONTENT_URI, values);
          }
  
          /**
           * Finds the next alarm after (or equal to) the given time and returns
           * the time of that alarm or -1 if no such alarm exists. This is a
           * blocking call and should not be done on the UI thread. TODO move to
           * provider
           *
           * @param cr the ContentResolver
           * @param millis the time in UTC milliseconds
           * @return the next alarm time greater than or equal to "millis", or -1
           *         if no such alarm exists.
           * @hide
           */
          @UnsupportedAppUsage
          public static final long findNextAlarmTime(ContentResolver cr, long millis) {
              String selection = ALARM_TIME + ">=" + millis;
              // TODO: construct an explicit SQL query so that we can add
              // "LIMIT 1" to the end and get just one result.
              String[] projection = new String[] { ALARM_TIME };
              Cursor cursor = cr.query(CONTENT_URI, projection, WHERE_FINDNEXTALARMTIME,
                      (new String[] {
                          Long.toString(millis)
                      }), SORT_ORDER_ALARMTIME_ASC);
              long alarmTime = -1;
              try {
                  if (cursor != null && cursor.moveToFirst()) {
                      alarmTime = cursor.getLong(0);
                  }
              } finally {
                  if (cursor != null) {
                      cursor.close();
                  }
              }
              return alarmTime;
          }
  
          /**
           * Searches the CalendarAlerts table for alarms that should have fired
           * but have not and then reschedules them. This method can be called at
           * boot time to restore alarms that may have been lost due to a phone
           * reboot. TODO move to provider
           *
           * @param cr the ContentResolver
           * @param context the Context
           * @param manager the AlarmManager
           * @hide
           */
          @UnsupportedAppUsage
          public static final void rescheduleMissedAlarms(ContentResolver cr,
                  Context context, AlarmManager manager) {
              // Get all the alerts that have been scheduled but have not fired
              // and should have fired by now and are not too old.
              long now = System.currentTimeMillis();
              long ancient = now - DateUtils.DAY_IN_MILLIS;
              String[] projection = new String[] {
                      ALARM_TIME,
              };
  
              // TODO: construct an explicit SQL query so that we can add
              // "GROUPBY" instead of doing a sort and de-dup
              Cursor cursor = cr.query(CalendarAlerts.CONTENT_URI, projection,
                      WHERE_RESCHEDULE_MISSED_ALARMS, (new String[] {
                              Long.toString(now), Long.toString(ancient), Long.toString(now)
                      }), SORT_ORDER_ALARMTIME_ASC);
              if (cursor == null) {
                  return;
              }
  
              if (DEBUG) {
                  Log.d(TAG, "missed alarms found: " + cursor.getCount());
              }
  
              try {
                  long alarmTime = -1;
  
                  while (cursor.moveToNext()) {
                      long newAlarmTime = cursor.getLong(0);
                      if (alarmTime != newAlarmTime) {
                          if (DEBUG) {
                              Log.w(TAG, "rescheduling missed alarm. alarmTime: " + newAlarmTime);
                          }
                          scheduleAlarm(context, manager, newAlarmTime);
                          alarmTime = newAlarmTime;
                      }
                  }
              } finally {
                  cursor.close();
              }
          }
  
          /**
           * Schedules an alarm intent with the system AlarmManager that will
           * notify listeners when a reminder should be fired. The provider will
           * keep scheduled reminders up to date but apps may use this to
           * implement snooze functionality without modifying the reminders table.
           * Scheduled alarms will generate an intent using
           * {@link #ACTION_EVENT_REMINDER}. TODO Move to provider
           *
           * @param context A context for referencing system resources
           * @param manager The AlarmManager to use or null
           * @param alarmTime The time to fire the intent in UTC millis since
           *            epoch
           * @hide
           */
          @UnsupportedAppUsage
          public static void scheduleAlarm(Context context, AlarmManager manager, long alarmTime) {
              if (DEBUG) {
                  Time time = new Time();
                  time.set(alarmTime);
                  String schedTime = time.format(" %a, %b %d, %Y %I:%M%P");
                  Log.d(TAG, "Schedule alarm at " + alarmTime + " " + schedTime);
              }
  
              if (manager == null) {
                  manager = (AlarmManager) context.getSystemService(Context.ALARM_SERVICE);
              }
  
              Intent intent = new Intent(ACTION_EVENT_REMINDER);
              intent.setData(ContentUris.withAppendedId(CalendarContract.CONTENT_URI, alarmTime));
              intent.putExtra(ALARM_TIME, alarmTime);
              intent.setFlags(Intent.FLAG_RECEIVER_INCLUDE_BACKGROUND);
              PendingIntent pi = PendingIntent.getBroadcast(context, 0, intent, 0);
              manager.setExactAndAllowWhileIdle(AlarmManager.RTC_WAKEUP, alarmTime, pi);
          }
  
          /**
           * Searches for an entry in the CalendarAlerts table that matches the
           * given event id, begin time and alarm time. If one is found then this
           * alarm already exists and this method returns true. TODO Move to
           * provider
           *
           * @param cr the ContentResolver
           * @param eventId the event id to match
           * @param begin the start time of the event in UTC millis
           * @param alarmTime the alarm time of the event in UTC millis
           * @return true if there is already an alarm for the given event with
           *         the same start time and alarm time.
           * @hide
           */
          public static final boolean alarmExists(ContentResolver cr, long eventId,
                  long begin, long alarmTime) {
              // TODO: construct an explicit SQL query so that we can add
              // "LIMIT 1" to the end and get just one result.
              String[] projection = new String[] { ALARM_TIME };
              Cursor cursor = cr.query(CONTENT_URI, projection, WHERE_ALARM_EXISTS,
                      (new String[] {
                              Long.toString(eventId), Long.toString(begin), Long.toString(alarmTime)
                      }), null);
              boolean found = false;
              try {
                  if (cursor != null && cursor.getCount() > 0) {
                      found = true;
                  }
              } finally {
                  if (cursor != null) {
                      cursor.close();
                  }
              }
              return found;
          }
      }
  
      protected interface ColorsColumns extends SyncStateContract.Columns {
  
          /**
           * The type of color, which describes how it should be used. Valid types
           * are {@link #TYPE_CALENDAR} and {@link #TYPE_EVENT}. Column name.
           * <P>
           * Type: INTEGER (NOT NULL)
           * </P>
           */
          public static final String COLOR_TYPE = "color_type";
  
          /**
           * This indicateds a color that can be used for calendars.
           */
          public static final int TYPE_CALENDAR = 0;
          /**
           * This indicates a color that can be used for events.
           */
          public static final int TYPE_EVENT = 1;
  
          /**
           * The key used to reference this color. This can be any non-empty
           * string, but must be unique for a given {@link #ACCOUNT_TYPE} and
           * {@link #ACCOUNT_NAME}. Column name.
           * <P>
           * Type: TEXT
           * </P>
           */
          public static final String COLOR_KEY = "color_index";
  
          /**
           * The color as an 8-bit ARGB integer value. Colors should specify alpha
           * as fully opaque (eg 0xFF993322) as the alpha may be ignored or
           * modified for display. It is reccomended that colors be usable with
           * light (near white) text. Apps should not depend on that assumption,
           * however. Column name.
           * <P>
           * Type: INTEGER (NOT NULL)
           * </P>
           */
          public static final String COLOR = "color";
  
      }
  
      /**
       * Fields for accessing colors available for a given account. Colors are
       * referenced by {@link #COLOR_KEY} which must be unique for a given
       * account name/type. These values can only be updated by the sync
       * adapter. Only {@link #COLOR} may be updated after the initial insert. In
       * addition, a row can only be deleted once all references to that color
       * have been removed from the {@link Calendars} or {@link Events} tables.
       */
      public static final class Colors implements ColorsColumns {
          /**
           * @hide
           */
          public static final String TABLE_NAME = "Colors";
          /**
           * The Uri for querying color information
           */
          @SuppressWarnings("hiding")
          public static final Uri CONTENT_URI = Uri.parse("content://" + AUTHORITY + "/colors");
  
          /**
           * This utility class cannot be instantiated
           */
          private Colors() {
          }
      }
  
      protected interface ExtendedPropertiesColumns {
          /**
           * The event the extended property belongs to. Column name.
           * <P>Type: INTEGER (foreign key to the Events table)</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The name of the extended property.  This is a uri of the form
           * {scheme}#{local-name} convention. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String NAME = "name";
  
          /**
           * The value of the extended property. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String VALUE = "value";
      }
  
      /**
       * Fields for accessing the Extended Properties. This is a generic set of
       * name/value pairs for use by sync adapters to add extra
       * information to events. There are three writable columns and all three
       * must be present when inserting a new value. They are:
       * <ul>
       * <li>{@link #EVENT_ID}</li>
       * <li>{@link #NAME}</li>
       * <li>{@link #VALUE}</li>
       * </ul>
       */
     public static final class ExtendedProperties implements BaseColumns,
              ExtendedPropertiesColumns, EventsColumns {
          public static final Uri CONTENT_URI =
                  Uri.parse("content://" + AUTHORITY + "/extendedproperties");
  
          /**
           * This utility class cannot be instantiated
           */
          private ExtendedProperties() {}
  
          // TODO: fill out this class when we actually start utilizing extendedproperties
          // in the calendar application.
     }
  
      /**
       * A table provided for sync adapters to use for storing private sync state data.
       *
       * @see SyncStateContract
       */
      public static final class SyncState implements SyncStateContract.Columns {
          /**
           * This utility class cannot be instantiated
           */
          private SyncState() {}
  
          private static final String CONTENT_DIRECTORY =
                  SyncStateContract.Constants.CONTENT_DIRECTORY;
  
          /**
           * The content:// style URI for this table
           */
          public static final Uri CONTENT_URI =
                  Uri.withAppendedPath(CalendarContract.CONTENT_URI, CONTENT_DIRECTORY);
      }
  
      /**
       * Columns from the EventsRawTimes table
       *
       * @hide
       */
      protected interface EventsRawTimesColumns {
          /**
           * The corresponding event id. Column name.
           * <P>Type: INTEGER (long)</P>
           */
          public static final String EVENT_ID = "event_id";
  
          /**
           * The RFC2445 compliant time the event starts. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String DTSTART_2445 = "dtstart2445";
  
          /**
           * The RFC2445 compliant time the event ends. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String DTEND_2445 = "dtend2445";
  
          /**
           * The RFC2445 compliant original instance time of the recurring event
           * for which this event is an exception. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String ORIGINAL_INSTANCE_TIME_2445 = "originalInstanceTime2445";
  
          /**
           * The RFC2445 compliant last date this event repeats on, or NULL if it
           * never ends. Column name.
           * <P>Type: TEXT</P>
           */
          public static final String LAST_DATE_2445 = "lastDate2445";
      }
  
      /**
       * @hide
       */
      public static final class EventsRawTimes implements BaseColumns, EventsRawTimesColumns {
  
          /**
           * This utility class cannot be instantiated
           */
          private EventsRawTimes() {}
      }
  }
  