Java Inquiry类代码示例

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
@Override
public void onDone() {
    if (Utils.get(this).getDbVersion() == -1) {
        onDone();
        return;
    }

    Inquiry.newInstance(this, DATABASE_NAME).databaseVersion(Utils.get(this).getDbVersion()).build();

    Inquiry.get(this)                                                       // Get db
            .selectFrom("icons", App.class)                                 // Get table "icons"
            .where("componentName NOT LIKE ?", "%.")                        // Get all app with component name that not ends with "."
            .sortByAsc("label")                                             // Sort them by label ascending
            .all(new GetCallback<App>() {
                @Override
                public void result(@Nullable App[] apps) {
                    if (apps == null) {
                        appendLine(getString(R.string.apps_not_found), false);
                        return;
                    }

                    mLoadedApps = apps;
                    new LoadApps().execute();
                }
            });
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
public static void saveDb(
    @Nullable final Context context, @Nullable final WallpapersHolder holder) {
  if (context == null || holder == null || holder.length() == 0) {
    return;
  }
  final String iname = "save_walldb_instance";
  Inquiry.newInstance(context, DATABASE_NAME)
      .databaseVersion(DATABASE_VERSION)
      .instanceName(iname)
      .build();
  try {
    Inquiry.get(iname).delete(Wallpaper.class).run();
    Inquiry.get(iname)
        .insert(Wallpaper.class)
        .values(holder.wallpapers)
        .run(changed -> Inquiry.destroy(iname));
  } catch (Throwable t) {
    t.printStackTrace();
  }
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
public static void initializeBlacklist(Context context) {
    if (PrefUtils.isFirstRun(context)) {

        AppInfo[] defaultBlacklistApps = new AppInfo[DEFAULT_BLACKLISTED_APPS.length];
        for (int i = 0; i < DEFAULT_BLACKLISTED_APPS.length; i++) {
            String packageName = DEFAULT_BLACKLISTED_APPS[i];
            AppInfo appInfo = new AppInfo();
            appInfo.packageName = packageName;
            defaultBlacklistApps[i] = appInfo;
        }

        Inquiry.get().insertInto(TABLE_BLACKLISTED_APPS, AppInfo.class)
                .values(defaultBlacklistApps)
                .run();

        PrefUtils.setFirstRun(context, false);
    }
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
@Override
protected void onPause() {
    super.onPause();

    if (isFinishing()) {
        Inquiry.destroy(this);
    }
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
@Override
protected Boolean doInBackground(Void... voids) {
    for (int i = 0; i < mChangedApps.size(); i++) {
        Integer app = mChangedApps.get(i);
        Inquiry.get(MainActivity.this)
                .update("icons", App.class)
                .where("componentName = ?", mLoadedApps[app].componentName)
                .projection("icon", "icon_low_res")
                .values(mLoadedApps[app])
                .run();

        publishProgress(i);
    }
    return true;
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
/**
 * Returns true if the item is currently favorited.
 */
public static boolean isBookmarked(String id) {
    return Inquiry.get()
            .selectFrom(Constants.DATABASE_NAME, BookmarksDB.class)
            .where("_id = ?", id)
            .one() != null;
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
/**
 * Returns true if the item was favorited successfully.
 */
public static boolean bookmark(String id) {

    init(context);

    if (!isBookmarked(id)) {
        Inquiry.get()
                .insertInto(Constants.DATABASE_NAME, BookmarksDB.class)
                .values(new BookmarksDB(id))
                .run();
        return true;
    } else unbookmark(id);

    return false;
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
/**
 * Returns true if the item was unfavorited successfully.
 */
public static boolean unbookmark(String id) {
    if (isBookmarked(id)) {
        Inquiry.get()
                .deleteFrom(Constants.DATABASE_NAME, BookmarksDB.class)
                .where("_id = ?", id)
                .run();
        return true;
    } else bookmark(id);

    return false;
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
protected LazyLoaderList(
    Inquiry inquiry,
    String tableName,
    String foreignColumnName,
    String inverseFieldName,
    Object row,
    Class<?> childType) {
  this.inquiry = inquiry;
  this.tableName = tableName;
  this.foreignColumnName = foreignColumnName;
  this.inverseFieldName = inverseFieldName;
  this.row = row;
  this.childType = childType;
  items = new ArrayList<>();
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
public static void insertUpdateColor(WebsiteToolbarColor websiteToolbarColor) {
    //noinspection ResourceType
    if (getColor(websiteToolbarColor.hostDomain) == NOT_FOUND) {
        Inquiry.get()
                .insertInto(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
                .values(websiteToolbarColor)
                .run();
    } else {
        Inquiry.get()
                .update(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
                .where("host_domain = ?", websiteToolbarColor.hostDomain)
                .values(websiteToolbarColor)
                .run();
    }
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
@ColorInt
public static int getColor(String url) {
    try {
        WebsiteToolbarColor websiteToolbarColor = Inquiry.get()
                .selectFrom(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
                .where("host_domain = ?", url)
                .one();
        if (websiteToolbarColor != null) {
            return websiteToolbarColor.toolbarColor;
        }

        if (url.startsWith("www.")) {
            url = url.substring(4);
            return getColor(url);
        } else {
            websiteToolbarColor = Inquiry.get()
                    .selectFrom(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
                    .where("host_domain = ?", "www." + url)
                    .one();
            //noinspection ResourceAsColor
            return websiteToolbarColor != null ? websiteToolbarColor.toolbarColor : NOT_FOUND;
        }
    } catch (Exception e) {
        Crashlytics.logException(e);
    }
    //noinspection ResourceAsColor
    return NOT_FOUND;
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
public static void cleanup() {
    WebsiteToolbarColor[] all = Inquiry.get()
            .selectFrom(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
            .all();
    if (all != null) {
        long current = System.currentTimeMillis();
        for (WebsiteToolbarColor color : all) {
            if (color.expireTimestamp < current) {
                Inquiry.get().deleteFrom(TABLE_TOOLBAR_COLOR, WebsiteToolbarColor.class)
                        .where("host_domain = ?", color.hostDomain)
                        .run();
            }
        }
    }
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
@Override
public void onCreate() {
    super.onCreate();

    if (!BuildConfig.DEBUG) {
        Fabric.with(this, new Crashlytics());
    }

    LeakCanary.install(this);

    Inquiry.init(this, DB, 1);

    Glide.get(this)
            .register(AppInfo.class, InputStream.class, new AppIconLoader.Factory());
    Glide.get(this)
            .register(Uri.class, InputStream.class, new FaviconLoader.Factory());

    JobManager.create(this)
            .addJobCreator(new JobCreator() {
                @Override
                public Job create(String tag) {
                    switch (tag) {
                        case CleanupJob.TAG:
                            return new CleanupJob();
                        default:
                            throw new RuntimeException("Cannot find job for tag " + tag);
                    }
                }
            });

    JobManager.instance().cancelAll();

    new JobRequest.Builder(CleanupJob.TAG)
            //1 day
            .setPeriodic(86400000)
            .build()
            .schedule();
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
/**
 * Returns sorted list of AppInfos.
 * <p/>
 * AppInfo's drawable and id are null
 */
@NonNull
public static Single<List<AppInfo>> getPerAppListApps(final Context context) {
    return Single.create(new Single.OnSubscribe<List<AppInfo>>() {
        @Override
        public void call(SingleSubscriber<? super List<AppInfo>> singleSubscriber) {
            String table = PrefUtils.isBlacklistMode(context) ? TABLE_BLACKLISTED_APPS : TABLE_WHITELISTED_APPS;

            AppInfo[] all = Inquiry.get().selectFrom(table, AppInfo.class)
                    .all();
            if (all != null) {
                singleSubscriber.onSuccess(new ArrayList<>(Arrays.asList(all)));
            } else {
                singleSubscriber.onSuccess(new ArrayList<AppInfo>());
            }
        }
    }).subscribeOn(Schedulers.io())
            .flatMapObservable(new Func1<List<AppInfo>, Observable<AppInfo>>() {
                @Override
                public Observable<AppInfo> call(List<AppInfo> appInfos) {
                    return Observable.from(appInfos);
                }
            }).flatMap(new Func1<AppInfo, Observable<AppInfo>>() {
                @Override
                public Observable<AppInfo> call(AppInfo appInfo) {
                    try {
                        final ApplicationInfo info = context.getPackageManager().getApplicationInfo(appInfo.packageName, 0);
                        appInfo.name = info.loadLabel(context.getPackageManager()).toString();

                        return Observable.just(appInfo);
                    } catch (PackageManager.NameNotFoundException e) {
                        e.printStackTrace();
                        return Observable.empty();
                    }
                }
            }).toSortedList().toSingle();
}
 

import com.afollestad.inquiry.Inquiry; //导入依赖的package包/类
private void refresh() {
  int permission =
      ContextCompat.checkSelfPermission(this, Manifest.permission.READ_EXTERNAL_STORAGE);
  if (permission != PackageManager.PERMISSION_GRANTED) {
    ActivityCompat.requestPermissions(
        this, new String[]{Manifest.permission.READ_EXTERNAL_STORAGE}, PERMISSION_RC);
    return;
  }

  //noinspection VisibleForTests
  Inquiry.get(this)
      .selectFrom(Uri.parse("content://media/external/images/media"), Photo.class)
      .sort("datetaken DESC")
      .where("_data IS NOT NULL")
      .all(
          photos -> {
            if (isFinishing()) {
              return;
            }
            if (empty != null) {
              adapter.setPhotos(photos);
              empty.setVisibility(
                  photos == null || photos.length == 0 ? View.VISIBLE : View.GONE);
              if (photos != null && photos.length > 0 && autoSelectFirst) {
                adapter.shiftSelections();
                adapter.setSelected(1, true);
                autoSelectFirst = false;
              }
            }
          });
}