Changeset 32518

Timestamp:

2018-10-16T13:52:48+13:00 (6 years ago)

Author:

ak19

Message:

Untested first attempt at MySQLPlugout that is meant to write metadata and/or fulltext to a mysql db rather than to doc.xml. We're switching over to using perl mysql libs, dbd (mysql) for drivers and dbi (mysql), for db access. However, I still want to commit this initial attempt at manually doing database operations in perl.

Location:

main/trunk/greenstone2

Files:

• bin/script/import.pl (modified) (1 diff)
• perllib/docprint.pm (modified) (1 diff)
• perllib/plugouts/MySQLPlugout.pm (added)
• perllib/strings.properties (modified) (2 diffs)

main/trunk/greenstone2/bin/script/import.pl

@@ -88 +88 @@
       { 'name' => "GreenstoneMETS",
         'desc' => "{export.saveas.GreenstoneMETS}"},
+      { 'name' => "MySQL",
+        'desc' => "{export.saveas.MySQL}"},
+      { 'name' => "MySQL_metadata_only",
+        'desc' => "{export.saveas.MySQL.meta_only}"},
+      { 'name' => "MySQL_fulltext_only",
+        'desc' => "{export.saveas.MySQL.text_only}"},
       ];
 

main/trunk/greenstone2/perllib/docprint.pm

@@ -67 +67 @@
     $all_text .= "  <Description>\n";
 
+    # scalar comparisons on a constant is allowed (but not string evaluation of scalars)
+    # https://www.perlmonks.org/?node_id=559456
     if($options->{'output'} == OUTPUT_ALL || $options->{'output'} == OUTPUT_META_ONLY) {
     # output metadata

main/trunk/greenstone2/perllib/strings.properties

@@ -417 +417 @@
 
 export.saveas.GreenstoneXML:Greenstone XML Archive format
+export.saveas.MySQL:Save metadata and text in MySQL database
+export.saveas.MySQL.meta_only:Store metadata in MySQL database (and full text in Greenstone XML Archive format)
+export.saveas.MySQL.text_only:Store full text in MySQL database (and metadata in Greenstone XML Archive format)
 
 export.saveas.MARCXML:MARC XML format (an XML version of MARC 21)
@@ -1440 +1443 @@
 METSPlugout.xslt_mets:Transform a mets's docmets.xml with the XSLT in the named file.  
 
+MySQLPlugout.desc:Output metadata and/or full text to a MySQL database instead of doc.xml.
+MySQLPlugout.process_mode:Setting determines whether full text and/or metadata will be output to a MySQL database instead of to doc.xml during import.
+MySQLPlugout.process_mode.all:Import stage outputs the full text and metadata to a MySQL database instead of to doc.xml.
+MySQLPlugout.process_mode.meta_only:Import stage outputs the metadata to a MySQL database and any text to doc.xml.
+MySQLPlugout.process_mode.text_only:Import stage outputs the full text to a MySQL database and any metadata to doc.xml.
+
+
 #
 # Perl module strings