jeudi 5 mars 2015

How to debug SQLite database from SQLite Openhelper?

Usually when I want to see the contents of a SQLite database, I use the sqlite3 executable and give it commands like:



.open MYDATABASE.db
SELECT * FROM myUserTable;


It then outputs my table via command line and it is very easy to see the contents of anything in my database.


Unfortunately, the SQLite database I am working with does not even have an associated .db file. It extends from a class called SQLiteOpenHelper. The class resides in a file called DBHandler.java, but obviously attempting to execute command line statements (i.e. as I am used to) fails in this instance.


Does anyone know how to debug a SQLite database that extends from SQLiteOpenHelper?


Aucun commentaire:

Enregistrer un commentaire