更新时间:2023-02-07 10:46:45
要查询一个特定的值:
亚行的shell sqlite3的/data/data/com.android.providers.settings/databases/settings.db,从系统选择值,其中name ='volume_alarm';
或者所有记录拉从一个表:
亚行的shell sqlite3的/data/data/com.android.providers.settings/databases/settings.db中选择的名字,从系统的价值;
Android
saved settings in a database file which is /data/data/com.android.providers.settings/databases/settings.db
.
Android use sqlite3
as the database. We can use adb
to manage the database file. I want to know if there is a way to run all these commands in a perl/python
script to automate the whole query process?
$adb shell
$sqlite3 /data/data/com.android.providers.settings/databases/settings.db
The above command will open the settings database. Then you will enter into sqlite3 command line.
First check how many tables existed in the database. Here lists the result.
sqlite> .tables
android_metadata bookmarks gservices
bluetooth_devices favorites system
The settings (such as volume_alarm) I want to get are in "system" table, a .dump command will list all items in the table.
sqlite> .dump system
BEGIN TRANSACTION;
CREATE TABLE system (_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT UNIQUE ON CONFLICT REPLACE,value TEXT);
INSERT INTO "system" VALUES(3,’volume_system’,’5′);
INSERT INTO "system" VALUES(4,’volume_voice’,’4′);
INSERT INTO "system" VALUES(5,’volume_alarm’,’6′);
.....
$ select value from system where name ='volume_alarm';
select value from system where name ='volume_alarm'
6
$.quit;
To query a specific value:
adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "select value from 'system' where name = 'volume_alarm';"
Or to pull all records from a table:
adb shell sqlite3 /data/data/com.android.providers.settings/databases/settings.db "select name, value from 'system';"