A little background. I've had an app with a database that's worked fine for a few years. I added new options, including DELETE DATABASE, with this line of code:
No error. But now I get exceptions where I try to re-load or create a new database. I wondered if there was a possibly-corrupted database on the emulator or if a file with the name I was using was present but with 0 size, somehow. I needed to see it in a directory listing. Never seen one before.
Using adb at the DOS command prompt, I (finally; long time spent) found command syntax to show the files. Here's the command:
C:\Users\Dov>adb ls /data/data/com.dslomer64.servyhelperton/databases
Here's the output.
000041f9 00001000 59b7bc7d . 000041e9 00001000 59b5a17d .. 000081b0 00005000 59b72501 Dictionary.dic 00008180 00002210 59b72501 Dictionary.dic-journal 000081b0 00005000 59b6e3c3 TEST2.dic 00008180 00002210 59b6e3c3 TEST2.dic-journal 000081b0 00005000 59b710c8 TEST.dic 00008180 00002210 59b710c8 TEST.dic-journal
YAY. But what are the columns of numbers? Size? Mod/create date?
(I think the two less-urgent questions below just require YES/NO answers.) (I would hate to start a new Question for either.)
Just to see what I'd get, I asked for
ls of the database itself:
C:\Users\Dov>adb ls /data/data/com.dslomer64.servyhelperton/databases/Dictionary.dic C:\Users\Dov>
Got no error. Got nothing. Did anything hidden happen?
pulled TEST.dic and opened it with Notepad. Not text.
But assuming what I
pulled is a valid SQLite database, could an app read it?