How to create an index under CBL Android 2.0 DB018

Marten · November 2, 2017, 2:18pm

Please provide a basic example which shows the usage of createIndex(String name, Index index) from Database.java in DB018. Especially how to use Index.java.

jens · November 3, 2017, 12:21am

The TravelSample sample code provides such an example.

priya.rajagopal · November 3, 2017, 2:36pm

Here is an example of creating a FTS index from Travel Sample App -

github.com

couchbaselabs/mobile-travel-sample/blob/connect_sv/android/app/src/main/java/com/couchbase/travelsample/util/DatabaseManager.java#L76


        InputStream inputStream = assetManager.open(filename);
        File outFile = new File(context.getFilesDir(), filename);
        FileOutputStream out = new FileOutputStream(outFile);
        copyFile(inputStream, out);
        unpackZip(context.getFilesDir().getPath() + "/", filename);
    } catch (IOException e) {
        e.printStackTrace();
    }
}


private void createFTSQueryIndex() {
    try {
        database.createIndex("descFTSIndex", Index.ftsIndex().on(FTSIndexItem.expression(Expression.property("description"))));
    } catch (CouchbaseLiteException e) {
        e.printStackTrace();
    }
}


private static boolean unpackZip(String path, String zipname)
{
    InputStream is;

Marten · November 3, 2017, 2:47pm

Thank you!

And how can I achieve something different than an FTS index?
For example a huge list of dates.

priya.rajagopal · November 3, 2017, 3:17pm

It’s very similar. You create a value index

For example, this creates an index on “type” property

    database.createIndex("typeIndex",Index.valueIndex().on(ValueIndexItem.expression(Expression.property("type"))));

jay · November 7, 2017, 2:59pm

Is it possible to create an index on two fields?

jay · November 7, 2017, 4:03pm

Actually I found it. Thanks