= (SELECT MAX(?, (SELECT COALESCE( (SELECT Report.reportLastModTime FROM Report WHERE Report.reportUid = ?), 0)))) " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : end transaction #2 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 - start readOnly=true Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT auth FROM DoorNode WHERE nodeId = ? " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - NodeIdAndAuthCache: New Node connected: 43 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 - start readOnly=false Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : creating SQLite change triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO DoorNode(nodeId, auth, rel) VALUES(?, ?, ?)" Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : SQLite Change Tracker: Changed tables=[DoorNode] Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 committed changes Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: DoorNode Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] NodeIdAuthCache$verify - NodeIdAndAuthCache: Fire new node event to 0 listeners Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 - start readOnly=true Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " SELECT COUNT(*) FROM UserSession WHERE UserSession.usPersonUid = ? AND UserSession.usStatus = 1 AND UserSession.usClientNodeId = ? " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 - start readOnly=true Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Report WHERE reportUid = ?" Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 - start readOnly=false Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : creating SQLite change triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " SELECT COALESCE( (SELECT ReportQueryResult.rqrLastModified FROM ReportQueryResult WHERE ReportQueryResult.rqrReportUid = ? AND ReportQueryResult.rqrTimeZone = ? LIMIT 1), 0) >= (SELECT MAX(?, (SELECT COALESCE( (SELECT Report.reportLastModTime FROM Report WHERE Report.reportUid = ?), 0)))) " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " DELETE FROM ReportQueryResult WHERE rqrReportUid = ? AND rqrTimeZone = ? " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO ReportQueryResult(rqrReportUid, rqrLastModified, rqrReportSeriesUid, rqrLastValidated, rqrXAxis, rqrYAxis, rqrSubgroup, rqrTimeZone) WITH AllLearningRecordsPermission(hasPermission) AS ( SELECT EXISTS( SELECT 1 FROM SystemPermission WHERE SystemPermission.spToPersonUid = ? AND (SystemPermission.spPermissionsFlag & 128)) AS hasPermission ), ClazzesWithPermission(clazzUid) AS( SELECT Clazz.clazzUid AS clazzUid FROM Clazz WHERE NOT (SELECT hasPermission FROM AllLearningRecordsPermission) AND Clazz.clazzOwnerPersonUid = ? UNION SELECT CoursePermission.cpClazzUid AS clazzUid FROM CoursePermission WHERE NOT (SELECT hasPermission FROM AllLearningRecordsPermission) AND ( CoursePermission.cpToPersonUid = ? OR ((CoursePermission.cpToEnrolmentRole, CoursePermission.cpClazzUid) IN (SELECT ClazzEnrolment.clazzEnrolmentRole, ClazzEnrolment.clazzEnrolmentClazzUid FROM ClazzEnrolment WHERE ClazzEnrolment.clazzEnrolmentPersonUid = ?))) AND (CoursePermission.cpPermissionsFlag & 128) > 0 ),ResultSourceCte AS ( SELECT SUM(ResultSource.resultDuration) AS yAxis, strftime('%Y-%m-%d', (ResultSource.timestamp + 0)/1000, 'unixepoch') AS xAxis, '' AS subgroup FROM StatementEntity ResultSource WHERE ResultSource.timestamp BETWEEN ? AND ? AND ( (SELECT AllLearningRecordsPermission.hasPermission FROM AllLearningRecordsPermission) OR ResultSource.statementActorPersonUid = ? OR ResultSource.statementClazzUid IN (SELECT ClazzesWithPermission.clazzUid FROM ClazzesWithPermission) ) GROUP BY xAxis, subgroup ) SELECT ? AS rqrReportUid, ? AS rqrLastModified, ? AS rqrReportSeriesUid, ? AS rqrLastValidated, ResultSourceCte.xAxis AS rqrXAxis, ResultSourceCte.yAxis AS rqrYAxis, ResultSourceCte.subgroup AS rqrSubgroup, ? AS rqrSubgroup FROM ResultSourceCte " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare " SELECT ReportQueryResult.* FROM ReportQueryResult WHERE ReportQueryResult.rqrReportUid = ? AND ReportQueryResult.rqrTimeZone = ? " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : SQLite Change Tracker: Changed tables=[ReportQueryResult] Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 committed changes Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 - start readOnly=false Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] creating SQLite triggers Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare " DELETE FROM ReportQueryResult WHERE rqrReportUid = ? AND rqrTimeZone = ? " Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "INSERT INTO ReportQueryResult (rqrUid, rqrReportUid, rqrLastModified, rqrLastValidated, rqrReportSeriesUid, rqrXAxis, rqrYAxis, rqrSubgroup, rqrTimeZone) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)" Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[ReportQueryResult] Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] found 0 new events = Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 committed changes Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : end transaction #3 Jun 09, 2025 10:05:42 AM io.github.aakira.napier.DebugAntilog performLog FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult ]]>