SampleDatabase.java [plain text]
package com.sleepycat.examples.bdb.shipment.factory;
import com.sleepycat.db.Db;
import com.sleepycat.db.DbEnv;
import com.sleepycat.bdb.ForeignKeyIndex;
import com.sleepycat.bdb.DataIndex;
import com.sleepycat.bdb.DataStore;
import com.sleepycat.bdb.StoredClassCatalog;
import com.sleepycat.bdb.factory.TupleSerialDbFactory;
import java.io.FileNotFoundException;
import java.io.IOException;
public class SampleDatabase {
private static final String CLASS_CATALOG = "java_class_catalog";
private static final String SUPPLIER_STORE = "supplier_store";
private static final String PART_STORE = "part_store";
private static final String SHIPMENT_STORE = "shipment_store";
private static final String SHIPMENT_PART_INDEX = "shipment_part_index";
private static final String SHIPMENT_SUPPLIER_INDEX =
"shipment_supplier_index";
private static final String SUPPLIER_CITY_INDEX = "supplier_city_index";
private DbEnv env;
private DataStore supplierStore;
private DataStore partStore;
private DataStore shipmentStore;
private DataIndex supplierByCityIndex;
private ForeignKeyIndex shipmentByPartIndex;
private ForeignKeyIndex shipmentBySupplierIndex;
private StoredClassCatalog javaCatalog;
private TupleSerialDbFactory factory;
public SampleDatabase(String homeDirectory, boolean runRecovery)
throws Exception {
int envFlags = Db.DB_INIT_TXN | Db.DB_INIT_LOCK | Db.DB_INIT_MPOOL |
Db.DB_CREATE;
if (runRecovery) envFlags |= Db.DB_RECOVER;
env = new DbEnv(0);
System.out.println("Opening environment in: " + homeDirectory);
env.open(homeDirectory, envFlags, 0);
int flags = Db.DB_CREATE | Db.DB_AUTO_COMMIT;
javaCatalog = new StoredClassCatalog(env, CLASS_CATALOG, null, flags);
factory = new TupleSerialDbFactory(javaCatalog);
Db partDb = new Db(env, 0);
partDb.open(null, PART_STORE, null, Db.DB_BTREE, flags, 0);
partStore = factory.newDataStore(partDb, Part.class, null);
Db supplierDb = new Db(env, 0);
supplierDb.open(null, SUPPLIER_STORE, null, Db.DB_BTREE, flags, 0);
supplierStore = factory.newDataStore(supplierDb, Supplier.class, null);
Db shipmentDb = new Db(env, 0);
shipmentDb.open(null, SHIPMENT_STORE, null, Db.DB_BTREE, flags, 0);
shipmentStore = factory.newDataStore(shipmentDb, Shipment.class, null);
Db cityIndexDb = new Db(env, 0);
cityIndexDb.setFlags(Db.DB_DUPSORT);
cityIndexDb.open(null, SUPPLIER_CITY_INDEX, null, Db.DB_BTREE,
flags, 0);
supplierByCityIndex = factory.newDataIndex(supplierStore,
cityIndexDb, Supplier.CITY_KEY,
false, true);
Db partIndexDb = new Db(env, 0);
partIndexDb.setFlags(Db.DB_DUPSORT);
partIndexDb.open(null, SHIPMENT_PART_INDEX, null, Db.DB_BTREE,
flags, 0);
shipmentByPartIndex = factory.newForeignKeyIndex(shipmentStore,
partIndexDb, Shipment.PART_KEY,
false, true, partStore,
ForeignKeyIndex.ON_DELETE_CASCADE);
Db supplierIndexDb = new Db(env, 0);
supplierIndexDb.setFlags(Db.DB_DUPSORT);
supplierIndexDb.open(null, SHIPMENT_SUPPLIER_INDEX, null, Db.DB_BTREE,
flags, 0);
shipmentBySupplierIndex = factory.newForeignKeyIndex(shipmentStore,
supplierIndexDb,
Shipment.SUPPLIER_KEY,
false, true, supplierStore,
ForeignKeyIndex.ON_DELETE_CASCADE);
}
public final TupleSerialDbFactory getFactory() {
return factory;
}
public final DbEnv getEnvironment() {
return env;
}
public final DataStore getPartStore() {
return partStore;
}
public final DataStore getSupplierStore() {
return supplierStore;
}
public final DataStore getShipmentStore() {
return shipmentStore;
}
public final ForeignKeyIndex getShipmentByPartIndex() {
return shipmentByPartIndex;
}
public final ForeignKeyIndex getShipmentBySupplierIndex() {
return shipmentBySupplierIndex;
}
public final DataIndex getSupplierByCityIndex() {
return supplierByCityIndex;
}
public void close()
throws Exception {
partStore.close();
supplierStore.close();
shipmentStore.close();
javaCatalog.close();
env.close(0);
}
}