Java Delete类代码示例

import com.activeandroid.query.Delete; //导入依赖的package包/类
@Override public void onBackPressed() {
    super.onBackPressed();
    //TODO 遍历数据，将isLike==true的数据存到数据库，优化线程
    if (mList == null || mList.isEmpty()) {
        return;
    }
    for (Gank gank : mList) {
        if (!new Select().from(Gank.class).where("_id=?", gank.get_id()).exists() &&
            gank.getIsLike()) {
            gank.save();
        }
        if (!gank.getIsLike() &&
            new Select().from(Gank.class)
                .where("_id=?", gank.get_id())
                .exists()) {//从数据库中将取消收藏的删除
            new Delete().from(Gank.class).where("_id=?", gank.get_id()).execute();
        }
        RxBus.getInstance().post(new StatusEvent(StatusEvent.TYPE_ON_LIKE_CHANGE));
    }
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public DeleteFileTask(FileManagerFragment fileManagerFragment){
    this.fileManagerFragment = fileManagerFragment;

    Device device = Device.registeredDevice();

    // delete all local notes
    new Delete().from(Note.class).execute();

    // cozy register device url
    this.url = device.getUrl() + "/ds-api/data/";


    // concatenate username and password with colon for authentication
    final String credentials = device.getLogin() + ":" + device.getPassword();
    authHeader = "Basic " + Base64.encodeToString(credentials.getBytes(), Base64.NO_WRAP);

    dialog = new ProgressDialog(fileManagerFragment.getActivity());
    dialog.setCancelable(false);
    dialog.setProgress(0);
    dialog.setMax(100);
    dialog.setMessage("Please wait");
    dialog.setIndeterminate(false);
    dialog.setProgressStyle(ProgressDialog.STYLE_HORIZONTAL);
    dialog.show();

}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public GetPlacesTask(PlacesFragment placesFragment){
    this.placesFragment = placesFragment;
    allPlaces = new ArrayList<>();

    Device device = Device.registeredDevice();

    // delete all local places
    new Delete().from(Place.class).execute();

    // cozy register device url
    this.url = device.getUrl() + "/ds-api/request/place/all/";


    // concatenate username and password with colon for authentication
    final String credentials = device.getLogin() + ":" + device.getPassword();
    authHeader = "Basic " + Base64.encodeToString(credentials.getBytes(), Base64.NO_WRAP);

    dialog = new ProgressDialog(placesFragment.getActivity());
    dialog.setCancelable(false);
    dialog.setMessage("Please wait");
    dialog.setIndeterminate(true);
    dialog.show();

}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public static void cleanQueue() {
    // delete all completed records > 24 hours old
    fixUpTable();
    try {
        new Delete()
                .from(UploaderQueue.class)
                .where("timestamp < ?", JoH.tsl() - 86400000L)
                .where("bitfield_wanted == bitfield_complete")
                .execute();

        // delete everything > 7 days old
        new Delete()
                .from(UploaderQueue.class)
                .where("timestamp < ?", JoH.tsl() - 86400000L * 7L)
                .execute();
    } catch (Exception e) {
        UserError.Log.d(TAG, "Exception cleaning uploader queue: " + e);
    }
    last_cleanup = JoH.tsl();
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
private void cachePost(Post post, boolean isNewPost) {
    if (isNewPost) {
        this.post = post;
        Post oldPost = new Select().from(Post.class).where("id = ?", post.id).executeSingle();
        if (oldPost != null)
            oldPost.delete();
        else
            while (new Select().from(Post.class).count() >= POST_MAX_CACHE_NUM)
                new Delete().from(Post.class).executeSingle();
        post.text = "";
    }
    for (Object line : post.content) {
        if (line.getClass().equals(String.class))
            this.post.text += line + "\n";
        else
            this.post.text += gson.toJson(line) + "\n";
    }
    this.post.save();
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
private void removeFeedRelativeItems() throws ClassNotFoundException {
    // 获取所有缓存的Feed
    List<FeedItem> cacheFeedItems = new Select().from(FeedItem.class)
            .where("category='NORMAL'").execute();

    Class<? extends Model> feedLikeClass = refectModelClz("com.umeng.comm.core.beans.relation.FeedLike");
    Class<? extends Model> feedCommentClass = refectModelClz("com.umeng.comm.core.beans.relation.FeedComment");
    Class<? extends Model> feedTopicClass = refectModelClz("com.umeng.comm.core.beans.relation.FeedTopic");
    Class<? extends Model> feedCreatorClass = refectModelClz("com.umeng.comm.core.beans.relation.FeedCreator");
    Class<? extends Model> feedFriendClass = refectModelClz("com.umeng.comm.core.beans.relation.FeedFriends");

    for (FeedItem feedItem : cacheFeedItems) {
        // 移除like相关
        removeRelativeLike(feedItem.id, feedLikeClass);
        // 移除Feed相关的Comment
        removeRelativeComment(feedItem.id, feedCommentClass);
        new Delete().from(feedTopicClass).where("feed_id=?", feedItem.id)
                .execute();
        new Delete().from(feedCreatorClass).where("feed_id=?", feedItem.id)
                .execute();
        new Delete().from(feedFriendClass).where("feed_id=?", feedItem.id)
                .execute();
    }
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
@Override
public void deleteLikesFromDB(final String feedId, final String likeId) {
    if (TextUtils.isEmpty(feedId) || TextUtils.isEmpty(likeId)) {
        return;
    }

    submit(new DbCommand() {

        @Override
        protected void execute() {
            new Delete().from(Like.class).where("_id=?", likeId).execute();
            DBRelationOP<?> relation = EntityRelationFactory.createFeedLike(feedId);
            relation.deleteById(likeId);
        }
    });
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public static void testAddressItems(Context context) {
    new Delete().from(SimpleAddressItem.class).execute();

    final Collection<SimpleAddressItem> activeAndroidModels =
            Generator.getAddresses(SimpleAddressItem.class, MainActivity.LOOP_COUNT);

    long startTime = System.currentTimeMillis();
    // Reuse method so we don't have to write
    TransactionManager.transact(ActiveAndroid.getDatabase(), new Runnable() {
        @Override
        public void run() {
            Saver.saveAll(activeAndroidModels);
        }
    });
    EventBus.getDefault().post(new LogTestDataEvent(startTime, FRAMEWORK_NAME, MainActivity.SAVE_TIME));

    startTime = System.currentTimeMillis();
    Collection<SimpleAddressItem> activeAndroidModelLoad =
            new Select().from(SimpleAddressItem.class).execute();
    EventBus.getDefault().post(new LogTestDataEvent(startTime, FRAMEWORK_NAME, MainActivity.LOAD_TIME));

    new Delete().from(SimpleAddressItem.class).execute();
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public void deleteWaypointAt(int order) {
    if (order == WaypointModel.START_WAYPOINT_ORDER || order == WaypointModel.END_WAYPOINT_ORDER) {
        // Do not allow deleting the start or end point
        throw new IllegalArgumentException("Not allowed to delete the start or end point");
    }

    new Delete().from(WaypointModel.class)
                .where(WaypointContract.Columns.ROUTE + " = ?", getId())
                .and(WaypointContract.Columns.ORDER + " = ?", order)
                .execute();

    new Update(WaypointModel.class)
            .set(WaypointContract.Columns.ORDER + " = " + WaypointContract.Columns.ORDER + " - 1")
            .where(String.format("%s = ? AND %s > ? AND %s <> ?",
                            WaypointContract.Columns.ROUTE, WaypointContract.Columns.ORDER, WaypointContract.Columns.ORDER),
                    getId(), order, WaypointModel.END_WAYPOINT_ORDER)
            .execute();
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public void deleteScreen(final Screen screen, Observer<Object> observer) {
    Observable.create(new Observable.OnSubscribe<Object>() {
        @Override
        public void call(Subscriber<? super Object> subscriber) {
            new Delete().from(ScreenRelation.class)
                    .where("parent = ? OR child = ?", screen.getId())
                    .execute();
            new Delete().from(Screen.class)
                    .where(Screen._ID + " = ?", screen.getId())
                    .execute();
            subscriber.onNext(null);
            subscriber.onCompleted();
        }
    }).subscribeOn(Schedulers.io())
            .observeOn(AndroidSchedulers.mainThread())
            .subscribe(observer);
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public void removeRelation(final Screen parentScreen, final Screen childScreen, Observer<Integer> observer) {
    Observable.create(new Observable.OnSubscribe<Integer>() {
        @Override
        public void call(Subscriber<? super Integer> subscriber) {
            int count = new Select().from(ScreenRelation.class)
                    .where("parent = ? and child = ?", parentScreen.getId(), childScreen.getId())
                    .count();
            if(count > 0) {
                new Delete().from(ScreenRelation.class)
                        .where("parent = ? and child = ?", parentScreen.getId(), childScreen.getId())
                        .execute();
            }
            subscriber.onNext(count);
            subscriber.onCompleted();
        }
    }).subscribeOn(Schedulers.io())
            .observeOn(AndroidSchedulers.mainThread())
            .subscribe(observer);
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public void logout() {
    AddJam.log(Log.INFO, TAG, "Logging out");

    // Remove account
    AccountManager accountManager = AccountManager.get(getApplicationContext());
    Account[] accounts = accountManager.getAccountsByType(CyclingAuthenticator.ACCOUNT_TYPE);
    if (accounts.length > 0) {
        Account account = accounts[0];
        accountManager.removeAccount(account, null, null);
    }

    // Delete stored details
    new Delete().from(User.class).execute();
    new Delete().from(Month.class).execute();

    // Start sign in activity
    Intent startSignIn = new Intent(this, SignInActivity.class);
    startSignIn.addFlags(Intent.FLAG_ACTIVITY_NEW_TASK | Intent.FLAG_ACTIVITY_CLEAR_TASK);
    startActivity(startSignIn);
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
public List<Release> getRecentlyPlayed() {
    ArrayList<Release> releases = new ArrayList<Release>();
    //get the user preference on recently played size
    int size = 50;
    try {
        String items = PreferenceManager.getDefaultSharedPreferences(mContext).getString("recently_played_size", "50");
        size = Integer.parseInt(items);
    } catch(NumberFormatException ex) {}
    List<RecentlyPlayed> recent = new Select().from(RecentlyPlayed.class).limit(size).orderBy("timestamp DESC").execute();
    //create release list and store the oldest timestamp
    long minTimestamp = 0;
    for(RecentlyPlayed r : recent) {
        releases.add(r.getRelease());
        minTimestamp=r.timestamp;
    }
    //do some cleanup while we're at it: remove all recently played items with timestamp < oldest timestamp of valid results
    new Delete().from(RecentlyPlayed.class).where("timestamp < ?", minTimestamp).execute();
    return releases;
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
/**
 * Obter a Lista de todas as palestras disponíveis.
 * 
 * @return Lista de Palestras.
 */
public static List<Keynote> refresh() {
	KeynoteService service = ServiceFactory.getKeynoteService();
	List<Keynote> keynotes = service.list(1L);

	ActiveAndroid.beginTransaction();
	new Delete().from(Keynote.class).execute();

	try {
		for (Keynote keynote : keynotes) {
			keynote.save();
		}
		ActiveAndroid.setTransactionSuccessful();
	} finally {
		ActiveAndroid.endTransaction();
	}

	return keynotes;
}
 

import com.activeandroid.query.Delete; //导入依赖的package包/类
@AfterPut
@ServerModel
void saveTokenAndUser() {

    if (success == 1) {

        loggedUser.setCurrent(true);
        loggedUser.save();

        new Delete().from(Token_.class).execute();
        token.save();
    }

}