@Test
  public void onCreate() {
    mProvider.onCreate(mDatabase);

    verify(mDatabase)
        .execSQL(
            "CREATE TABLE foos (bar TEXT PRIMARY KEY, late FLOAT NOT NULL UNIQUE, time REAL);");
  }
 @Test(expected = SQLiteException.class)
 public void onDowngrade() {
   mProvider.onDowngrade(mDatabase, 2, 1);
 }
  @Test
  public void onUpgradeEmpty() {
    mProvider.onUpgrade(mDatabase, 2, 3);

    verifyNoMoreInteractions(mDatabase);
  }
  @Test
  public void onUpgrade() {
    mProvider.onUpgrade(mDatabase, 1, 2);

    verify(mDatabase).execSQL("ALTER TABLE foos ADD COLUMN late FLOAT NOT NULL UNIQUE;");
  }