DbBaseOperate.java

package com.susion.boring.db.operate;

import android.content.Context;
import android.util.Log;

import com.litesuits.orm.LiteOrm;
import com.litesuits.orm.db.assit.QueryBuilder;
import com.susion.boring.music.mvp.model.SimpleSong;

import java.util.List;

import rx.Observable;
import rx.Subscriber;

/**
 * Created by susion on 17/2/20.
 * 数据库操作的基类
 * 运用关系型数据库: lite-orm-1.9.2
 */
public class DbBaseOperate<T> implements DataBaseOperateContract.BaseOperate<T> {

    private Class<T> mClass;
    protected LiteOrm mLiteOrm;
    protected Context mContext;

    private DbBaseOperate(LiteOrm mLiteOrm, Context mContext) {
        this.mLiteOrm = mLiteOrm;
        this.mContext = mContext;
    }

    public DbBaseOperate(LiteOrm mLiteOrm, Context mContext, Class c) {
        this(mLiteOrm, mContext);
        mClass = c;
    }

    @Override
    public Observable<List<T>> add(final List<T> objects) {
        return Observable.create(new Observable.OnSubscribe<List<T>>() {
            @Override
            public void call(Subscriber<? super List<T>> subscriber) {
                for (T song : objects) {
                    mLiteOrm.save(song);
                }
                subscriber.onNext(objects);
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<Boolean> add(final T t) {
        return Observable.create(new Observable.OnSubscribe<Boolean>() {
            @Override
            public void call(Subscriber<? super Boolean> subscriber) {
                if (mLiteOrm.save(t) > 0) {
                    subscriber.onNext(true);
                } else {
                    subscriber.onNext(false);
                }
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<Boolean> update(final T t) {
        return Observable.create(new Observable.OnSubscribe<Boolean>() {
            @Override
            public void call(Subscriber<? super Boolean> subscriber) {
                if (mLiteOrm.update(t) > 0) {
                    subscriber.onNext(true);
                } else {
                    subscriber.onNext(false);
                }
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<Boolean> delete(final T song) {
        return Observable.create(new Observable.OnSubscribe<Boolean>() {
            @Override
            public void call(Subscriber<? super Boolean> subscriber) {
                if (mLiteOrm.delete(song) > 0) {
                    subscriber.onNext(true);
                } else {
                    subscriber.onNext(false);
                }
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<Boolean> clearALLData() {
        return Observable.create(new Observable.OnSubscribe<Boolean>() {
            @Override
            public void call(Subscriber<? super Boolean> subscriber) {
                if (mLiteOrm.deleteAll(mClass) > 0) {
                    subscriber.onNext(true);
                } else {
                    subscriber.onNext(false);
                }
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<T> query(final String id) {
        return Observable.create(new Observable.OnSubscribe<T>() {
            @Override
            public void call(Subscriber<? super T> subscriber) {
                T song = (T) mLiteOrm.queryById(id, mClass);
                if (song != null) {
                    subscriber.onNext(song);
                } else {
                    subscriber.onNext(null);
                }
                subscriber.onCompleted();

            }
        });
    }

    @Override
    public Observable<Long> getTotalCount() {
        return Observable.create(new Observable.OnSubscribe<Long>() {
            @Override
            public void call(Subscriber<? super Long> subscriber) {
                long count = mLiteOrm.queryCount(mClass);
                subscriber.onNext(count);
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<List<T>> getAll() {
        return Observable.create(new Observable.OnSubscribe<List<T>>() {
            @Override
            public void call(Subscriber<? super List<T>> subscriber) {
                subscriber.onNext(mLiteOrm.query(mClass));
                subscriber.onCompleted();
            }
        });
    }

    @Override
    public Observable<List<T>> getLikeData() {
        return Observable.create(new Observable.OnSubscribe<List<T>>() {
            @Override
            public void call(Subscriber<? super List<T>> subscriber) {
                List<T> likes = mLiteOrm.query(new QueryBuilder<>(mClass).whereEquals("favorite", true));
                subscriber.onNext(likes);
            }
        });
    }
}