ShadowDatabaseUtilsTest.java

package org.robolectric.shadows;

import android.database.DatabaseUtils;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.robolectric.TestRunners;

import static org.assertj.core.api.Assertions.assertThat;

@RunWith(TestRunners.MultiApiSelfTest.class)
public class ShadowDatabaseUtilsTest {

  @Test
  public void testQuote() {
    assertThat(DatabaseUtils.sqlEscapeString("foobar")).isEqualTo("'foobar'");
    assertThat(DatabaseUtils.sqlEscapeString("Rich's")).isEqualTo("'Rich''s'");
  }

  @Test
  public void testQuoteWithBuilder() {
    StringBuilder builder = new StringBuilder();
    DatabaseUtils.appendEscapedSQLString(builder, "foobar");
    assertThat(builder.toString()).isEqualTo("'foobar'");

    builder = new StringBuilder();
    DatabaseUtils.appendEscapedSQLString(builder, "Blundell's");
    assertThat(builder.toString()).isEqualTo("'Blundell''s'");
  }
}