Changeset 6357

Timestamp:

2004-01-06T17:03:24+13:00 (20 years ago)

Author:

kjdon

Message:

fixed a bug and added retrieval for some classification stuff

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java (modified) (11 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/util/SQLQuery.java

@@ -6 +6 @@
 import java.sql.ResultSet;
 import java.sql.SQLException;
+
+import java.util.ArrayList;
+
 public class SQLQuery {
     GS3SQLConnection connection = null;
@@ -26 +29 @@
 
     public String MGNum2OID(int mg_num) {
+    System.out.println("converting mg num to oid "+mg_num);
     // get doc id and meta id
     String query = "select "+ 
@@ -49 +53 @@
     } catch (java.sql.SQLException e) {
 
-        System.err.println("somethings went wrong with sql "+e.getMessage());
+        System.err.println("something went wrong with sql getting doc_id and meta_id: "+e.getMessage());
         return null;
     }
@@ -60 +64 @@
         " where "+GSSQL.DIVISION_METADATA_TABLE+GSSQL.DOT+GSSQL.METADATA_ID+GSSQL.EQUALS_QUOTE+meta_id+GSSQL.QUOTE+
         " and "+GSSQL.DIVISION_METADATA_TABLE+GSSQL.DOT+GSSQL.DOCUMENT_ID+GSSQL.EQUALS_QUOTE+doc_id+GSSQL.QUOTE+
+        " and "+GSSQL.DIVISION_METADATA_TABLE+GSSQL.DOT+GSSQL.DIVISION_REF+GSSQL.EQUALS+GSSQL.DIVISION_TABLE+GSSQL.DOT+GSSQL.DIVISION_REF+
         GSSQL.END;
 
@@ -71 +76 @@
     } catch (java.sql.SQLException e) {
 
-        System.err.println("somethings went wrong with sql "+e.getMessage());
-        return null;
-    }
-
-    System.out.println("short label = "+short_label);
-
-    System.out.println("doc_id = "+doc_id+"."+short_label);
+        System.err.println("something went wrong with sql getting division label: "+e.getMessage());
+        return null;
+    }
+
+    ///ystem.out.println("short label = "+short_label);
+
+    System.out.println("final doc_id = "+doc_id+"."+short_label);
     return doc_id+"."+short_label;
     }
@@ -83 +88 @@
     public int OID2MGNum(String oid) {
     
-    String id = getMetadata(oid, "gsdl3.mgseqno");
+    String id = getDocumentMetadata(oid, "gsdl3.mgseqno");
     System.out.println("mg id = "+id);
     return Integer.parseInt(id);
@@ -89 +94 @@
     }
 
