Android executes sqlite3 script via PC script

Source: Internet
Author: User

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

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.