Sqlite database from cmd.


Android apps or sdk comes in with a database built right into it, known commonly as sqlite.Being most widely used database for a wide range of mobile devices, its quite a task when it comes to integrating it correctly to the app.
With the apps built up for testing its quite a pinch, when one has to know weather the given data has been updated into the database.

The method for checking or updating the sqlite database from command prompt can be done with few guided steps as mentioned below.

Checking the working of database in the eclipse environment.

1)go in the ddms mode from the main menu bar.
2)from the left hand side select the required package
3)go to file explorer from the subtitle bar ::adjacent to ddms mode in the same line .
4)select data folder then sub folder named data.
5)seect the package from the subsequent layout.
6)select database

To check through command shell and do the required editing

1)cd and reach to sdk source.
2)cd and reach to sdk
3) cd and reach to platform-tools.
4)enter command ::adb shell (press enter)
5)enter command ::cd data (press enter)
6)enter command ::cd data (press enter) *2nd time
7)enter command :: ls
lists the required package.
8)enter command ::cd and <required package>.
9)enter command :: ls
10)enter command ::cd databases
11)enter command :: ls
12)enter command ::sqlite3

to exit from sqlite shell :: .exit

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s