use of org.liberty.android.fantastischmemo.entity.Category in project AnyMemo by helloworld1.
the class CardDaoTest method testSearchFirstOrdinalWithcategoryIfExists.
@SmallTest
@Test
public void testSearchFirstOrdinalWithcategoryIfExists() throws Exception {
setupThreeCategories();
CardDao cardDao = helper.getCardDao();
CategoryDao categoryDao = helper.getCategoryDao();
List<Category> cts = categoryDao.queryForEq("name", "My category");
Category ct = cts.get(0);
Card c = cardDao.queryFirstOrdinal(ct);
assertEquals(2, (int) c.getId());
}
use of org.liberty.android.fantastischmemo.entity.Category in project AnyMemo by helloworld1.
the class CardDaoTest method testGetRandomCardsWithCategory.
@SmallTest
@Test
public void testGetRandomCardsWithCategory() throws Exception {
CardDao cardDao = helper.getCardDao();
CategoryDao categoryDao = helper.getCategoryDao();
setupThreeCategories();
Category filterCategory1 = categoryDao.createOrReturn("My category");
// larger than limit
List<Card> cards1 = cardDao.getRandomCards(filterCategory1, 50);
assertEquals(3, cards1.size());
// smaller than limit
List<Card> cards2 = cardDao.getRandomCards(filterCategory1, 1);
assertEquals(1, cards2.size());
}
use of org.liberty.android.fantastischmemo.entity.Category in project AnyMemo by helloworld1.
the class CardDaoTest method testQueryNextCardWithCategory.
@SmallTest
@Test
public void testQueryNextCardWithCategory() throws Exception {
setupThreeCategories();
CardDao cardDao = helper.getCardDao();
CategoryDao categoryDao = helper.getCategoryDao();
List<Category> cts = categoryDao.queryForEq("name", "My category");
Category ct = cts.get(0);
Card c2 = cardDao.queryForId(2);
Card c5 = cardDao.queryNextCard(c2, ct);
assertEquals(5, (int) c5.getId());
Card c8 = cardDao.queryForId(8);
c2 = cardDao.queryNextCard(c8, ct);
assertEquals(2, (int) c2.getId());
}
use of org.liberty.android.fantastischmemo.entity.Category in project AnyMemo by helloworld1.
the class CategoryTest method testAddCategories.
@SmallTest
@Test
public void testAddCategories() throws Exception {
CategoryDao categoryDao = helper.getCategoryDao();
List<Category> categories = categoryDao.queryForAll();
int initSize = categories.size();
Category c1 = categoryDao.createOrReturn("c1");
assertNotNull(c1);
assertEquals(c1.getName(), "c1");
categories = categoryDao.queryForAll();
assertEquals(categories.size(), initSize + 1);
Category c2 = categoryDao.createOrReturn("c1");
assertEquals(c2.getName(), "c1");
assertEquals(categories.size(), initSize + 1);
}
use of org.liberty.android.fantastischmemo.entity.Category in project AnyMemo by helloworld1.
the class DatabaseUtilsTest method testMergeDatabase.
@SmallTest
@Test
@SuppressWarnings("unused")
public void testMergeDatabase() throws Exception {
// Create testing DB to merge
String path2 = "/sdcard/testdb2.db";
new File(path2).delete();
AnyMemoDBOpenHelper helper2 = AnyMemoDBOpenHelperManager.getHelper(getContext(), path2);
// DAOs to use
CardDao destCardDao = helper.getCardDao();
CategoryDao destCategoryDao = helper.getCategoryDao();
LearningDataDao destLearningDataDao = helper.getLearningDataDao();
CardDao srcCardDao = helper2.getCardDao();
CategoryDao srcCategoryDao = helper2.getCategoryDao();
LearningDataDao srcLearningDataDao = helper2.getLearningDataDao();
// Create some categories in both db to test category merge
Category destCat1 = destCategoryDao.createOrReturn("cat1");
Category destCat2 = destCategoryDao.createOrReturn("cat2");
Category srcCat2 = srcCategoryDao.createOrReturn("cat2");
Category srcCat3 = srcCategoryDao.createOrReturn("cat3");
// Modify the learning data and category for some cards in src
Card destCard20 = destCardDao.queryForId(20);
destCategoryDao.refresh(destCard20.getCategory());
destLearningDataDao.refresh(destCard20.getLearningData());
destCard20.setCategory(destCat1);
LearningData destLd20 = destCard20.getLearningData();
// Use a specific acq_reps for testing
destLd20.setAcqReps(15);
destLearningDataDao.update(destLd20);
destCardDao.update(destCard20);
// Another card for testing duplicated category in src and dest
Card destCard21 = destCardDao.queryForId(21);
destCategoryDao.refresh(destCard21.getCategory());
destLearningDataDao.refresh(destCard21.getLearningData());
destCard21.setCategory(destCat2);
LearningData destLd21 = destCard21.getLearningData();
destLd21.setAcqReps(16);
destLearningDataDao.update(destLd21);
destCardDao.update(destCard21);
// Now set up the cards in the src db
// Card 1 with a duplicated category as dest db
Card srcCard1 = new Card();
srcCard1.setQuestion("card1");
LearningData srcLd1 = new LearningData();
srcLd1.setAcqReps(8);
srcCard1.setLearningData(srcLd1);
srcCard1.setCategory(srcCat2);
srcCardDao.createCard(srcCard1);
// Card 2 with a new category
Card srcCard2 = new Card();
srcCard2.setQuestion("card2");
LearningData srcLd2 = new LearningData();
srcLd2.setAcqReps(10);
srcCard2.setLearningData(srcLd2);
srcCard2.setCategory(srcCat3);
srcCardDao.createCard(srcCard2);
// Card 3 with default lenaring data and category
Card srcCard3 = new Card();
srcCard3.setQuestion("card3");
srcCard3.setCategory(new Category());
srcCard3.setLearningData(new LearningData());
srcCardDao.createCard(srcCard3);
// Now merge them!
databaseUtil.mergeDatabases(TestHelper.SAMPLE_DB_PATH, path2);
// Original 28 plus 3 merged cards
assertEquals(31, destCardDao.queryForAll().size());
assertEquals(31, destLearningDataDao.queryForAll().size());
// 5 categories: "", "french-body-parts.db", "cat1", "cat2", "cat3"
assertEquals(5, destCategoryDao.queryForAll().size());
// Query out the cards we are interested in
Card mergedCard20 = destCardDao.queryForId(20);
destLearningDataDao.refresh(mergedCard20.getLearningData());
destCategoryDao.refresh(mergedCard20.getCategory());
Card mergedCard21 = destCardDao.queryForId(21);
destLearningDataDao.refresh(mergedCard21.getLearningData());
destCategoryDao.refresh(mergedCard21.getCategory());
Card mergedCard29 = destCardDao.queryForId(29);
destLearningDataDao.refresh(mergedCard29.getLearningData());
destCategoryDao.refresh(mergedCard29.getCategory());
Card mergedCard30 = destCardDao.queryForId(30);
destLearningDataDao.refresh(mergedCard30.getLearningData());
destCategoryDao.refresh(mergedCard30.getCategory());
Card mergedCard31 = destCardDao.queryForId(31);
destLearningDataDao.refresh(mergedCard31.getLearningData());
destCategoryDao.refresh(mergedCard31.getCategory());
// Now verify
// The original cards in dest should be intact
assertEquals(destCard20.getOrdinal(), mergedCard20.getOrdinal());
assertEquals(destCard20.getQuestion(), mergedCard20.getQuestion());
assertEquals("cat1", mergedCard20.getCategory().getName());
assertEquals(15, (int) mergedCard20.getLearningData().getAcqReps());
assertEquals(destCard21.getOrdinal(), mergedCard21.getOrdinal());
assertEquals(destCard21.getQuestion(), mergedCard21.getQuestion());
assertEquals("cat2", mergedCard21.getCategory().getName());
assertEquals(16, (int) mergedCard21.getLearningData().getAcqReps());
// The newly merged cards
assertEquals(29, (int) mergedCard29.getOrdinal());
assertEquals("card1", mergedCard29.getQuestion());
assertEquals("cat2", mergedCard29.getCategory().getName());
assertEquals(8, (int) mergedCard29.getLearningData().getAcqReps());
assertEquals(30, (int) mergedCard30.getOrdinal());
assertEquals("card2", mergedCard30.getQuestion());
assertEquals("cat3", mergedCard30.getCategory().getName());
assertEquals(10, (int) mergedCard30.getLearningData().getAcqReps());
assertEquals(31, (int) mergedCard31.getOrdinal());
assertEquals("card3", mergedCard31.getQuestion());
assertEquals("", mergedCard31.getCategory().getName());
assertEquals(0, (int) mergedCard31.getLearningData().getAcqReps());
// Clearn up
AnyMemoDBOpenHelperManager.releaseHelper(helper2);
new File(path2).delete();
}
Aggregations