Examples with CategoryDao org.liberty.android.fantastischmemo.dao.CategoryDao used on opensource projects

Example 1 with CategoryDao

use of org.liberty.android.fantastischmemo.dao.CategoryDao in project AnyMemo by helloworld1.

the class DatabaseUtil method mergeDatabases.

public void mergeDatabases(String destPath, String srcPath) throws Exception {
    AnyMemoDBOpenHelper destHelper = AnyMemoDBOpenHelperManager.getHelper(mContext, destPath);
    AnyMemoDBOpenHelper srcHelper = AnyMemoDBOpenHelperManager.getHelper(mContext, srcPath);
    final CardDao cardDaoDest = destHelper.getCardDao();
    final LearningDataDao learningDataDaoSrc = srcHelper.getLearningDataDao();
    final CategoryDao categoryDaoSrc = srcHelper.getCategoryDao();
    final CardDao cardDaoSrc = srcHelper.getCardDao();
    final List<Card> srcCards = cardDaoSrc.queryForAll();
    cardDaoSrc.callBatchTasks(new Callable<Void>() {

        public Void call() throws Exception {
            for (Card c : srcCards) {
                // Make sure to create a new ordinal
                c.setOrdinal(null);
                learningDataDaoSrc.refresh(c.getLearningData());
                categoryDaoSrc.refresh(c.getCategory());
            }
            return null;
        }
    });
    cardDaoDest.createCards(srcCards);
    System.out.println("DatabaseUtils release destPath");
    AnyMemoDBOpenHelperManager.releaseHelper(destHelper);
    System.out.println("DatabaseUtils release srcPath");
    AnyMemoDBOpenHelperManager.releaseHelper(srcHelper);
}

Example 2 with CategoryDao

use of org.liberty.android.fantastischmemo.dao.CategoryDao in project AnyMemo by helloworld1.

the class CardDaoTest method testGetCardsByCategory.

@SmallTest
@Test
public void testGetCardsByCategory() throws Exception {
    CardDao cardDao = helper.getCardDao();
    CategoryDao categoryDao = helper.getCategoryDao();
    setupThreeCategories();
    Category filterCategory1 = categoryDao.createOrReturn("My category");
    // If category specified is null, return all cards up to limit
    List<Card> cards1 = cardDao.getCardsByCategory(null, false, 50);
    assertEquals(28, cards1.size());
    // No category specified but with limit
    List<Card> cards2 = cardDao.getCardsByCategory(null, false, 10);
    assertEquals(10, cards2.size());
    // Get by category
    List<Card> cards3 = cardDao.getCardsByCategory(filterCategory1, false, 50);
    assertEquals(3, cards3.size());
    // Get by category with limit
    List<Card> cards4 = cardDao.getCardsByCategory(filterCategory1, false, 2);
    assertEquals(2, cards4.size());
    // Random cards shouldn't affect number of cards to get
    List<Card> cards5 = cardDao.getCardsByCategory(filterCategory1, true, 50);
    assertEquals(3, cards5.size());
}

Example 3 with CategoryDao

use of org.liberty.android.fantastischmemo.dao.CategoryDao in project AnyMemo by helloworld1.

the class CardDaoTest method setupThreeCategories.

/*
     * Card with "My Category" in ID 2, 5, 8
     */
private void setupThreeCategories() throws SQLException {
    CardDao cardDao = helper.getCardDao();
    CategoryDao categoryDao = helper.getCategoryDao();
    Card c = cardDao.queryForId(2);
    Category ct = new Category();
    ct.setName("My category");
    categoryDao.create(ct);
    c.setCategory(ct);
    cardDao.update(c);
    c = cardDao.queryForId(5);
    c.setCategory(ct);
    cardDao.update(c);
    c = cardDao.queryForId(8);
    c.setCategory(ct);
    cardDao.update(c);
}

Example 4 with CategoryDao

use of org.liberty.android.fantastischmemo.dao.CategoryDao in project AnyMemo by helloworld1.

the class CardDaoTest method testGetScheduledCardCount.

@SmallTest
@Test
public void testGetScheduledCardCount() throws Exception {
    CardDao cardDao = helper.getCardDao();
    assertEquals(0L, cardDao.getScheduledCardCount(null));
    setupThreeCategories();
    CategoryDao categoryDao = helper.getCategoryDao();
    List<Category> cts = categoryDao.queryForEq("name", "My category");
    Category ct = cts.get(0);
    assertEquals(0L, cardDao.getScheduledCardCount(ct));
}

Example 5 with CategoryDao

use of org.liberty.android.fantastischmemo.dao.CategoryDao in project AnyMemo by helloworld1.

the class CardDaoTest method testGetNewCardCount.

@SmallTest
@Test
public void testGetNewCardCount() throws Exception {
    CardDao cardDao = helper.getCardDao();
    assertEquals(28L, cardDao.getNewCardCount(null));
    setupThreeCategories();
    CategoryDao categoryDao = helper.getCategoryDao();
    List<Category> cts = categoryDao.queryForEq("name", "My category");
    Category ct = cts.get(0);
    assertEquals(3L, cardDao.getNewCardCount(ct));
}