-    public String getMetadata(String oid, String full_meta_name) {
+    // classifier metadata is not actually metadata
+    public String getClassifierMetadata(String oid, String full_meta_name) {
+
+    if (full_meta_name.equals("Title")) {
+        // get the description
+        String query = "select "+ GSSQL.DESCRIPTION+
+        " from " + GSSQL.CLASSIFIER_TABLE +
+        " where " + GSSQL.CLASSIFIER_ID + GSSQL.EQUALS_QUOTE + oid + GSSQL.QUOTE +
+        GSSQL.END;
+        
+        connection.execute(query);
+        ResultSet results = null;
+        String value = null;
+        try {
+        results = connection.getResultSet();
+        results.first();
+        value = results.getString(GSSQL.DESCRIPTION);
+        } catch (java.sql.SQLException e) {
+        
+        System.err.println("something went wrong with sql "+e.getMessage());
+        return null;
+        }
+        return value;
+ 
+    } else if (full_meta_name.equals("numleafdocs")) {
+        // get the number of documents
+        return "2";
+
+    } else return null;
+    
+    }
+    
+    public ArrayList getClassifierChildren(String oid) {
+
+    ArrayList children = new ArrayList();
+
+    String query = "select "+ GSSQL.CLASSIFIER_ID +
+        " from " + GSSQL.CLASSIFIER_TABLE +
+        " where " + GSSQL.PARENT_ID + GSSQL.EQUALS_QUOTE + oid + GSSQL.QUOTE +
+        GSSQL.END; 
+    
+    connection.execute(query);
+    ResultSet results = null;
+    try {
+        results = connection.getResultSet();
+        while (results.next()) {
+        String id = results.getString(GSSQL.CLASSIFIER_ID);
+        children.add(id);
+        }
+    } catch (java.sql.SQLException e) {
+        
+        System.err.println("something went wrong with sql "+e.getMessage());
+        return null;
+    }
+    return children;
+    }
+
+     public ArrayList getClassifierDocChildren(String oid) {
+
+    ArrayList children = new ArrayList();
+
+    String query = "select "+ GSSQL.CLASS_DOCUMENT_TABLE+GSSQL.DOT+ GSSQL.DOCUMENT_ID+
+        " from " + GSSQL.CLASSIFIER_TABLE + GSSQL.COMMA+GSSQL.CLASS_DOCUMENT_TABLE+
+        " where " + GSSQL.CLASSIFIER_TABLE +GSSQL.DOT+ GSSQL.PARENT_ID + GSSQL.EQUALS_QUOTE + oid + GSSQL.QUOTE +
+        " and " + GSSQL.CLASSIFIER_TABLE +GSSQL.DOT+ GSSQL.CLASSIFIER_REF+GSSQL.EQUALS+GSSQL.CLASS_DOCUMENT_TABLE+GSSQL.DOT+ GSSQL.CLASSIFIER_REF+
+        GSSQL.END;
+    
+    connection.execute(query);
+    ResultSet results = null;
+    try {
+        results = connection.getResultSet();
+        while (results.next()) {
+        String id = results.getString(GSSQL.DOCUMENT_ID);
+        children.add(id);
+        }
+    } catch (java.sql.SQLException e) {
+        
+        System.err.println("something went wrong with sql: "+e.getMessage());
+        return null;
+    }
+    // now check for documents
+    
+    return children;
+    }
+    
+    public String getDocumentMetadata(String oid, String full_meta_name) {
 
     String doc_id = oid;
@@ -101 +191 @@
     System.out.println("get meta for "+oid+", doc id = "+doc_id+"sec id = "+section_id);
 
-    // get teh metadata block id
+    // get the metadata block id
     String query = "select "+ 
         GSSQL.DIVISION_METADATA_TABLE+GSSQL.DOT+GSSQL.METADATA_ID +
@@ -120 +210 @@
     } catch (java.sql.SQLException e) {
 
-        System.err.println("somethings went wrong with sql "+e.getMessage());
+        System.err.println("something went wrong with sql "+e.getMessage());
         return null;
     }
@@ -173 +263 @@
     
     System.out.println("title metadata for mg num 3:");
-    String meta = self.getMetadata(oid, "gsdl3.title");
+    String meta = self.getDocumentMetadata(oid, "gsdl3.title");
     if (meta != null) {System.out.println(meta);}
     System.out.println("subject metadata for mg num 3:");
-    meta = self.getMetadata(oid, "gsdl3.Subject");
+    meta = self.getDocumentMetadata(oid, "gsdl3.Subject");
     if (meta != null) {System.out.println(meta);}
 
@@ -188 +278 @@
 
     System.out.println("title metadata for mg num 8:");
-    meta = self.getMetadata(oid, "gsdl3.title");
+    meta = self.getDocumentMetadata(oid, "gsdl3.title");
     if (meta != null) {System.out.println(meta);}
     System.out.println("subject metadata for mg num 8:");
-    meta = self.getMetadata(oid, "gsdl3.Subject");
+    meta = self.getDocumentMetadata(oid, "gsdl3.Subject");
     if (meta != null) {System.out.println(meta);}