package scrap;

import java.io.File;

import org.dizitart.no2.Document;
import org.dizitart.no2.IndexOptions;
import org.dizitart.no2.IndexType;
import org.dizitart.no2.Nitrite;
import org.dizitart.no2.NitriteCollection;
import org.dizitart.no2.NitriteId;
import org.dizitart.no2.UpdateOptions;
import org.dizitart.no2.WriteResult;
import org.dizitart.no2.filters.Filters;

public class NitriteIndexNull {

    public static void main(String[] args) {
        File dbFile = new File("/tmp/nitrite.db");
        if(dbFile.exists()) {
            dbFile.delete();
        }
        //create database
        Nitrite nitrite = Nitrite.builder().filePath("/tmp/nitrite.db").openOrCreate();
        //create collection
        NitriteCollection collection = nitrite.getCollection("col");
        //add a record
        Document doc = Document.createDocument("FIELD1", "ABC");
        doc.put("FIELD2", null);
        WriteResult result = collection.update(Filters.eq("FIELD1", "ABC"), doc, UpdateOptions.updateOptions(true, true));
        //get the ID        
        Long id = result.iterator().next().getIdValue();
        //create an indexed field
        collection.createIndex("FIELD2", IndexOptions.indexOptions(IndexType.Fulltext));
        //get document back out
        doc = collection.getById(NitriteId.createId(id));
        //insert a null into the field
        doc.put("FIELD2", null);
        collection.update(Filters.eq("FIELD1", "ABC"), doc, UpdateOptions.updateOptions(true, true));
        //update the null field with an value
        doc.put("FIELD2", "DEF");
        collection.update(Filters.eq("FIELD1", "ABC"), doc, UpdateOptions.updateOptions(true, true));
    }

}