Beispiel #1
0
 /** Fetch all metadata that are unattached to the task */
 public TodorooCursor<Metadata> fetchDangling(Property<?>... properties) {
   Query sql =
       Query.select(properties)
           .from(Metadata.TABLE)
           .join(Join.left(Task.TABLE, Metadata.TASK.eq(Task.ID)))
           .where(Task.TITLE.isNull());
   Cursor cursor = database.rawQuery(sql.toString(), null);
   return new TodorooCursor<Metadata>(cursor, properties);
 }
 /**
  * Construct a query with SQL DSL objects
  *
  * @param query
  * @return
  */
 public TodorooCursor<TYPE> query(Query query) {
   query.from(table);
   if (debug) Log.i("SQL-" + modelClass.getSimpleName(), query.toString()); // $NON-NLS-1$
   Cursor cursor = database.rawQuery(query.toString(), null);
   return new TodorooCursor<TYPE>(cursor, query.getFields());
 }