core/tests/coretests/src/android/database/sqlite/SQLiteUnfinalizedExceptionTest.java

/*
 * Copyright (C) 2010 The Android Open Source Project
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package android.database.sqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabaseTest.ClassToTestSqlCompilationAndCaching;
import android.test.AndroidTestCase;
import android.test.suitebuilder.annotation.SmallTest;

import java.io.File;

public class SQLiteUnfinalizedExceptionTest extends AndroidTestCase {
    private SQLiteDatabase mDatabase;
    private File mDatabaseFile;
    private static final String TABLE_NAME = "testCursor";
    @Override
    protected void setUp() throws Exception {
        super.setUp();

        File dbDir = getContext().getDir(this.getClass().getName(), Context.MODE_PRIVATE);
        mDatabaseFile = new File(dbDir, "UnfinalizedExceptionTest.db");
        if (mDatabaseFile.exists()) {
            mDatabaseFile.delete();
        }
        mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
        assertNotNull(mDatabase);
    }

    @Override
    protected void tearDown() throws Exception {
        mDatabase.close();
        mDatabaseFile.delete();
        super.tearDown();
    }

    @SmallTest
    public void testUnfinalizedExceptionNotExcpected() {
        mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);");
        // the above statement should be in SQLiteDatabase.mPrograms
        // and should automatically be finalized when database is closed
        mDatabase.lock();
        try {
            mDatabase.closeDatabase();
        } finally {
            mDatabase.unlock();
        }
    }

    @SmallTest
    public void testUnfinalizedException() {
        mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);");
        mDatabase.lock();
        mDatabase.closePendingStatements(); // clears the above from finalizer queue in mdatabase
        mDatabase.unlock();
        ClassToTestSqlCompilationAndCaching.create(mDatabase, "select * from "  + TABLE_NAME);
        // since the above is NOT closed, closing database should fail
        mDatabase.lock();
        try {
            mDatabase.closeDatabase();
            fail("exception expected");
        } catch (SQLiteUnfinalizedObjectsException e) {
            // expected
        } finally {
            mDatabase.unlock();
        }
    }
}