Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I am aware that this is an old post, but I found inspiration for optimizing the solution found in the answer given by Akash Takkar if anyone is in need of a solution in the near future.</p> <h2><strong>The issues</strong></h2> <hr> <p>Specically, I found a few issues in the original code:</p> <ol> <li>The loop for retrieving calendar events broke immaturely <ul> <li>Hereby, only events from the first calendar was retrieved</li> </ul></li> <li>The first event in each calendar was skipped by using eventCursor.moveToFirst(); which thereafter moves directly to the next event in the while loop</li> <li>The id of the calendars were not set correctly in the eventCursor <ul> <li>"Calendars._id=" + 1, should be "Calendars._id=" + id,</li> </ul></li> <li>It would be difficult for others to specify their own time range</li> <li>The current solution is not object oriented which would hold many advantages</li> <li>The readability and documentation is not the best</li> </ol> <h2><strong>The solution</strong></h2> <hr> <p>I have hereby created a Github Library which returns a list of event objects in a specified time range which can be found at:</p> <p><a href="https://github.com/david-laundav/CalendarService">https://github.com/david-laundav/CalendarService</a></p> <p>The source files can be found under "CalendarService/src/dk/CalendarService".</p> <p><strong>Use cases</strong></p> <p>The solution itself contains two different methods for different purposes.</p> <p><strong>First use case:</strong></p> <pre><code>CalendarService.readCalendar(class.this) // where class.this is either your class or the context </code></pre> <p>This method will return a list of events for +/- 1 day</p> <p><strong>Second use case:</strong></p> <p>You can also specify your own time range:</p> <pre><code>CalendarService.readCalendar(class.this, int days, int hours) </code></pre> <p>An example might be:</p> <pre><code>CalendarService.readCalendar(class.this, 2, 5) </code></pre> <p>In doing so will return a list of events from +/-2 days and +/- 5 hours.</p> <p>The service has been tested, but please tell me if you experience any issues.</p>
    singulars
    1. This table or related slice is empty.
    1. POGetting events from calendar
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDemitrian
    1. USDemitrian
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis code does not work for ICS 4.1.2 (at least on Galaxy Note GT-N7000)
      singulars
      1. PO
      1. USManish
    2. COIt has been tested by others on ICS 4.2 which worked succesfully. Have you had a look at "CalendarService.java" on line 59?: Use the cursor below for Android API 4.0+ (Thanks to SLEEPLisNight)
      singulars
      1. PO
      1. USDemitrian
    3. COCould any one please tell me how to get the google calendar events in android.I can get only the Android calendar events only not google calendar events.
      singulars
      1. PO
      1. USuser2841300
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload