IssueTracker

Is there any hope that this will be looked at any time soon?
I find it pretty disappointing that there is no way to debug queries. I am using Room in an application with foreign key relationships, and these are failing silently and for some mysterious reason, and I have no way to debug my queries other than manually adding a bunch of LogCat logs.
Thank you for considering this.

Hello

Room database looks very promising and interesting, But I am still on initial stage of learning it and I am facing the problem of not being able to see log outputs of the database.
While implementing / learning debugging should be enabled.

It would be extremely helpful if we can have debugging logs for Room database implementation.

Thanks and regards
Abhiroop Nandi Ray

sorry, we are not agianst this feature but it is just not a high priority right now.
You can technically implement this outside room by providing your logging support sqlite open helper.

you can also consider sending a CL ? :)
https://android.googlesource.com/platform/frameworks/support/+/androidx-master-dev

I have been able to achieve it via a very hackie way
Please refer to
https://stackoverflow.com/questions/46172417/android-room-database-dao-debug-log/53693849#53693849 
or
https://gist.github.com/aasaandinesh/6e4cf206bd1bb56966954cabc42128dd

Will try to do it in a proper way

You can log Room's Sqlite queries on emulator, see: https://stackoverflow.com/a/54963655/1233652

This is needed for asserting query execution and increasing the speed of adoption of the framework. Please prioritize higher as simple as it is.

Please, it would be very helpful for developers to be able to debug room operations in an easy way.

Please, it would be very helpful for a more complicated erd, prioritize higher as soon as possible.

Project: platform/frameworks/support
Branch: androidx-master-dev

commit ab6d205c0217a0ed5c170bf6ceadb20422947699
Author: Elif Bilgin <elifbilgin@google.com>
Date:   Tue Nov 17 13:50:26 2020

    Implementing functionality for a general callback function for SQLite queries. If possible, bind arguments are provided to the callback in addition to the SQLite query statement. This callback may be used for logging executed queries, in which case it is recommended to use an immediate executor.
   
    This CL will be followed up by a CL resolving b/174478034.
   
    Test: Tests have been added QueryInterceptorTest.kt
   
    Relnote: Add query callback feature to Room.
   
    Bug: 74877608
    Change-Id: Iaa513e39115f0c9c68359774fa70e1d3dd022c39

A       room/integration-tests/kotlintestapp/src/androidTest/java/androidx/room/integration/kotlintestapp/test/QueryInterceptorTest.kt
M       room/runtime/api/current.txt
M       room/runtime/api/public_plus_experimental_current.txt
M       room/runtime/api/restricted_current.txt
A       room/runtime/src/main/java/androidx/room/QueryInterceptorDatabase.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorOpenHelper.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorOpenHelperFactory.java
A       room/runtime/src/main/java/androidx/room/QueryInterceptorStatement.java
M       room/runtime/src/main/java/androidx/room/RoomDatabase.java

https://android-review.googlesource.com/1502194

Amazing! GPS Location command works well. Thanks)

Awesome! Thanks for trying this out. Glad it's fixing that issue :)

Project: platform/external/qemu
Branch: emu-master-dev

commit ea85adfc73d1ef1bc22b9cbbf554fa550ffde2c9
Author: Lingfeng Yang <lfy@google.com>
Date:   Sat Feb 17 17:01:56 2018

    [location] Make most location settings per-AVD
   
    bug: 73471760
    bug: 73450633
   
    Unless there is no AVD, use a per-AVD setting for
    lat/lon/alt and the playback settings.
   
    Also update the qt setting if location was updated
    from the console.
   
    Change-Id: I0268e0e7ef25db0398844c38039e9298b3a2129b

M       android/android-emu/android/console.cpp
M       android/android-emu/android/emulation/control/location_agent.h
M       android/android-emu/android/skin/qt/extended-pages/location-page.cpp
M       android/android-emu/android/skin/qt/extended-pages/location-page.h
M       android/android-emu/android/skin/qt/qt-settings.h

https://android-review.googlesource.com/620933
https://goto.google.com/android-sha1/ea85adfc73d1ef1bc22b9cbbf554fa550ffde2c9

Project: platform/external/qemu
Branch: emu-2.6-release

commit eff2175376a42c53cd032151b09439219e631fc2
Author: Lingfeng Yang <lfy@google.com>
Date:   Sat Feb 17 17:01:56 2018

    [location] Make most location settings per-AVD
   
    bug: 73471760
    bug: 73450633
   
    Unless there is no AVD, use a per-AVD setting for
    lat/lon/alt and the playback settings.
   
    Also update the qt setting if location was updated
    from the console.
   
    Change-Id: I0268e0e7ef25db0398844c38039e9298b3a2129b
    (cherry picked from commit ea85adfc73d1ef1bc22b9cbbf554fa550ffde2c9)

M       android/android-emu/android/console.cpp
M       android/android-emu/android/emulation/control/location_agent.h
M       android/android-emu/android/skin/qt/extended-pages/location-page.cpp
M       android/android-emu/android/skin/qt/extended-pages/location-page.h
M       android/android-emu/android/skin/qt/qt-settings.h

https://android-review.googlesource.com/622406
https://goto.google.com/android-sha1/eff2175376a42c53cd032151b09439219e631fc2

Hi all,

We should have this fixed and released in the next emulator canary. Details to follow.

Emulator 27.1.11 canary with the fix is live now.

Location event's elevation field is (stil?) not passed from GPS data playback - Elevation column when replaying : Android location.getAltitude() does not return an altitude on the emulator (as reported in 36939275).  On all 3 my physical devices my program is working fine - I do receive altitude.

I upgraded to Emulator 28.0.3 to see if that was fixed and the problem persists.

Emulator 28.0.3-4946491 (KVM 12.0.0), AVD configuration Nexus_7_API_26 , Android version 8.0 (Oreo)

Ok, that is weird. It is the altitude that is broken, right? That is a known issue, but the lat/lon should be fixed. Reaching out to our resident GPS expert for more info.

Yes, altitude... it is such a pain to test code containing calculations which depends on altitude changes....

For example I get values such as:
Location[fused 40.274500,-74.815100 hAcc=0 et=+18m56s627ms alt=0.0 vel=81.56 bear=37.0 vAcc=??? sAcc=??? bAcc=???]
when I am replaying a track containing real Elevations such as in the screenshot.

In my tests I see the altitude set correctly.

I'm testing 28.0.3-4946491 as in #18. I used a third-party app to display the GPS location and altitude, and I see latitude, longitude, and altitude all updating. For me it worked both when clicking Send for a single location and when playing a KML.

FYI, I used the app "GPS Location" by Jeroen van Iddekinge, last updated Sep 2, 2017.

Could you see if this app correctly reports the altitude for you?

Are you still seeing this problem?

I believe this is working correctly now.

Please open a new bug if you are still seeing a problem.