SQLite 周りのテストをしよう

context = new RenamingDelegatingContext(
getContext(),
"test_"
);

helper = new TestterSQLiteOpenHelper(
context
);

public class IconSQLiteDaoTest extends DatabaseTestCase {

private IconDao iconDao;

@Override
protected void setUp() throws Exception {
super.setUp();

importData(FileType.Yaml, "IconSQLiteDaoTest");
iconDao = new IconSQLiteDao(getSQLiteDatabase());
}

@Override
protected SQLiteOpenHelper createSQLiteOpenHelper() {
return new TestterSQLiteOpenHelper(getDatabaseContext());
}

public void testFindByUrl() {
Icon icon = iconDao.findByUrl("http://a2.twimg.com/
profile_images/1039340061/face_normal.png");
assertEquals(1, icon.id.intValue());
assertEquals("http://a2.twimg.com/profile_images/1039340061/
face_normal.png", icon.url);
assertEquals(1307203506481L, icon.createdAt.longValue());

public class MigrationTest extends DatabaseTestCase {

@Override
protected SQLiteOpenHelper createSQLiteOpenHelper() {
return new FixtureV1MigrationOpenHelper(getDatabaseContext());
}

public void testV1Migration() {
importData(FileType.Csv, "migrationTest");

ColumnInfo[] infos = loadColumnInfos("user");
assertEquals(5, infos.length);
assertEquals("_id", infos[0].getName());
assertEquals("name", infos[1].getName());
assertEquals("weight", infos[2].getName());
assertEquals("image", infos[3].getName());
assertEquals("created", infos[4].getName());

replaceSQLiteOpenHelper(new
FixtureMigrationOpenHelper(getDatabaseContext()));

infos = loadColumnInfos("user");
assertEquals(6, infos.length);

SQLite 周りのテストをしよう

More Related Content

SQLite 周りのテストをしよう

Editor's Notes