Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>NOTE: This answer is outdated. If you are using Roboletric 2.X, please see <a href="https://stackoverflow.com/a/24578332/850787">https://stackoverflow.com/a/24578332/850787</a></h2> <p>The problem is that Robolectric's SQLiteDatabase is stored only in memory, so when you call getReadableDatabase or getWritableDatabase, the existing database will be overridden with new empty database. </p> <p>I was running to the same problem and only solution I found was that I needed to fork the Robolectric project and added ShadowSQLiteOpenHelper to save database if same context is given two times. However the problem with my fork is that I had to 'disable' close()-function when contex is given because otherwise Connection.close() will destroy the database in memory. I have made pull request for it but it isn't merged to project yet.</p> <p>But feel free to clone my version and it should fix your problem (If I understood it correctly :P ). It can be found on GitHub: <a href="https://github.com/waltsu/robolectric" rel="nofollow noreferrer">https://github.com/waltsu/robolectric</a></p> <p>Here is a example how to use the modification:</p> <pre><code>Context c = new Activity(); SQLiteOpenHelper helper = new SQLiteOpenHelper(c, "path", null, 1); SQLiteDatabase db = helper.getWritableDatabase(); // With the db write something to the database db.query(...); SQLiteOpenHelper helper2 = new SQLiteOpenHelper(c, "path", null, 1); SQLitedatabase db2 = helper2.getWritableDatabase(); // Now db and db2 is actually the same instance Cursor c = db2.query(...) ; // Fetch the data which was saved before </code></pre> <p>Ofcourse you don't need to create new SQLiteOpenHelper, but that is just example that passing same context to two different SQLiteOpenHelper will give same database.</p>
    singulars
    1. This table or related slice is empty.
    1. POTesting SQLite database in Robolectric
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USWaltsu
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTesting SQLite database in Robolectric
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODo you know how I can use this for a pre-made database? I'm also testing SQLite databases, and have run into a very similar error, but I'm utilizing a database already made.
      singulars
      1. PO
      1. USNioShobu
    2. COCouldn't you just remove the line `db = cache.getReadableDatabase();` from the OP's code so the initial reference is reused?
      singulars
      1. PO
      1. USRoger Keays
    3. CO@RogerKeays: Yes, that's correct. But I believe that the code snippet was simplified version, because otherwise it doesn't make sense to just test implementation of Robolectric's database code. I think that writing and reading happens in different places.
      singulars
      1. PO
      1. USWaltsu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload