ide/androidstudio

android SQLite DB 열기

C/H 2017. 1. 17. 08:30

Pull

adb pull /data/data/com.android.test/databases/testdb.db ~/.

Pull 권한이 안된다면

adb shell
$ run-as com.domain.package
$ chmod 777 databases
$ chmod 777 databases/databse_name

Shell

adb shell
sqlite3 /data/data/com.domain.test/databases/testdb.db
SQLite version 3.x.xx yyyy-mm-dd H:i:s
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
testdb            android_metadata

sqlite> .schema testdb

sqlite> .schema testdb

sqlite> .exit

root@android:/ # exit

Select Device Shell

$adb devices
List of devices attached
G1AXB70596xx	device

$ adb -s G1AXB70596xx shell

SQLScout

라이선스가 필요하다.


반응형

'ide > androidstudio' 카테고리의 다른 글

Android Swipe  (0) 2017.01.19
Android Drawable Shape Syntax  (0) 2017.01.18
Circle TextView  (0) 2017.01.16
orma "transformClasses With New Class Shrinker For Debug"  (0) 2017.01.12
Android ORM  (0) 2017.01.11