Delete By WhereCondition about greendao HOT 10 CLOSED

I used the query builder for deleting with where clause

    public void deleteAllMessages() {
        RcMessagesDao messageDao = daoSession.getRcMessagesDao();  
        QueryBuilder qb = messageDao.queryBuilder();
        qb.where(ca.acesoft.reatchat.RcMessagesDao.Properties.Favorite.eq(false));
        List messageReceived = qb.list();
        messageDao.deleteInTx(messageReceived); 
    }
from greendao.

@jemshit If only that entity was affected that should work, it will clear the identity cache only for that entity. daoSesson.clear() does it for all entities. Just have a look at the (generated) code. -ut

from greendao.

Check out DeleteQuery: http://greendao-orm.com/javadoc/greendao/de/greenrobot/dao/DeleteQuery.html

I guess that's what you are looking for?

It's not documented fully yet, because its API is likely to change a bit in the future.

from greendao.

Sorry, a better pointer would have been to QueryBuilder.buildDelete(), which returns a DeleteQuery.

from greendao.

Actually, I decided to make this feature visible in the documentation (at the end of http://greendao-orm.com/documentation/queries/).

from greendao.

Ahh great, sorry should of looked a bit harder first!

Just need to make sure I refresh my models after deleting from what I can tell?

from greendao.

Bulk deletes are currently outside of the identity scope. It depends on your app structure if special treatment is required. For example, you could consider calling DaoSession.clear() to clear identity scope.

I'd close this issue for now.

from greendao.

@mohsinraza It is magic:
ca.acesoft.reatchat.RcMessagesDao.Properties.Favorite.eq(false) ?
what this? tell me please!
Thanks

from greendao.

Is it enough to call detachAll() on only daoObject that deleteQuery has been executed on? Instead of daoSesson.clear() ? @greenrobot

from greendao.

Can i use the following code to delete all rows from the table

DeleteQuery<Table> tableDeleteQuery = tableDao.queryBuilder().buildDelete();
tableDeleteQuery.executeDeleteWithoutDetachingEntities();

from greendao.