Recent research on some of the Android DB frameworks in the market requires a lot of repetitive input, such as
CREATE TABLE xxx;
select * from XXX;
Very inconvenient, just want to write a script to do these repetitive work.
The main problem is to execute commands between multiple shells.
The solution is for the shell to provide the input stream function "<"
First write Sqlite3 script, named Db3.sql, content such as:
. Table Select * from Android_metadata;
Then create a new db.sh as the entry for the PC-side execution script, here to upload the db3.sqli to the phone, because SQLite reads SQL on the Android device.
ADB Shell </USERS/CORLEONE/DESKTOP/DB2. SH
Then write in this/users/corleone/desktop/db2.sh what the Android Shell has to do:
Sqlite3-echo Demo.db </sdcard/db3.sql
And then give db.sh the Execute permission.
chmod +x/users/corleone/desktop/db. SH
Then you can happily open sqlite directly, as long as the implementation of db.sh can.
Android executes sqlite3 script via PC script