Changeset 5944 for trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentSQLWriter.java

Timestamp:

2003-11-24T14:26:35+13:00 (20 years ago)

Author:

cs025

Message:

Index document type, metadata extensions

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentSQLWriter.java (modified) (1 diff)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/doctypes/DocumentSQLWriter.java

@@ -25 +25 @@
     // put the document into the database
     try {
-    if (document.getID() != null)
+      if (document.getID() != null)
       { //tag = XMLTools.addAttribute(tag, "OBJID", document.getID().toString());
-      GS3SQLInsert insert = new GS3SQLInsert("document");
+    GS3SQLSelect select = new GS3SQLSelect("document");
+    select.addField("*");
+    select.setWhere(new GS3SQLWhere(new GS3SQLWhereItem("DocID", "=", document.getID().toString())));
+    connection.execute(select.toString());
+    
+    ResultSet results = connection.getResultSet();
+
+    if (results == null ||
+        !results.first())
+    { GS3SQLInsert insert = new GS3SQLInsert("document");
       insert.addValue("DocID", document.getID().toString());
+      insert.addValue("DocType", document.getDocumentType());
 
-      System.out.println(insert.toString());
       connection.execute(insert.toString());
+    }
       }
     } catch (Exception ex) {