コード例 #1
0
ファイル: InsertTest.java プロジェクト: 0359xiaodong/squidb
  public void testInsertWithDefaultValues() {
    // insert into things default values;
    Insert insert = Insert.into(Thing.TABLE).defaultValues();
    CompiledStatement compiled = insert.compile();

    verifyCompiledSqlArgs(compiled, 0);

    int rowsBeforeInsert = dao.count(Thing.class, Criterion.all);
    assertEquals(3, dao.insert(insert));
    int rowsAfterInsert = dao.count(Thing.class, Criterion.all);

    assertEquals(rowsBeforeInsert + 1, rowsAfterInsert);

    // get the newest
    Thing newThing = null;
    SquidCursor<Thing> cursor = null;
    try {
      cursor =
          dao.query(
              Thing.class, Query.select(Thing.PROPERTIES).orderBy(Order.desc(Thing.ID)).limit(1));
      if (cursor.moveToFirst()) {
        newThing = new Thing(cursor);
      }
    } finally {
      if (cursor != null) {
        cursor.close();
      }
    }

    assertNotNull(newThing);
    assertEquals(Thing.DEFAULT_FOO, newThing.getFoo());
    assertEquals(Thing.DEFAULT_BAR, newThing.getBar().intValue());
    assertEquals(Thing.DEFAULT_IS_ALIVE, newThing.isAlive().booleanValue());
  }
コード例 #2
0
  private void testRecyclerAdapterInternal(LongProperty idProperty, RecyclerAdapterTest test) {
    Query query = Query.select(TestModel.PROPERTIES).orderBy(TestModel.BIRTHDAY.asc()).limit(2);
    if (idProperty != null) {
      query.selectMore(idProperty);
    }
    SquidCursor<TestModel> cursor = database.query(TestModel.class, query);

    TestRecyclerAdapter adapter = new TestRecyclerAdapter(idProperty);
    adapter.changeCursor(cursor);
    try {
      test.testRecyclerAdapter(adapter);
    } finally {
      cursor.close();
    }
  }
コード例 #3
0
ファイル: NetworkLanguageDao.java プロジェクト: kiwix/kiwix
 public ArrayList<LibraryAdapter.Language> getFilteredLanguages() {
   SquidCursor<NetworkLanguageDatabaseEntity> languageCursor =
       mDb.query(NetworkLanguageDatabaseEntity.class, Query.select());
   ArrayList<LibraryAdapter.Language> result = new ArrayList<>();
   try {
     while (languageCursor.moveToNext()) {
       result.add(
           new LibraryAdapter.Language(
               languageCursor.get(NetworkLanguageDatabaseEntity.LANGUAGE_I_S_O_3),
               languageCursor.get(NetworkLanguageDatabaseEntity.ENABLED)));
     }
   } finally {
     languageCursor.close();
   }
   return result;
 }