Cursor for CursorAdapter?

[emmx]

Is there a way to get a cursor from queries such as the following ones?

Select
    .from(TestRecord.class)
    .where(Condition.prop("test").eq("satya"), Condition.prop("prop").eq(2))
    .list()

Book.listAll(Book.class)

I don't want to get a list of all matching items since I expect to have quite a lot of them. I want a cursor instead to use in a CursorAdapter to fill a ListView.

What's the way to go here?

[ScottEAdams]

I answered my own question about this yesterday in #154

public static Cursor getCursor() {
        SQLiteDatabase db = new SugarDb(MyApp.getInstance()).getDB();
        return db.rawQuery("Select * etc etc", null);
    }

[emmx]

I saw your workaround. I'm writing a couple of thoughts about it below.

You're writing the query yourself, it's not a good practice. Even if you don't mind doing so, there should be a .getSQL() or something so that we can use the query builder instead. Additionally, I've seen that internally Sugar uses cursors, it just doesn't provide a method to get a reference of it. Using SQLiteDatabase directly kind of break the abstraction layer. It's not entirely bad, but I added Sugar to this project in which I'm working so I didn't have to do that!

I just realized there is no way to inflate a SugarRecord given a cursor, or I couldn't find such a method. There is one .inflate() in SugarRecord but it's defined as private.

[martintama]

Are there any updates on this?

[whoshuu]

This has been requested a few times. I'll get it into 1.4.0! If someone can put up a pull request I'd be happy to merge it in

[benohalloran]

@whoshuu see PR 312