Android Open Source - watchme Watch Me Content Provider Test

From Project

Back to project page watchme.
License

The source code is released under:
Copyright (c) 2012 Johan Brook, Robin Andersson, Lisa Stenberg, Mattias Henriksson Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documen...
If you think the Android project watchme listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package se.chalmers.watchmetest.database;
//from  w  ww . j  a v  a 2  s.c o m
import junit.framework.Assert;
import se.chalmers.watchme.database.HasTagTable;
import se.chalmers.watchme.database.MoviesTable;
import se.chalmers.watchme.database.TagsTable;
import se.chalmers.watchme.database.WatchMeContentProvider;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.test.ProviderTestCase2;

/**
 * Test all public methods in WatchMeContenProvider
 * 
 * From http://developer.android.com/tools/testing/contentprovider_testing.html
 * "Test with resolver methods: Even though you can instantiate a provider 
 * object in ProviderTestCase2, you should always test with a resolver object 
 * using the appropriate URI. This ensures that you are testing the provider 
 * using the same interaction that a regular application would use. "
 * 
 * @author lisastenberg
 * 
 */
public class WatchMeContentProviderTest extends ProviderTestCase2<WatchMeContentProvider>{
  
  Uri uri_movies = WatchMeContentProvider.CONTENT_URI_MOVIES;
  Uri uri_tags = WatchMeContentProvider.CONTENT_URI_TAGS;
  Uri uri_hastag = WatchMeContentProvider.CONTENT_URI_HAS_TAG;
  
  Uri[] validUris = new Uri[] { uri_movies, uri_tags, uri_hastag };
  
  private ContentResolver contentResolver;
  
  public WatchMeContentProviderTest() {
      super(WatchMeContentProvider.class, WatchMeContentProvider.AUTHORITY);
  }
  
  @Override
    protected void setUp() throws Exception {
        super.setUp();
        contentResolver = getMockContentResolver();
    }

  @Override
  protected void tearDown() throws Exception {
        super.tearDown();
    }
  
  /**
   * Test valid URIs and unvalid URIs
   * 
   * From http://developer.android.com/tools/testing/contentprovider_testing.html
   * "Test invalid URIs: Your unit tests should deliberately call the provider
   *  with an invalid URI, and look for errors. Good provider design is to 
   *  throw an IllegalArgumentException for invalid URIs. "
   */
  public void testURI() {
    Uri uri_invalid = Uri.parse("invalid");
    
    try {
      contentResolver.insert(uri_invalid, new ContentValues());
      Assert.fail("insert: Should have thrown IllegalArgumentException");
    }
    catch(IllegalArgumentException e) {}
    
    /*
     * This is not passed with success. Seems like a bug in ContentResolver
     * When I send in the invalid uri in CP.query it doesn't even get inside
     * the method.
     * 
    try {
      contentResolver.query(uri_invalid, null, null, null, null);
      Assert.fail("query: Should have thrown IllegalArgumentException\n");
    }
    catch(IllegalArgumentException e) {}
    */
    
    try {
      contentResolver.update(uri_invalid, new ContentValues(), null, null);
      Assert.fail("update: Should have thrown IllegalArgumentException");
    }
    catch(IllegalArgumentException e) {}
    
    try {
      contentResolver.delete(uri_invalid, null, null);
      Assert.fail("delete: Should have thrown IllegalArgumentException");
    }
    catch(IllegalArgumentException e) {}
  }

  public void testQuery() {
        for (Uri uri : validUris) {
            Cursor cursor = contentResolver.query(uri, null, null, null, null);
            assertNotNull(cursor);
        }    
    }
  
  public void testInsert() {
    ContentValues values = new ContentValues();
    
    /*
     * Test insert into uri_movie
     */
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    Uri tmpUri = contentResolver.insert(uri_movies, values);
    long movieId = Long.parseLong(tmpUri.getLastPathSegment());
    // Check that the id of the movie was returned.
    assertTrue(movieId != 0);
    
    Cursor cursor = contentResolver.query(uri_movies, null, 
        MoviesTable.COLUMN_MOVIE_ID + " = " + movieId, null, null);
    assertEquals(cursor.getCount(), 1);
    
    cursor.moveToFirst();
    assertTrue(cursor.getString(1).equals("batman"));
    
    /*
     * Test insert the movie with the same title into uri_movie
     */
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
      
      tmpUri = contentResolver.insert(uri_movies, values);
      long zeroId = Long.parseLong(tmpUri.getLastPathSegment());
    
      // If the movie already existed insert should return 0.
     assertEquals(zeroId, 0);
     
     // Confirms that there exist one and only one movie with the title 'batman'
     cursor = contentResolver.query(uri_movies, null, 
        MoviesTable.COLUMN_TITLE + " = 'batman'", null, null);
    assertEquals(cursor.getCount(), 1);
      
    /*
     * Test insert into uri_tag
     */
    values = new ContentValues();
    
    values.put(TagsTable.COLUMN_NAME, "tag");
    try {
      tmpUri = contentResolver.insert(uri_tags, values);
      Assert.fail("Should throw UnsupportedOperationException");
    } catch(UnsupportedOperationException e) {}
    
    /*
     * Test insert into uri_hastag
     */
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_MOVIE_ID, movieId);
    values.put(TagsTable.COLUMN_NAME, "tag");
    tmpUri = contentResolver.insert(uri_hastag, values);
    long tagId = Long.parseLong(tmpUri.getLastPathSegment());
    
    cursor = contentResolver.query(uri_hastag, null, 
        HasTagTable.COLUMN_MOVIE_ID + " = " + movieId + " AND " +
            HasTagTable.COLUMN_TAG_ID + " = " + tagId, null, null);
    assertEquals(cursor.getCount(), 1);
    
