1,234
edits
Changes
→Using a pre-built DB file
catch (IOException e) { e.printStackTrace(); }
dbOpenHelper = new DatabaseOpenHelper(context); /** * This function comes from the database example in the book. I've no idea * why it's necessary, does Android really not have a function that does this? */public void copyFile(InputStream inputStream, OutputStream outputStream) throws IOException{ byte[] buffer = new byte[1024]; int length; while ((length = inputStream.read(buffer)) > 0) outputStream.write(buffer, 0, length); inputStream.close(); outputStream.close();}</source>
Make sure this code runs when your app starts up and don't forget to put your db file in the assets folder.
You can download the [https://github.com/TKlerx/android-sqlite-browser-for-eclipse/releases Questoid SQLite Browser] plugin for Android Device Monitor to be able to view your SQLite database directly from the device.
Copy the file to your [YourAndroidSdkDirectory]/tools/lib/monitor-x86_64/plugins/AndroidSQLiteBrowser_1.0.1.jar directory and restart the Android Device Monitor.
Then you can find your database file and click the "Open File in SQLite browser" button:
[[Image:QuestoidSQLitemanager.png|600px| ]]