Incremental Export to Google Calendar does not work

[canpaulboerger]

Reproducer steps

1. Record sleep 1 (overlapping to the next day)
2. Export sleep 1 to Google calendar
3. Record sleep 2 (also overlapping to the next day)
4. Export again.

Actual result
Both sleeps get exported to google calendar

Expected behavior
Only the events, which have not been exported previously, should be exported (sleep 2)

[vmiklos]

@ed-george does this work for you? I only use the file export (not the calendar export), though I believe the intention was to have this working, still.

[vmiklos]

plees-tracker/app/src/main/java/hu/vmiklos/plees_tracker/DataModel.kt

Lines 259 to 265 in cccf70c

	val calendarSleeps = CalendarImport.queryForEvents(
	context, calendarId
	).map(CalendarImport::mapEventToSleep)
	val sleeps = database.sleepDao().getAll()
	val exportedSleeps = sleeps.subtract(calendarSleeps.toSet())
	CalendarExport.exportSleep(context, calendarId, exportedSleeps.toList())

we definitely has some code here to try to do this, but then it seems this fails in practice for some reason.

[vmiklos]

Hm, and when I test it with google calendar it works. My test setup has a single sleep, first I get the snackbar that 1 sleep was exported, and if I try to do it again, the new snackbar says 0 sleeps were exported. Which calendar do you try to export to, is that some other calendar?

[canpaulboerger]

The expected behavior also works for me, when the entries are of short duration and on the same day. It seems as if the app "forgets" which entries have been exported after a longer period of time. Then the export also includes items from the previous export.
I use Google Calendar as the export destination.

[vmiklos]

I'm still confused:

plees-tracker/app/src/main/java/hu/vmiklos/plees_tracker/calendar/CalendarImport.kt

Lines 63 to 93 in cccf70c

	fun queryForEvents(
	context: Context,
	calendarId: String,
	title: String = DEFAULT_EVENT_TITLE
	): List<UserEvent> {
	val uri = Events.CONTENT_URI
	val contentResolver: ContentResolver = context.contentResolver
	// Select events with a title containing the supplied param (case insensitive)
	// and where there is a non-null start time as well as a non-null (or zero) end time
	val selection = """
	(${Events.CALENDAR_ID} = ?) AND
	(${Events.TITLE} LIKE ? COLLATE NOCASE) AND
	(${Events.DTSTART} IS NOT NULL) AND
	(${Events.DTEND} IS NOT NULL AND ${Events.DTEND} != 0)
	""".trimIndent()
	val selectionArgs = arrayOf(calendarId, "%$title%")
	contentResolver.query(
	uri,
	EVENT_PROJECTION,
	selection,
	selectionArgs,
	null
	).use { cursor ->
	// Map to UserEvent and avoid any 'all-day' events
	return cursor?.map(::UserEvent).orEmpty()
	}
	}

This is where we query the calendar events (to avoid duplicates) and we clearly don't limit the date range. Is it possible that google calendar only gives events which are cached locally and if you have a longer period with sleeps, then plees tracker has those sleeps, but google calendar does not?

If so, we would need to know where to cut off our own sleep list (so only export the sleeps where the target calendar has events). I'm not sure how to get that info from the calendar.

Maybe you know any other open-source app that exports to the calendar? I imagine e.g. a running tracker app would have the same trouble. Thanks.