    /*
     * Attach a tag to a movie it is already attached to.
     */
    tmpUri = contentResolver.insert(uri_hastag, values);
    zeroId = Long.parseLong(tmpUri.getLastPathSegment());
    
    // If the attachment already existed insert should return 0.
    assertEquals(zeroId, 0);
    
    cursor = contentResolver
        .query(uri_hastag, null, HasTagTable.COLUMN_MOVIE_ID + " = "
            + movieId + " AND " + HasTagTable.COLUMN_TAG_ID + " = "
            + tagId, null, null);
    /* Confirms that there exist one and only one attachment between the 
     * movie 'batman' and the tag 'tag'
     */
    assertEquals(cursor.getCount(), 1);
  }
  
  /*
   * Precondition: testInsertMovie has passed
   */
  public void testUpdate() {
    
    ContentValues values = new ContentValues();
    
    /*
     * Update movie
     */
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    Uri tmpUri = contentResolver.insert(uri_movies, values);
    long movieId = Long.parseLong(tmpUri.getLastPathSegment());
    
    values = new ContentValues();
    values.put(MoviesTable.COLUMN_NOTE, "updated");
    int updatedRows = contentResolver.update(uri_movies, values, "_id = " + movieId, null);
    assertEquals(updatedRows, 1);
    
    /*
     * Update attachment between movie and tag not necessary for WatchMe
     */
    
    /*
     * Update tag
     */
    values = new ContentValues();
    values.put(MoviesTable.COLUMN_MOVIE_ID, movieId);
    values.put(TagsTable.COLUMN_NAME, "tag");
    
    tmpUri = contentResolver.insert(uri_hastag, values);
    long tagId = Long.parseLong(tmpUri.getLastPathSegment());
    
    updatedRows = contentResolver.update(uri_tags, values, 
        TagsTable.COLUMN_TAG_ID + " = " + tagId, null);
    assertEquals(updatedRows, 1);
  }
  
  /*
   * Precondition: testInsertMovie has passed
   */
  public void testDeleteMovie() {
    
    ContentValues values = new ContentValues();
    
    /*
     * Delete a movie without a tag
     */
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    Uri tmpUri = contentResolver.insert(uri_movies, values);
    long movieId = Long.parseLong(tmpUri.getLastPathSegment());
    
    int deletedRows = contentResolver.delete(uri_movies, "_id = " + movieId, null);
    assertEquals(deletedRows, 1);
    
    /*
     * Delete a movie with a tag
     */
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    tmpUri = contentResolver.insert(uri_movies, values);
    movieId = Long.parseLong(tmpUri.getLastPathSegment());
    
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_MOVIE_ID, movieId);
    values.put(TagsTable.COLUMN_NAME, "tag");
    contentResolver.insert(uri_hastag, values);
    
    /* Confirms that the movie was deleted and that the tag was attached 
     * from the movie
     */
    deletedRows = contentResolver.delete(uri_movies, 
        MoviesTable.COLUMN_MOVIE_ID + " = "+ movieId, null);
    assertEquals(deletedRows, 1);
    
    // Confirms that the tag was deleted completely
    Cursor cursor = contentResolver.query(uri_tags, null, null, null, null);
    assertEquals(cursor.getCount(), 0);
    
    /*
     * Detach a tag (delete from hastag)
     */
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    tmpUri = contentResolver.insert(uri_movies, values);
    movieId = Long.parseLong(tmpUri.getLastPathSegment());
    
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_MOVIE_ID, movieId);
    values.put(TagsTable.COLUMN_NAME, "tag");
    tmpUri = contentResolver.insert(uri_hastag, values);
    long tagId = Long.parseLong(tmpUri.getLastPathSegment());
    
    deletedRows = contentResolver.delete(uri_hastag, 
        HasTagTable.COLUMN_MOVIE_ID + " = "+ movieId + " AND " +
            HasTagTable.COLUMN_TAG_ID + " = " + tagId, null);
    assertEquals(deletedRows, 1);
    
    /*
     * The tag should also be detached from the movie, but this can't
     * be tested since this is forced by a TRIGGER in the DatabaseHelper
     * and not in the CP
     */
    
    // Confirms that the tag was deleted completely
    cursor = contentResolver.query(uri_tags, null, null, null, null);
    assertEquals(cursor.getCount(), 0);
    
    /*
     * Delete tag 
     */
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_TITLE, "batman");
    values.put(MoviesTable.COLUMN_RATING, 1);
      values.put(MoviesTable.COLUMN_NOTE, "");
      values.put(MoviesTable.COLUMN_DATE, 0);
      values.put(MoviesTable.COLUMN_IMDB_ID, 0);
      values.put(MoviesTable.COLUMN_POSTER_LARGE, "");
      values.put(MoviesTable.COLUMN_POSTER_SMALL, "");
    
    tmpUri = contentResolver.insert(uri_movies, values);
    movieId = Long.parseLong(tmpUri.getLastPathSegment());
    
    values = new ContentValues();
    
    values.put(MoviesTable.COLUMN_MOVIE_ID, movieId);
    values.put(TagsTable.COLUMN_NAME, "tag");
    tmpUri = contentResolver.insert(uri_hastag, values);
    tagId = Long.parseLong(tmpUri.getLastPathSegment());
    
    deletedRows = contentResolver.delete(uri_tags, 
            TagsTable.COLUMN_TAG_ID + " = " + tagId, null);
    assertEquals(deletedRows, 1);
    
    /*
     * The tag should also be detached from the movie, but this can't
     * be tested since this is forced by a TRIGGER in the DatabaseHelper
     * and not in the CP
     */
  }
  
}
Java Source Code List
