Android executes sqlite3 script via PC script

Recent research on some of the Android DB frameworks in the market requires a lot of repetitive input, such as

/data/data/com.example.testandroiddb/Databasessqlite3 demo.db
CREATE TABLE xxx;
Insert 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 push/users/corleone/desktop/db3.sql/sdcard/db3.sql
ADB Shell </USERS/CORLEONE/DESKTOP/DB2. SH

Then write in this/users/corleone/desktop/db2.sh what the Android Shell has to do:

Cd/data/data/com.example.testandroiddb/databases
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