SQlite – enable log events and see it in logcat

Create .bat file with commands provided below:

adb shell setprop log.tag.SQLiteLog V
adb shell setprop log.tag.SQLiteStatements V
adb shell su 0 stop
adb shell su 0 start

After You execute app, You (in this case) emulator will reboot.

Now search in logcat something like this below:

/data/user/0/{APP_PACKAGE_NAME}/databases/{APP_DATABASE_NAME}

TIL: awake and unlock screen when installing app is possible

Here is the link:

http://stackoverflow.com/questions/22332513/wake-and-unlock-android-phone-screen-when-compile-and-run-project

Here is the answer:

One solution: set the following flags in your activity class(es):

if (BuildConfig.DEBUG) {
// These flags cause the device screen to turn on (and bypass screen guard if possible) when launching.
// This makes it easy for developers to test the app launch without needing to turn on the device
// each time and without needing to enable the "Stay awake" option.
getWindow().addFlags(WindowManager.LayoutParams.FLAG_TURN_SCREEN_ON
| WindowManager.LayoutParams.FLAG_DISMISS_KEYGUARD
| WindowManager.LayoutParams.FLAG_SHOW_WHEN_LOCKED);
}

These flags will:

Turn on the screen
Bypass the lock-screen
Allow showing the activity even if the device is locked

By setting those flags in your base activity, you’ll be able to continue using your application even if the device was off and/or locked at the time of running. If you try to leave your application’s process (i.e., hitting the home button, or switching to another app), the lock screen will appear, and you’ll have to manually unlock to continue using the device.

Warning: this should only be used while developing/debugging your application, so I recommend keeping the if (BuildConfig.DEBUG) check, as it is in this example