Class com.ustadmobile.lib.rest.domain.report.query.RunReportRouteIntegrationTest

1

tests

0

failures

0

ignored

0.167s

duration

100%

successful

Tests

Test Duration Result
givenReportExists_whenGetReportClientRuns_thenRetrieves 0.167s passed

Standard error

Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] database build complete
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode, Site
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SyncNode
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Site
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  - start readOnly=false
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : creating SQLite change triggers 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT INTO UserSession (usUid, usPcsn, usLcsn, usLcb, usLct, usPersonUid, usClientNodeId, usStartTime, usEndTime, usStatus, usReason, usAuth, usSessionType) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : SQLite Change Tracker: Changed tables=[UserSession]
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #1 : end transaction #1
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: UserSession
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  - start readOnly=false
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : creating SQLite change triggers 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT OR REPLACE INTO SystemPermission (spUid, spToPersonUid, spToGroupUid, spPermissionsFlag, spLastModified, spIsDeleted) VALUES(?, ?, ?, ?, ?, ?)"
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : SQLite Change Tracker: Changed tables=[SystemPermission]
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #2 : end transaction #2
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: SystemPermission
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "INSERT  OR IGNORE INTO StatementEntity (statementIdHi, statementIdLo, statementActorPersonUid, statementVerbUid, statementObjectType, statementObjectUid1, statementObjectUid2, statementActorUid, authorityActorUid, teamUid, resultCompletion, resultSuccess, resultScoreScaled, resultScoreRaw, resultScoreMin, resultScoreMax, resultDuration, resultResponse, timestamp, stored, contextRegistrationHi, contextRegistrationLo, contextRegistrationHash, contextPlatform, contextStatementRefIdHi, contextStatementRefIdLo, contextInstructorActorUid, statementLct, extensionProgress, completionOrProgress, statementContentEntryUid, statementLearnerGroupUid, statementClazzUid, statementCbUid, statementDoorNode, isSubStatement) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[StatementEntity]
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #3 : end transaction #3
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: StatementEntity
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: Report
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] : created tables
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
INFO: [INFO] DoorLog - [DatabaseBuilder.build - jdbc:sqlite::memory:] database build complete
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1  - start readOnly=true
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "
        SELECT ReportQueryResult.*
          FROM ReportQueryResult
         WHERE ReportQueryResult.rqrReportUid = ? 
           AND ReportQueryResult.rqrTimeZone = ?
    "
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #1 : end transaction #1
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2  - start readOnly=true
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #2 : end transaction #2
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4  - start readOnly=true
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #4 : end transaction #4
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] DoorLog - NodeIdAndAuthCache: New Node connected: 43 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  - start readOnly=false
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #5 : end transaction #5
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: DoorNode
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] NodeIdAuthCache$verify - NodeIdAndAuthCache: Fire new node event to 0 listeners
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6  - start readOnly=true
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #6 : end transaction #6
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7  - start readOnly=true
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - prepare "SELECT * FROM Report WHERE reportUid = ?"
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #7 : end transaction #7
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  - start readOnly=false
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] creating SQLite triggers
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 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 10, 2025 11:34:22 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 10, 2025 11:34:22 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 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite:build/tmp/UmAppDatabase.sqlite] - useNewConnectionAsyncInternal connection #8 : end transaction #8
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3  - start readOnly=false
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : creating SQLite change triggers 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] creating SQLite triggers
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [prepareAndUseStatementAsync - jdbc:sqlite::memory:] - prepare "
        DELETE FROM ReportQueryResult
         WHERE rqrReportUid = ?
           AND rqrTimeZone = ?
    "
Jun 10, 2025 11:34:22 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 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINE: [DEBUG] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : SQLite Change Tracker: Changed tables=[ReportQueryResult]
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [NodeEventJdbcImplListenerSqlite - jdbc:sqlite::memory:] found 0 new events = 
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3  committed changes
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - [RoomJdbcImplHelper - jdbc:sqlite::memory:] - useNewConnectionAsyncInternal connection #3 : end transaction #3
Jun 10, 2025 11:34:22 AM io.github.aakira.napier.DebugAntilog performLog
FINEST: [VERBOSE] DoorLog - InvalidationTracker: tables invalidated: ReportQueryResult