Changeset 6515

Timestamp:

2004-01-15T16:59:24+13:00 (20 years ago)

Author:

kjdon

Message:

made the strings final and added some new ones

File:

• trunk/gsdl3/src/java/org/greenstone/gsdl3/util/GSSQL.java (modified) (1 diff)

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

@@ -4 +4 @@
 
     // table names
-    public static String DOCUMENT_TABLE = "document";
-    public static String STRUCTURE_TABLE = "structure";
-    public static String DIVISION_TABLE = "divisions";
-    public static String DIVISION_FILE_TABLE = "divisionfilerefs";
-    public static String DIVISION_METADATA_TABLE = "divisionmetarefs";
-    public static String FILE_SECTION_TABLE = "filesection";
-    public static String FILE_GROUP_TABLE = "filegroups";
-    public static String FILE_TABLE = "files";
-    public static String METADATA_TABLE = "metadata"; 
-    public static String NAMESPACE_TABLE = "namespaces";
-    public static String METADATA_VALUE_TABLE = "mdvalues";
-    public static String CLASSIFIER_TABLE = "classifiers";
-    public static String CLASS_DATA_TABLE = "classdata";
-    public static String CLASS_DOCUMENT_TABLE = "classdocuments";
+    public static final String DOCUMENT_TABLE = "document";
+    public static final String STRUCTURE_TABLE = "structure";
+    public static final String DIVISION_TABLE = "divisions";
+    public static final String DIVISION_FILE_TABLE = "divisionfilerefs";
+    public static final String DIVISION_METADATA_TABLE = "divisionmetarefs";
+    public static final String FILE_SECTION_TABLE = "filesection";
+    public static final String FILE_GROUP_TABLE = "filegroups";
+    public static final String FILE_TABLE = "files";
+    public static final String METADATA_TABLE = "metadata"; 
+    public static final String NAMESPACE_TABLE = "namespaces";
+    public static final String METADATA_VALUE_TABLE = "mdvalues";
+    public static final String CLASSIFIER_TABLE = "classifiers";
+    public static final String CLASS_DATA_TABLE = "classdata";
+    public static final String CLASS_DOCUMENT_TABLE = "classdocuments";
 
     // unique key names - references to the tables
-    public static String METADATA_REF = "MetadataRef";
-    public static String NAMESPACE_REF = "NamespaceRef";
-    public static String STRUCTURE_REF = "StructureRef";
-    public static String DIVISION_REF = "DivisionRef";
-    public static String FILE_SECTION_REF = "FileSectionRef";
-    public static String FILE_GROUP_REF = "FileGroupRef";
-    public static String CLASSIFIER_REF = "ClassifyRef";
+    public static final String METADATA_REF = "MetadataRef";
+    public static final String NAMESPACE_REF = "NamespaceRef";
+    public static final String STRUCTURE_REF = "StructureRef";
+    public static final String DIVISION_REF = "DivisionRef";
+    public static final String FILE_SECTION_REF = "FileSectionRef";
+    public static final String FILE_GROUP_REF = "FileGroupRef";
+    public static final String CLASSIFIER_REF = "ClassifyRef";
     
     // combined refs
-    public static String PARENT_REF = "ParentRef";
-    public static String PARENT_TYPE = "ParentType";
+    public static final String PARENT_REF = "ParentRef";
+    public static final String PARENT_TYPE = "ParentType";
     
-    // other fields - these are unique ids per document - ie combined with docid
-    public static String DOCUMENT_ID = "DocID";
-    public static String METADATA_ID = "MetaID";
-    public static String FILE_ID = "FileID";
-    public static String STRUCTURE_ID = "StructureID";
-    public static String SECTION_ID = "SectionID";
-    public static String FILE_GROUP_ID = "FileID";
-    public static String FILE_SECTION_ID = "FileID";
-    public static String CLASSIFIER_ID = "ClassifyID";
-    public static String PARENT_ID = "ParentID";
+    // id fields - these are unique ids per document - ie combined with docid
+    public static final String DOCUMENT_ID = "DocID";
+    public static final String METADATA_ID = "MetaID";
+    public static final String FILE_ID = "FileID";
+    public static final String STRUCTURE_ID = "StructureID";
+    public static final String SECTION_ID = "SectionID";
+    public static final String FILE_GROUP_ID = "FileID";
+    public static final String FILE_SECTION_ID = "FileID";
+    public static final String CLASSIFIER_ID = "ClassifyID";
+    public static final String PARENT_ID = "ParentID";
     
     // type fields
-    public static String DOC_TYPE = "DocType";
-    public static String NAMESPACE_TYPE = "NamespaceType";
-    public static String STRUCTURE_TYPE = "StructureType";
-    public static String DIVISION_TYPE = "DivisionType";
-    public static String FILE_LOCATION_TYPE = "FileLocType";
-    public static String MIME_TYPE = "MIMEType";
+    public static final String DOC_TYPE = "DocType";
+    public static final String NAMESPACE_TYPE = "NamespaceType";
+    public static final String STRUCTURE_TYPE = "StructureType";
+    public static final String DIVISION_TYPE = "DivisionType";
+    public static final String FILE_LOCATION_TYPE = "FileLocType";
+    public static final String MIME_TYPE = "MIMEType";
 
     // other stuff
-    public static String LABEL = "Label";
-    public static String VALUE = "Value";
-    public static String LABEL_ORDER = "LabelOrder";
-    public static String SHORT_LABEL = "ShortLabel";
-    public static String USER_LABEL = "UserLabel";
-    public static String NAME = "Name";
-    public static String DESCRIPTION = "Description";
-    public static String FILE_LOCATION = "FileLocation";
-    public static String CREATOR = "Creator";
+    public static final String LABEL = "Label";
+    public static final String VALUE = "Value";
+    public static final String LABEL_ORDER = "LabelOrder";
+    public static final String SHORT_LABEL = "ShortLabel";
+    public static final String USER_LABEL = "UserLabel";
+    public static final String NAME = "Name";
+    public static final String DESCRIPTION = "Description";
+    public static final String FILE_LOCATION = "FileLocation";
+    public static final String CREATOR = "Creator";
+    public static final String DOCUMENT_ORDER = "DocOrder";
+    public static final String NUM_LEAF_DOCUMENTS = "NumLeafDocs";
+
+    public static final String COMMA = ",";
+    public static final String EQUALS = "=";
+    public static final String QUOTE = "'";
+    public static final String EQUALS_QUOTE = "='";
+    public static final String DOT = ".";
+    public static final String END = ";";
+    public static final String NOT="!";
+
+    // some values in the fields
+    public static final String STRUCTURE = "Structure";
+    public static final String DIVISION = "Division";
+    public static final String ALL = "All";
+    public static final String MG_NUM = "mgseqno";
     
-    public static String MG_NUM = "mgseqno";
-
-    public static String COMMA = ",";
-    public static String EQUALS = "=";
-    public static String QUOTE = "'";
-    public static String EQUALS_QUOTE = "='";
-    public static String DOT = ".";
-    public static String END = ";";
 }