// public StructuralSummaryIndex(String indexName,int numOfKeys)
// {
// //this.qNameList=qNamelist;
// //this.nodeList=nodeList;
// this.indexName=indexName;
// this.numOfKeys=numOfKeys;
// logicFileMgr = LogicalFileManager.Instance;
// bufMngr = BufferManager.getInstance();
// XBufferChannel=new XBufferChannel();//vasl bshe b buf mgr:getfreepage()
// XBufferChannel.clear();
// }
public StructuralSummaryIndex(int indexPage, String indexName) throws IOException, DBException {
// usage: openning of existing SSIndex object.
this.indexName = indexName;
this.indexPage = indexPage; // always the same
this.workingPage = indexPage; // may change
logicFileMgr = LogicalFileManager.Instance;
bufMngr = BufferManager.getInstance();
xBufferChannel = new XBufferChannel(); // new ham lazem nis //vasl bshe b buf mgr:getfreepage()
// xBufferChannel.clear(); //LaZEM NIs
xBufferChannel = bufMngr.getPage(indexPage); // may change
xBufferChannel.position(Settings.freeOffsetPos); // 5
freeOffset = xBufferChannel.getInt(); // init
xBufferChannel.position(Settings.numOfKeysPos);
numOfKeys = xBufferChannel.getInt(); // init
unTakenNodes = numOfKeys;
}
public StructuralSummaryIndex(String indexName) throws IOException, DBException {
// usage: creation of nonExisting index
this.indexName = indexName;
this.numOfKeys = 0;
nodeList = new ArrayList();
logicFileMgr = LogicalFileManager.Instance;
bufMngr = BufferManager.getInstance();
xBufferChannel = bufMngr.getFreePage();
this.indexPage = createSSIndexPage();
this.workingPage = this.indexPage;
// XBufferChannel=bufMngr.getPage(indexPage);//vasl bshe b buf mgr:getfreepage()
// XBufferChannel.clear();
int keysAdded = 0;
freeOffset = Settings.dataStartPos; // initialize
xBufferChannel.position(Settings.dataStartPos);
}
public BTreeInternalNode(InternalBuffer xBuf, String indexName) {
logicFileMgr = LogicalFileManager.Instance;
this.indexName = indexName;
bufMngr = BufferManager.getInstance();
InternalBuffer = xBuf;
InternalBuffer.position(Settings.freeOffsetPos); // 5
testPos = InternalBuffer.position();
freeOffset = InternalBuffer.getInt();
// byteBuf=xBuf.getByteBuffer();
InternalBuffer.position(Settings.isLeafPos);
testPos = InternalBuffer.position();
isLeaf = InternalBuffer.get();
// InternalBuffer.position(Settings.numOfKeysPos);
numOfKeys = InternalBuffer.getInt();
}
/** @author MohsenCs */
public class PostgreDB {
private String docName; // haman db name
private BTreeIndex bTreeIndex;
private ElementIndex elemIndex;
private StructuralSummaryIndex structSumIndex;
private PostgreDBManager dbdocMgr;
private BufferManager bufMgr = BufferManager.getInstance();
// IndexManager indexMgr;
private List<DeweyID> Deweylist;
private static int num = 0;
private Connection con = null;
public PostgreDB() {}
public PostgreDB(String docName) throws IOException {
dbdocMgr = PostgreDBManager.Instance;
try {
String dbURL = "jdbc:postgresql://localhost:5432/XMLDB";
String userName = "******";
String password = "******";
con = DriverManager.getConnection(dbURL, userName, password);
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
}
public List getDeweyList() {
return Deweylist;
}
public HashMap checkBufPool() {
logManager.LogManager.log(0, "Checking bufPool status");
return bufMgr.getPoolStatus();
}
public void addElement(DeweyID deweyID, String qName, int parentCID, boolean qNameFound)
throws IOException, Exception, SQLException {
try {
if (con != null) {
String sqlQuery = "INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\") VALUES (?, ?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
}
public void addAttribute(DeweyID deweyID, String qName, int parentCID, boolean qNameFound)
throws IOException, Exception {
// parentCID is curNode's CID
// logManager.LogManager.log(6,qName);
// logManager.LogManager.log(6,"Attrib: "+deweyID.toString());
// logManager.LogManager.log(6,String.valueOf(deweyID.getCID()));
// }
// elemIndex.insert(deweyID.getCID(),deweyID);
// bTreeIndex.insert(deweyID,deweyID.getCID(),qName);
if (!qNameFound) {
// structSumIndex.add(deweyID.getCID(),qName,parentCID);
try {
if (con != null) {
String sqlQuery = "INSERT INTO \"OrderedByCID\" (\"CID\", \"DeweyID\") VALUES (?, ?);";
PreparedStatement pst = con.prepareStatement(sqlQuery);
pst.setInt(1, deweyID.getCID());
pst.setString(2, deweyID.toString());
// pst.setString(3, String.v);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
}
// checkBufPool();
}
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 void addContent(DeweyID deweyID, StringBuilder contentBuilder, int parentCID)
throws IOException, Exception {
String content = new String(contentBuilder);
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, content);
pst.executeUpdate();
pst.close();
}
} catch (SQLException e) {
System.out.println("JDBC Driver is not Configured Correctly !");
e.printStackTrace();
return;
}
// text contents are not added to element index,thier CID shouldn be Zero
// elemIndex.insert(0,deweyID);
// bTreeIndex.insert(deweyID,-2,content);
// System.out.println("CID: -2");
// structSumIndex.add(-2,content,parentCID);THIS IS NOT NEEDED
// checkBufPool();
}
public void endOfDocSignal() throws IOException, DBException, SQLException {
structSumIndex.endDoc();
// docMgr.closeDoc(this.docName);
con.close();
}
}
public BufferManager getBufferManager() {
return BufferManager.getInstance();
}