示例1:执行一条sql语言
sqlite3 /data/adb/lspd/config/modules_config.db <<EOF
update modules set apk_path='$NalToolXposedPath' where mid=1;
EOF
示例2:执行多条Sql语句
sqlite3 /data/adb/lspd/config/modules_config.db <<EOF
DELETE FROM scope;
DELETE FROM sqlite_sequence WHERE name = 'scope';
EOF
示例3:结合adb shell命令
for packageString in `pm list packages`
do
packageName=${packageString: 8}
if [ "$packageName" == "android" ];then
echo "+ Skip android package"
continue
fi
sqlite3 /data/adb/lspd/config/modules_config.db <<EOF
insert into scope(mid,app_pkg_name,user_id) values('1','$packageName','0');
EOF
done
上面这段代码用于获取所有app包名,然后插入到sqlite数据库中;
小结:
Sqlite命令前后要加上 <<EOF
和EOF
,EOF
的左右不能出现空格和TAB符号