import com.activeandroid.query.Update; //导入依赖的package包/类
/**
 * Update counters after calling this.
 */
public void updateStatusByComplexity(String collectionId, int limit, SentenceStatus fromStatus, SentenceStatus toStatus, String complecityOrder) {
    List<Sentence> sentences = new Select()
            .from(Sentence.class)
            .where("collection_id=? and status=?", collectionId, fromStatus.getStatus())
            .orderBy("complexity " + complecityOrder)
            .limit(limit)
            .execute();

    String[] sentenceIds = new String[sentences.size()];
    for (int i = 0; i < sentences.size(); i++) {
        sentenceIds[i] = sentences.get(i).sentenceId;
    }
    
    new Update(Sentence.class)
            .set("status=?", toStatus.getStatus())
            .where("sentence_id in (" + StringUtils.repeat(",?", sentences.size()).substring(1) + ")", sentenceIds)
            .execute();
}
 

import com.activeandroid.query.Update; //导入依赖的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.Update; //导入依赖的package包/类
public void markAsStart(final Screen screen, Observer<Screen> observer) {
    Observable.create(new Observable.OnSubscribe<Screen>() {
        @Override
        public void call(Subscriber<? super Screen> subscriber) {
            Log.d(TAG, "saving...");
            new Update(Screen.class).set("IsStart = ?", 0)
                    .where("Utree = ?", screen.utree.getId())
                    .execute();
            screen.isStart = 1;
            screen.save();
            Log.d(TAG, "saved");
            subscriber.onNext(screen);
            subscriber.onCompleted();
        }
    }).subscribeOn(Schedulers.io())
            .observeOn(AndroidSchedulers.mainThread())
            .subscribe(observer);
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
public void save(final Screen screen, Observer<Screen> observer) {
    Observable.create(new Observable.OnSubscribe<Screen>() {
        @Override
        public void call(Subscriber<? super Screen> subscriber) {
            if (screen.isStart == 1) {
                new Update(Screen.class).set("IsStart = ?", 0)
                        .where("Utree = ?", screen.utree.getId())
                        .execute();
                screen.isStart = 1;
                screen.save();
            } else if (Screen.getScreens(screen.utree.getId()).size() == 0) {
                screen.isStart = 1;
                screen.save();
            } else {
                screen.save();
            }
            subscriber.onNext(screen);
            subscriber.onCompleted();
        }
    }).subscribeOn(Schedulers.io())
            .observeOn(AndroidSchedulers.mainThread())
            .subscribe(observer);
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
public void addToFavorite(final UpdateFinishCallback callback) {
    IsFav = true;
    new Thread() {
        @Override
        public void run() {
            super.run();
            boolean exist = new Select().from(Animation.class).where("AnimationId='" + AnimationId + "'").executeSingle() != null;
            if (!exist)
                save();
            else
                new com.activeandroid.query.Update(Animation.class).set("IsFavorite='1'").where("AnimationId='" + AnimationId + "'").execute();
            Message msg = Message.obtain();
            Looper.prepare();
            msg.setTarget(new FavoriteHandler(callback, Method.ADD_FAVORITE));
            msg.sendToTarget();
            Looper.loop();
        }
    }.start();
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
public void saveScreen(final Screen screen, final OnScreenDetailsSave event, final View screenContainer, Observer<Screen> observer) {
    Observable.create(new Observable.OnSubscribe<Screen>() {
        @Override
        public void call(Subscriber<? super Screen> subscriber) {
            Log.d(TAG, "saving...");
            if (screen.isStart == 1) {
                Log.d(TAG, "screen.isStart == 1");
                new Update(Screen.class).set("IsStart = ?", 0)
                        .where("Utree = ?", screen.utree.getId())
                        .execute();
                screen.isStart = 1;
                screen.save();
            } else if (Screen.getScreens(screen.utree.getId()).size() == 0) {
                Log.d(TAG, "Screen.getScreens(screen.utree.getId()).size() == 0");
                screen.isStart = 1;
                screen.save();
            } else {
                //WTF?!? need to re-set the values of screen name and details if isStart == 0
                screen.name = event.getName();
                screen.details = event.getContent();
                Log.d(TAG, "screen.save() " + screen.name + " " + screen.details);
                screen.save();
            }

            Log.d(TAG, "saved");
            File screenshotFile = screenContainer.getContext().getFileStreamPath(screen.getScreenshotPath());
            ScreenUtils.saveScreenshot(screenshotFile, screenContainer);
            subscriber.onNext(screen);
            subscriber.onCompleted();
        }
    }).subscribeOn(Schedulers.io())
            .observeOn(AndroidSchedulers.mainThread())
            .subscribe(observer);
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
public void removeFromFavorite(final UpdateFinishCallback callback) {
    IsFav = false;
    new Thread() {
        @Override
        public void run() {
            super.run();
            new Update(Animation.class).set("IsFavorite='0'").where("AnimationId='" + AnimationId + "'").execute();
            Message msg = Message.obtain();
            Looper.prepare();
            msg.setTarget(new FavoriteHandler(callback, Method.REMOVE_FAVORITE));
            msg.sendToTarget();
            Looper.loop();
        }
    }.start();
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
private Update update() {
	return new Update(MockModel.class);
}
 

import com.activeandroid.query.Update; //导入依赖的package包/类
public static void save(Animation animation,M3U8Mission mission){
    DownloadRecord record = new Select()
            .from(DownloadRecord.class)
            .where("AnimationId = ?" , animation.AnimationId)
            .executeSingle();
    if(record == null){
        new DownloadRecord(animation,mission).save();
    }else{
        int status;
        if(mission.isDone()){
            status = mission.isSuccess() ? STATUS.SUCCESS : STATUS.ERROR;
            status = mission.isCanceled() ? STATUS.CANCELED : status;
        }else{
            status = STATUS.DOWNLOADING;
        }
        new Update(DownloadRecord.class)
                        .set("Size = ?," +
                                "DownloadedSize = ?," +
                                "Duration = ?," +
                                "DownloadedDuration = ?," +
                                "Segments = ?," +
                                "DownloadedSegments = ?," +
                                "DownloadedPercentage = ?," +
                                "RangeStart = ?,"+
                                "Status = ?," +
                                "Extra = ?," +
                                "SaveDir = ?," +
                                "SaveFileName = ? ," +
                                "UsingDownloadUrl = ? ",
                        mission.getFilesize(),
                        mission.getDownloaded(),
                        mission.getVideoDuration(),
                        mission.getDownloadedDuration(),
                        mission.getSegmentsCount(),
                        mission.getDownloadedSegmentCount(),
                        mission.getPercentage(),
                        mission.getCurrentSegmentDownloaded(),
                        status,
                        "",
                        mission.getSaveDir(),
                        mission.getSaveName(),
                        mission.getUri())
                .where("AnimationId = ?",animation.AnimationId)
                .execute();
    }
}