org.greenrobot.greendao.query.DeleteQuery Java Examples

/**
 * remove friend
 *
 * @param pubKey
 */
public void deleteRequestEntity(String pubKey) {
    QueryBuilder<FriendRequestEntity> qb = friendRequestEntityDao.queryBuilder();
    DeleteQuery<FriendRequestEntity> bd = qb.where(FriendRequestEntityDao.Properties.Pub_key.eq(pubKey))
            .buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**
 * remove member
 *
 * @param groupkey
 * @param pubkey
 */
public void removeMemberEntity(String groupkey, String pubkey) {
    QueryBuilder<GroupMemberEntity> qb = groupMemberEntityDao.queryBuilder();
    DeleteQuery<GroupMemberEntity> bd = qb.where(GroupMemberEntityDao.Properties.Identifier.eq(groupkey),
            qb.or(GroupMemberEntityDao.Properties.Identifier.eq(pubkey), GroupMemberEntityDao.Properties.Address.eq(pubkey))).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

public void deleteTwoThousandRecords() {
    Query tableSelectQuery = daoSession.getLogEntityDao().queryBuilder().where(LogEntityDao.Properties.Timestamp.le(new Long(new Date().getTime()))).orderAsc(LogEntityDao.Properties.Timestamp).limit(2000).build();
    List<LogEntity> records = tableSelectQuery.list();
    List ids = new ArrayList();
    for(LogEntity log : records){
        ids.add(log.getId());
    }

    DeleteQuery tableDeleteQuery = daoSession.getLogEntityDao().queryBuilder().where(LogEntityDao.Properties.Id.in(ids)).buildDelete();
    tableDeleteQuery.executeDeleteWithoutDetachingEntities();
    daoSession.clear();
    DbUtils.vacuum(daoSession.getDatabase());
}
 

public void deleteEntity(String address) {
    QueryBuilder<ContactEntity> qb = contactEntityDao.queryBuilder();
    DeleteQuery<ContactEntity> bd = qb.where(ContactEntityDao.Properties.Address.eq(address))
            .buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**
 * remove group
 *
 * @param groupkey
 */
public void removeGroupEntity(String groupkey) {
    QueryBuilder<GroupEntity> qb = groupEntityDao.queryBuilder();
    DeleteQuery<GroupEntity> bd = qb.where(GroupEntityDao.Properties.Identifier.eq(groupkey)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**
 * remove all member
 *
 * @param groupkey
 */
public void removeMemberEntity(String groupkey) {
    QueryBuilder<GroupMemberEntity> qb = groupMemberEntityDao.queryBuilder();
    DeleteQuery<GroupMemberEntity> bd = qb.where(GroupMemberEntityDao.Properties.Identifier.eq(groupkey)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**
 * remove recommend entity
 *
 * @param pubkey
 */
public void removeRecommendEntity(String pubkey) {
    QueryBuilder<RecommandFriendEntity> qb = recommandFriendEntityDao.queryBuilder();
    DeleteQuery<RecommandFriendEntity> bd = qb.where(RecommandFriendEntityDao.Properties.Pub_key.eq(pubkey)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**********************************************************************************************
 *                                      delete
 *********************************************************************************************/
public void deleteParamEntity(String key) {
    QueryBuilder<ParamEntity> qb = paramEntityDao.queryBuilder();
    DeleteQuery<ParamEntity> bd = qb.where(ParamEntityDao.Properties.Key.eq(key)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

public void deleteLikeParamEntity(String key){
    QueryBuilder<ParamEntity> qb = paramEntityDao.queryBuilder();
    DeleteQuery<ParamEntity> bd = qb.where(ParamEntityDao.Properties.Key.like("%" + key + "%")).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/**
 * remove room
 * @param roomid
 */
public void deleteRoom(String roomid) {
    QueryBuilder<ConversionEntity> qb = conversionEntityDao.queryBuilder();
    DeleteQuery<ConversionEntity> bd = qb.where(ConversionEntityDao.Properties.Identifier.eq(roomid)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

/********************************* delete ***********************************/
public void deleteRoomMsg(String pukkey) {
    QueryBuilder<MessageEntity> qb = messageEntityDao.queryBuilder();
    DeleteQuery<MessageEntity> bd = qb.where(MessageEntityDao.Properties.Message_ower.eq(pukkey)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

public void deleteMsgByid(String msgid) {
    QueryBuilder<MessageEntity> qb = messageEntityDao.queryBuilder();
    DeleteQuery<MessageEntity> bd = qb.where(MessageEntityDao.Properties.Message_id.eq(msgid)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}
 

public void clearMsgByRoomkey(String roomkey) {
    QueryBuilder<MessageEntity> qb = messageEntityDao.queryBuilder();
    DeleteQuery<MessageEntity> bd = qb.where(MessageEntityDao.Properties.Message_ower.eq(roomkey)).buildDelete();
    bd.executeDeleteWithoutDetachingEntities();
}