Android Open Source - sqlite-provider Uri Query Builder

• Back to SQLite/provider  ↑

From Project

Back to project page sqlite-provider.

License

The source code is released under:

Apache License

Java Source Code

package novoda.rest.database;
/* w  ww  . j a  v a  2  s .  com*/
import android.database.sqlite.SQLiteQueryBuilder;
import android.net.Uri;

import java.util.*;

public class UriQueryBuilder extends SQLiteQueryBuilder {

    private List<String> pathSegments;

    private Uri uri;

    public UriQueryBuilder(final Uri uri) {
        this.setUri(uri);
    }

    public static SQLiteQueryBuilder fromUri(final Uri uri) {
        return new UriQueryBuilder(uri);
    }

    public String getTable() {
        if (isDirectory()) {
            return pathSegments.get(pathSegments.size() - 1);
        }
        return pathSegments.get(pathSegments.size() - 2);
    }

    public boolean isDirectory() {
        return (pathSegments.size() % 2 == 1);
    }

    public boolean isOneToMany() {
        return (pathSegments.size() > 2);
    }

    public final void setUri(Uri uri) {
        this.uri = uri;
        init();
    }

    private void init() {
        pathSegments = new ArrayList<String>(Arrays.asList(uri.getPath().split("/")));
        pathSegments.remove(0);
        setTables(getTable());
    }

    public String getWhere() {
        StringBuffer buf = new StringBuffer();
        if (!isDirectory()) {
            buf.append(getPKColumn()).append("=").append(pathSegments.get(pathSegments.size() - 1));
        }
        if (isOneToMany()) {
            if (!isDirectory()) {
                buf.append(" AND ");
            }
            buf.append(getFKColumn()).append("=").append(pathSegments.get(pathSegments.size() - 3));
        }
        return buf.toString();
    }

    private String getPKColumn() {
        return "_id";
    }

    private String getFKColumn() {
        return pathSegments.get(pathSegments.size() - 4) + "_id";
    }

    public Uri getUri() {
        return uri;
    }
}

Java Source Code List

• Back to SQLite/provider  ↑