gistfile1.java

public void testNestedSQLTransactionRollback() throws Exception {

        String schema = "CREATE TABLE docs ( " +
                "        doc_id INTEGER PRIMARY KEY, " +
                "        val TEXT UNIQUE NOT NULL); ";

        LiteTestContext context = new LiteTestContext();
        String dbName = "testNestedSQLTransactionRollback" + System.currentTimeMillis();
        String path = context.getFilesDir() + File.separator + dbName + Manager.DATABASE_SUFFIX;
        SQLiteDatabase sqlDatabase = SQLiteDatabase.openDatabase(path, null, SQLiteDatabase.CREATE_IF_NECESSARY);

        // install schema
        sqlDatabase.execSQL(schema);

        // start outer transaction
        sqlDatabase.beginTransaction();

        // add a doc -- inner transaction 1: COMMITTED
        sqlDatabase.beginTransaction();
        android.content.ContentValues args = new android.content.ContentValues();
        args.put("doc_id", 1);
        args.put("val", "hello");
        long id = sqlDatabase.insert("docs", null, args);
        sqlDatabase.setTransactionSuccessful();
        sqlDatabase.endTransaction();

        // add a doc -- inner transaction 2: CANCELLED
        sqlDatabase.beginTransaction();
        args = new android.content.ContentValues();
        args.put("doc_id", 2);
        args.put("val", "hello2");
        id = sqlDatabase.insert("docs", null, args);
        sqlDatabase.endTransaction();  // CANCELLED since we don't call setTransactionSuccessful()

        // finish outer transaction
        sqlDatabase.setTransactionSuccessful();
        sqlDatabase.endTransaction();

        CountDownLatch doc1Persisted = new CountDownLatch(1);

        // query db to make sure both docs are there
        android.database.Cursor cursor = sqlDatabase.rawQuery(
                "SELECT * FROM docs", null);
        while (cursor.moveToNext()) {
            int docId = cursor.getInt(0);
            byte[] val = cursor.getBlob(1);
            String.format("docid: %s val: %s", docId, new String(val));
            if (docId == 1) {
                doc1Persisted.countDown();
            }
        }

        assertEquals(0, doc1Persisted.getCount());


    }