/test/edu/ucsb/nceas/metacattest/QueryResultBuilderTest.java - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 3567

Added by Jing Tao over 16 years ago

Add code to initialize Options and some code clean up

     	/** Return field value in xml_returnfield table*/
     	private String[] returnFieldString = {"dataset/title", "entityName", "individualName/surName", "keyword"};
     	/** Return field id value for above return field string in xml_returnfield*/
     	private int returnFieldId = 4;
     	private int returnFieldId =11;
     	static
+    	  {
-...
+        {
             TestSuite suite = new TestSuite();
             suite.addTest(new QueryResultBuilderTest("initialize"));
             //suite.addTest(new QueryResultBuilderTest("testBuildRecords"));
             suite.addTest(new QueryResultBuilderTest("testBuildRecords"));
             return suite;
+        }
-...
         /**
          * Test how long it will take to build records in xml_queryresult table
          * Tests how long it will take to build records in xml_queryresult table
          */
         public void testBuildRecords() throws Exception
+        {
             double start = System.currentTimeMillis()/1000;
             DBConnection dbconn = DBConnectionPool.getDBConnection("DBQuery.findDocuments");
             int serialNumber = dbconn.getCheckOutSerialNumber();
             String sql = "SELECT docid, nodedata from xml_path_index where path like ?";
             String sql = "SELECT docid, nodedata, path FROM xml_path_index WHERE path IN (";
             PreparedStatement pstmt = null;
             ResultSet result = null;
             //Gets the document information such as doctype, docname and et al
             Hashtable docsInformation = getDocumentsInfo();
             //The key of the hash is docid, the element is the return field value (in xml_format)
             Hashtable table = new Hashtable();
             int size = returnFieldString.length;
             // Loop the return filed value in xml_path_index table and put the docid and value into hashtable
             // Constructs the sql base on the return fields
             boolean first = true;
             for (int i=0; i< size; i++)
+            {
             	if (!first)
+            	{
             		sql=sql+",";
+            	}
             	sql=sql+"'";
             	String path = returnFieldString[i];
             	pstmt = dbconn.prepareStatement(sql);
                 pstmt.setString(1,path);
                 pstmt.execute();
                 result = pstmt.getResultSet();
                 boolean hasNext = result.next();
                 // Get path value for one docid
                 while (hasNext)
+                {
                 	String docid = result.getString(1);
                 	String value = result.getString(2);
                 	StringBuffer buffer  = new StringBuffer();
                 	buffer.append("<param name=\"");
                     buffer.append(path);
                     buffer.append("\">");
                     buffer.append(value);
                     buffer.append("</param>");
                     String xmlValue = buffer.toString();
                     //If the hashtable already has key for this docid,
                     //we should append obove value to the old value
                 	if (table.containsKey(docid))
+                	{
                 		String oldValue = (String)table.get(docid);
                 		String newValue = oldValue+xmlValue;
                 		table.put(docid, newValue);
+                	}
                 	else
+                	{
                 		table.put(docid, xmlValue);
+                	}
                 	hasNext = result.next();
+                }
                 result.close();
                 pstmt.close();
             	 sql = sql+path;
             	 sql=sql+"'";
             	 first = false;
+            }
             sql = sql+")";
             System.out.println("The final sql is "+sql);
         	pstmt = dbconn.prepareStatement(sql);
             pstmt.execute();
             result = pstmt.getResultSet();
             boolean hasNext = result.next();
             // Gets returning value for docids and puts them into hashtable
             while (hasNext)
+            {
             	String docid = result.getString(1);
             	String value = result.getString(2);
             	String path  = result.getString(3);
             	// Gets document information from document information hash table.
             	String docInfo = (String)docsInformation.get(docid);
             	StringBuffer buffer  = new StringBuffer();
             	if (docInfo != null)
+            	{
             		buffer.append(docInfo);
+            	}
             	buffer.append("<param name=\"");
                 buffer.append(path);
                 buffer.append("\">");
                 buffer.append(value);
                 buffer.append("</param>");
                 String xmlValue = buffer.toString();
                 //If the hashtable already has key for this docid,
                 //we should append obove value to the old value
             	if (table.containsKey(docid))
+            	{
             		String oldValue = (String)table.get(docid);
             		String newValue = oldValue+xmlValue;
             		table.put(docid, newValue);
+            	}
             	else
+            	{
             		table.put(docid, xmlValue);
+            	}
             	hasNext = result.next();
+            }
             result.close();
             pstmt.close();
             // Insert the hashtable value into xml_queryresult table
             Enumeration docids = table.keys();
             while (docids.hasMoreElements())
-...
             DBConnectionPool.returnDBConnection(dbconn, serialNumber);
             assertTrue(1 == 1);
+        }
         /*
          * Gets a Hashtable which contains documents' information.
          * The key of this Hashtable is docid. The element value is the information, like
          * docid, docname,doctype and et al. This method will be used in testBuildRecords
          * method to combine a completed return information for query.
          */
         private Hashtable getDocumentsInfo() throws Exception
+        {
         	DBConnection dbconn = DBConnectionPool.getDBConnection("DBQuery.findDocuments");
             int serialNumber = dbconn.getCheckOutSerialNumber();
             String sql = "SELECT docid, rev, docname, doctype, date_created,date_updated from xml_documents";
             PreparedStatement pstmt = null;
             ResultSet result = null;
             //The key of the hash is docid, the element is the document information (in xml_format)
             Hashtable table = new Hashtable();
             pstmt = dbconn.prepareStatement(sql);
             pstmt.execute();
             result = pstmt.getResultSet();
             boolean hasNext = result.next();
             // Get  values from the xml_document table
             while (hasNext)
+            {
             	String             docid = result.getString(1);
             	int                      rev = result.getInt(2);
             	String        docname = result.getString(3);
             	String         doctype = result.getString(4);
             	String   createDate = result.getString(5);
             	String updateDate = result.getString(6);
             	String completeDocid = docid
                                  + MetaCatUtil.getOption("accNumSeparator");
                 completeDocid += rev;
                 // Put everything into a string buffer
                 StringBuffer document = new StringBuffer();
                 document.append("<docid>").append(completeDocid).append("</docid>");
                 if (docname != null)
+                {
                     document.append("<docname>" + docname + "</docname>");
+                }
                 if (doctype != null)
+                {
                    document.append("<doctype>" + doctype + "</doctype>");
+                }
                 if (createDate != null)
+                {
                     document.append("<createdate>" + createDate + "</createdate>");
+                }
                 if (updateDate != null)
+                {
                   document.append("<updatedate>" + updateDate + "</updatedate>");
+                }
                 String information = document.toString();
                 // Put the docid and info into Hashtable
                 table.put(docid, information);
                 hasNext = result.next();
+            }
             result.close();
             pstmt.close();
             return table;
+        }
+    }

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 3567

Added by Jing Tao over 16 years ago