Android executes sqlite3 script via PC script

Source: Internet
Author: User
Tags db2

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

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.