public void addValue(DeweyID deweyID, String value, int parentCID) throws IOException, Exception {
// we may have problem here
// maybe we should update previously inserted attributes instead of insert new one
// FOR ATTrib Values (Actually they are behaved the same as text contents)
// text contents are not added to element index,thier CID shouldn be Zero
// elemIndex.insert(0,deweyID);
// bTreeIndex.insert(deweyID,-1,value);
logManager.LogManager.log(6, value);
logManager.LogManager.log(6, "Value: " + deweyID.toString());
try {
if (con != null) {
String sqlQuery =
"INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\" , \"Value\") VALUES (?, ? ,?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
pst.setString(3, value);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
// structSumIndex.add(-1,value,parentCID);THIS IS NOT NEEDED!
// checkBufPool();
}
public StructuralSummaryNode next() throws IOException, DBException // for Iterator
{
// read record from file
// transform into ssNode
int CID;
int qNameLen;
String qName;
byte[] qNameSeq;
int parentCID;
StructuralSummaryNode currentNode = new StructuralSummaryNode();
int nextPage; // needed in case that data is written in more than one page
while (true) {
// if(unTakenNodes!=0 &&XBufferChannel.position()+2*Settings.sizeOfInt<=Settings.pageSize)
// agar dorost bkhunim har bar position sare yek record mi iste:
if (unTakenNodes != 0 && xBufferChannel.position() < freeOffset) {
// bayd daghigh tar chek bshe.
// stroage format in ssIndex: cid(int),qlen(int),qSeq(byte array),parentCId(int)
CID = xBufferChannel.getInt();
logManager.LogManager.log(1, "CID: " + CID);
qNameLen = xBufferChannel.getInt();
int reqSpace = qNameLen + Settings.sizeOfInt;
int capacity = Settings.pageSize - xBufferChannel.position();
if (reqSpace <= capacity) {
qNameSeq = new byte[qNameLen];
xBufferChannel.get(qNameSeq, 0, qNameLen);
qName = new String(qNameSeq);
parentCID = xBufferChannel.getInt();
currentNode.setCID(CID);
currentNode.setParentCID(parentCID);
currentNode.setQName(qName);
unTakenNodes--;
return currentNode; // return breaks loop!
}
} else {
// if(unTakenNodes==0)//in k ghalate baz :(
// { return null; }
// else //if(XBufferChannel.position()+2*Settings.sizeOfInt>Settings.pageSize)
// { //goTOnextPAge;
xBufferChannel.position(Settings.nextPagePos);
nextPage = xBufferChannel.getInt();
bufMngr.unpinBuffer(xBufferChannel);
if (nextPage > 0) {
loadSSPage(nextPage); // prepares XBufferChannel and loads page into it.
// System.out.println("loaded:"+nextPage);
} else return null;
workingPage = nextPage;
xBufferChannel.position(
Settings.dataStartPos); // instead of calling open(somehow opens nextpage)
// }
}
} // end while
}
public HashMap checkBufPool() {
logManager.LogManager.log(0, "Checking bufPool status");
return bufMgr.getPoolStatus();
}
public void add(int CID, String qName, int parentCID) throws IOException, DBException {
boolean keyFound = false;
byte[] qNameArray;
int qLength;
// we need this in case that keys being added exceed page size:
// storage format in ssIndex: cid(int),qlen(int),qSeq(byte array),parentCId(int)
qNameArray = qName.getBytes();
qLength = qNameArray.length; // qname only
xBufferChannel.position(freeOffset); // Every Iteration it must be set.
int capacity = Settings.pageSize - freeOffset;
int reqSpace = qLength + 3 * Settings.sizeOfInt;
if (reqSpace <= capacity) {
xBufferChannel.putInt(CID); // CID
// logManager.LogManager.log(0,"QNAME: "+ qName);
// logManager.LogManager.log(0,"Position: "+ xBufferChannel.position());
xBufferChannel.putInt(qLength);
xBufferChannel.put(qNameArray, 0, qLength);
xBufferChannel.putInt(parentCID); // parentCId
numOfKeys++;
freeOffset += (qLength + 3 * Settings.sizeOfInt);
} else {
// must add page
// twinNode=new BTreeNode(indexName,(byte)0,(byte)1, -1);//numOfKeys is not valid yet
XBufferChannel hlpr = bufMngr.getFreePage();
workingPage = hlpr.getPageNumber();
logManager.LogManager.log(5, "Structural Sum P: " + workingPage);
// numOfKeys=keysAdded;
// unTakenRecs=numOfKeys;maybe we need this in the future
xBufferChannel.position(Settings.nextPagePos);
xBufferChannel.putInt(workingPage);
// if(workingPage==19995)
// logManager.LogManager.log(5, "nextPage:19915"+"workingPage:
// "+xBufferChannel.getPageNumber());
xBufferChannel.position(Settings.freeOffsetPos); // not needed
xBufferChannel.putInt(freeOffset);
// if(freeOffset==511)
// logManager.LogManager.log(5,"freeOffset: "+ freeOffset);
xBufferChannel.position(Settings.numOfKeysPos);
xBufferChannel.putInt(numOfKeys);
// if(numOfKeys==26)
// logManager.LogManager.log(5,"numOfKeys: "+ numOfKeys);
bufMngr.unpinBuffer(xBufferChannel, true);
changeWorkingPageTo(hlpr);
// write remaining record:
xBufferChannel.putInt(CID); // CID
xBufferChannel.putInt(qLength);
xBufferChannel.put(qNameArray, 0, qLength);
xBufferChannel.putInt(parentCID); // parentCId
numOfKeys++;
freeOffset += (qLength + 3 * Settings.sizeOfInt);
}
// unTakenRecs=numOfKeys;maybe we need this in the future
// here nexP should be -1 cause there is no page after!
xBufferChannel.position(Settings.freeOffsetPos);
xBufferChannel.putInt(freeOffset);
xBufferChannel.position(Settings.numOfKeysPos);
xBufferChannel.putInt(numOfKeys);
/// bufMngr.unpinBuffer(xBufferChannel, true);
}