Skip to main content

Accessing sqlite database in the command prompt

Many a times working with sqlite database, you often wonder if the tables are created, whether they are populated etc. If you want to find out the contents of the database, here are the steps needed
  •  Start running your application using emulator or device
  • Open command prompt. Run->cmd->click on cmd
  • Give command adb shell
    • If adb gives unknown command error, you can go to the folder <your androidsdk location>/platform-tools and then try giving the adb shell command.
  • Change to directory /data/data using cd /data/data
  • Now go to directory of your application package. e.g. if package name is com.example.dbtest, give the command cd com.example.dbtest 
  • Change to databases directory. cd databases
  • Open the database using sqlite3 command. If your database name is example, use the command sqlite3 example
  • Sqlite will start. Some basic commands you can use are
      • .quit - come out of sqlite
      • .table - list the tables
      • .schema tablename - list the columns of the table
      • any sql command - do not forget to add ; at the end of command
 
Labels:

Comments

Post a Comment

Popular posts from this blog

Copy to clipboard

In my upcoming app, I have codes which I display. These are some times lengthy, and I want the app to be able to copy this to clipboard. Once it is in clipboard, users can paste it anywhere. So how do you copy some text from your app to clipboard. You need to use clipboard manager. Clipboard Manager This class sets and gets data for the clipboard using Clipdata objects.  You can get the object of this class using system service.  - using statement context.getSystemService(Context.CLIPBOARD_SERVICE) Example I have a dummy project with a button, onclick of which copies content to clipboard. Here is my activity file package com . hegdeapps . testapp ; import android.content.ClipData ; import android.content.ClipboardManager ; import android.support.v7.app.AppCompatActivity ; import android.os.Bundle ; import android.view.View ; import android.widget.Button ; import android.widget.TextView ; public class MainActivity extends ...
Post a Comment
Read more

Drawables in Android - Layer drawable

Let us see how to use layer drawable. You can have two or more bitmaps on different layers to create such a drawable Using xml : You should use layer-list in your xml file to create layerdrawable. Here is layer.xml <?xml version="1.0" encoding="utf-8"?> <layer-list xmlns:android="http://schemas.android.com/apk/res/android"> <item> <bitmap android:src="@drawable/whiteicon" android:gravity="top|left"/> </item> <item> <bitmap android:src="@drawable/blueicon" android:gravity="top|left"/> </item> <item> <bitmap android:src="@drawable/redicon" android:gravity="top|left"/> </item> </layer-list> We are using three different bitmaps whiteicon.png, redicon.png and blueicon.png which are present in /res/drawable/mdpi folder. All these are of different sizes and aligned to top left. Thi...
1 comment
Read more

Ratings and feedbacks

Once your android project is at the finishing stage, you need to add the following extra features to your app. Rate the app Because rates drive app download Other apps by you free advertisement for your apps Send feedback you need them to remove bugs and improve the app Well, I personally feel that the pop up screens which ask the user to rate the app, is not a good idea. People may get irritated by this. But to provide the first one, you need to know the playstore page of your app. How do you get the page if you have not yet published the page? Well, the app page always looks like this https://play.google.com/store/apps/details?id =your_app_package_name    the last part is your package name of the app. And to take the user to all apps by you, you need to use a url like this https://play.google.com/store/apps/developer?id=yourdevelopername  So these two settled, let us write our xml and code <?xml version="1.0" encoding="utf-8...
Post a Comment
Read more