Changeset 6100

Timestamp:

2003-12-03T09:38:12+13:00 (20 years ago)

Author:

cs025

Message:

Added generic GS2 textfile handler, classifier tables to database

Location:

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/util

Files:

• GS2TextFileHandler.java (added)
• GS3SQLConnection.java (modified) (5 diffs)

trunk/gsdl3/src/java/org/greenstone/gsdl3/gs3build/util/GS3SQLConnection.java

@@ -177 +177 @@
       // create document table
       GS3SQLCreateTable docTable = new GS3SQLCreateTable("document");
-      docTable.addProperty("DocID", 64);
-      docTable.setPrimaryKey("DocID");
-      docTable.addProperty("DocType", 64);
+      docTable.addProperty("DocID", 64);   // The document identifer, unique in collection
+      docTable.setPrimaryKey("DocID");     // ...which is also the primary key
+      docTable.addProperty("DocType", 64); // The document type - used to regenerate the
+                                           // correct Document object type.
       statement = this.connection.createStatement();
-      System.out.println(docTable.toString());
       statement.execute(docTable.toString());
       
@@ -187 +187 @@
       GS3SQLCreateTable structureMap = new GS3SQLCreateTable("structure");
       structureMap.addAutoPrimaryKey("StructureRef");
-      structureMap.addProperty("DocID", 64);        // a 'foreign key' in effect - but not treated
-      // as such for efficiency reasons
-      structureMap.addProperty("StructureID", 64);  // this identifier
-      structureMap.addProperty("StructureType", 64);         // the type of the structure
-      structureMap.addProperty("Label", 128);       // the label of the structure
+      structureMap.addProperty("DocID", 64);          // a 'foreign key' in effect - but not treated
+                                                      // as such for efficiency reasons
+      structureMap.addProperty("StructureID", 64);    // this identifier
+      structureMap.addProperty("StructureType", 64);  // the type of the structure
+      structureMap.addProperty("Label", 128);         // the label of the structure
       statement.execute(structureMap.toString());
     
@@ -199 +199 @@
       sectionMap.addProperty("StructureRef", GS3SQLField.INTEGER_TYPE);
       sectionMap.addProperty("DocID", 64);        // a 'foreign key' in effect - but not treated
-      // as such for efficiency reasons
-      sectionMap.addProperty("ParentType", 64);     // the type of the parent - document or section
-      sectionMap.addProperty("ParentRef", 64);      // the parent sql reference identifier
-      sectionMap.addProperty("SectionID", 64);      // this identifier
-      sectionMap.addProperty("DivisionType", 64);           // the type of the section
+                                                  // as such for efficiency reasons
+      sectionMap.addProperty("ParentType", 64);   // the type of the parent - document or section
+      sectionMap.addProperty("ParentRef", 64);    // the parent sql reference identifier
+      sectionMap.addProperty("SectionID", 64);    // this identifier
+      sectionMap.addProperty("DivisionType", 64); // the type of the section
       sectionMap.addProperty("LabelOrder", 64);   // the order of the section
       sectionMap.addProperty("ShortLabel", 128);  // the short label of the section
       sectionMap.addProperty("UserLabel", 255);   // the long label of the section
-      System.out.println(sectionMap.toString());
       statement.execute(sectionMap.toString());
 
@@ -232 +231 @@
       metadataSection.addProperty("MetaID", 64);  // in and of itself...
       metadataSection.addProperty("GroupID", 64); // the 'name' property
-      System.out.println(metadataSection.toString());
       statement.execute(metadataSection.toString());
       
@@ -284 +282 @@
       
       //   create admin table...etc.
+
+      // 
+      // END OF METS TABLES
+      //
+
+      //
+      // BEGINNING OF GSDL TABLES
+      //
+      GS3SQLCreateTable classifiers = new GS3SQLCreateTable("classifiers");
+      classifiers.addAutoPrimaryKey("ClassifyRef");
+      classifiers.addProperty("ClassifyID");
+      classifiers.addProperty("ParentID");
+      classifiers.addProperty("Name");
+      classifiers.addProperty("Description");
+      statement.execute(classifiers.toString());
+
+      GS3SQLCreateTable classDocs = new GS3SQLCreateTable("classdocuments");
+      classDocs.addProperty("ClassifyRef", GS3SQLField.INTEGER_TYPE);
+      classDocs.addProperty("DocID");
+      statement.execute(classDocs.toString());
+
+      GS3SQLCreateTable classData = new GS3SQLCreateTable("classdata");
+      classData.addProperty("ClassifyRef", GS3SQLField.INTEGER_TYPE);
+      classData.addProperty("Label");
+      classData.addProperty("Value");
+      statement.execute(classData.toString());
+
+      //
+      // END OF GSDL TABLES
+      //
+
     }
     catch (SQLException ex)