Android Open Source - sqlite-provider Extended S Q Lite Open Helper Test

• Back to SQLite/provider  ↑

From Project

Back to project page sqlite-provider.

License

The source code is released under:

Apache License

Java Source Code

package novoda.lib.sqliteprovider.sqlite;
//from   ww w.  j  a  va2  s  .c  o  m
import android.content.ContentValues;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.test.AndroidTestCase;
import android.test.suitebuilder.annotation.Suppress;

public class ExtendedSQLiteOpenHelperTest extends AndroidTestCase {

    private ExtendedSQLiteOpenHelper helper;

    @Override
    protected void setUp() throws Exception {
        super.setUp();
        helper = new ExtendedSQLiteOpenHelper(getContext());
    }

    @Override
    protected void tearDown() throws Exception {
        super.tearDown();
        for (String db : getContext().databaseList()) {
            getContext().deleteDatabase(db);
        }
    }

    public void testGetTableNames() throws Exception {
        helper.getWritableDatabase().execSQL("CREATE TABLE 'test'(id integer);");

        assertTrue("Table 'test' was not returned from getTables()", helper.getTables().contains("test"));
    }

    @Suppress
    // this should pass .. why it doesn't is an sql mystery
    public void testSettingFKFromCreateStatement() throws Exception {
        insertOne2Many("parent", "child");
        ContentValues values = new ContentValues();
        values.put("parent_id", 3);
        try {
            helper.getWritableDatabase().insert("child", null, values);
            fail("should throw an error upon insert against a one2many relationship");
        } catch (SQLiteException e) {
            assertTrue(true);
        }
    }

    private void insertOne2Many(String parentTable, String childTable) {
        SQLiteDatabase db = helper.getWritableDatabase();
        db.execSQL("CREATE TABLE '" + parentTable + "'(_id INTEGER PRIMARY KEY);");
        db.execSQL("CREATE TABLE '" + childTable + "'(_id INTEGER PRIMARY KEY, " + parentTable + "_id INTEGER, FOREIGN KEY(" + parentTable
                + "_id ) REFERENCES " + parentTable + "(_id) );");
    }
}

Java Source Code List

• Back to SQLite/provider  ↑