!752

lib 1004017 // Berkeley DB

import com.sleepycat.je.DatabaseException;
import com.sleepycat.je.Environment;
import com.sleepycat.je.EnvironmentConfig;

import com.sleepycat.persist.EntityStore;
import com.sleepycat.persist.StoreConfig;

import com.sleepycat.persist.model.Entity;
import com.sleepycat.persist.model.PrimaryKey;
import com.sleepycat.persist.model.SecondaryKey;
import static com.sleepycat.persist.model.Relationship.MANY_TO_ONE;

import com.sleepycat.je.DatabaseException;
import com.sleepycat.persist.EntityStore;
import com.sleepycat.persist.PrimaryIndex;
import com.sleepycat.persist.SecondaryIndex;

public static class SimpleDA {
    // Open the indices
    public SimpleDA(EntityStore store)
        throws DatabaseException {

        // Primary key for ExampleEntity classes
        pIdx = store.getPrimaryIndex(
            String.class, ExampleEntity.class);

        // Secondary key for ExampleEntity classes
        // Last field in the getSecondaryIndex() method must be
        // the name of a class member; in this case, an 
        // ExampleEntity.class data member.
        sIdx = store.getSecondaryIndex(
            pIdx, String.class, "aSecondaryKey");
    }

    // Index Accessors
    PrimaryIndex<String,ExampleEntity> pIdx;
    SecondaryIndex<String,String,ExampleEntity> sIdx;
} 

@Entity
public static class ExampleEntity {
    // The primary key must be unique in the database.
    @PrimaryKey
    private String aPrimaryKey;

    @SecondaryKey(relate=MANY_TO_ONE)
    private String aSecondaryKey;
    
    void setPKey(S x) { aPrimaryKey = x; }
    void setSKey(S x) { aSecondaryKey = x; }
} 

p {
  Environment myEnv;
  EntityStore store;
  
  bool readOnly = false;
  File envHome = mkdir(getProgramDir("#1004019"));
  
  print("Opening Berkely DB in " + envHome.getAbsolutePath());

  EnvironmentConfig myEnvConfig = new EnvironmentConfig();
  StoreConfig storeConfig = new StoreConfig();

  myEnvConfig.setAllowCreate(!readOnly);
  storeConfig.setAllowCreate(!readOnly);

  // Open the environment and entity store
  myEnv = new Environment(envHome, myEnvConfig);
  store = new EntityStore(myEnv, "EntityStore", storeConfig);
  
  print("Retrieving stuff");
  
  SimpleDA da = new SimpleDA(store);
  
  ExampleEntity sec1 = da.pIdx.get("keyone");
  ExampleEntity sec2 = da.pIdx.get("keytwo");
  
  print("keyone => " + structure(sec1));
  print("keytwo => " + structure(sec2));
        
  print("Closing");
  
  if (store != null)
    store.close();
  if (myEnv != null)
    myEnv.close();
}