How can I see what is in my smartstore soups?

Question

I'm building an android hybrid_local app that stores data in the smartstore. It seems to be inserted according to my log messages but when I query it, I don't get results back (or I get array.length = 0). So I'm assuming my query is wrong or the data wasn't inserted after all.

I'm using genymotion as an emulator and eclipse to launch the app. What do I have to use to be able to see the smartstore soups en entries in eclipse or some other software? Do I need to install an android app on my emulator?

Update

I got my code working now, don't remember how but that wasn't the question...

I did recently found out how I can find the database file. Using DDMS in eclipse I found the database file on this path "data/data/[app name]/databases/smartstore.db".

Tried opening the file with the Questoid SQLite manager in Eclipse but it gave me a "Failed to create the parts" error message.

Tried downloading the smartstore.db file and opening it with sqlite administrator or SQLite Database browser but no luck. Any idea how I need to open that file and with what program so I can read what is inside?

Answer 1

You can use SQLite client or the querySpec() method on the emulator to see your soup list and the data in those soups. As for the mentioned issue, I have seen this occur in my apps when there's a problem in the way A) you are creating your soup index B) you are retrieving data based on the wrong soup index. Tom Gersic from Model Metrics (now Salesforce) has published this open source example which shows you can see the list of soups and in turn the contents of each soup.

Also, make sure to see this PPT to understand how data is organized/ stored in soups. If you do see the soups are correctly populated, share your index definition and I'll be happy to help further.