Metacat

/**

 *    Purpose: A Class that transforms an XML text document

 *             into a another type using XSL

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Matt Jones

 *     '$Date$'

 * '$Revision$'

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

package edu.ucsb.nceas.metacat;

import java.io.*;

import java.net.URL;

import java.net.MalformedURLException;

import java.sql.*;

import java.util.Stack;

import javax.xml.transform.Transformer;

import javax.xml.transform.stream.StreamSource;

import javax.xml.transform.stream.StreamResult;

import javax.xml.transform.TransformerException;

import javax.xml.transform.TransformerConfigurationException;

import org.apache.xerces.parsers.DOMParser;

import org.w3c.dom.Attr;

import org.w3c.dom.NamedNodeMap;

import org.w3c.dom.NodeList;

import org.w3c.dom.Document;

import org.w3c.dom.Node;

import org.w3c.dom.NodeList;

import org.w3c.dom.DocumentType;

import org.xml.sax.SAXException;

import org.xml.sax.InputSource;

import org.apache.xerces.dom.DocumentTypeImpl;

import org.apache.xpath.XPathAPI;

import org.w3c.dom.NamedNodeMap;

/*

import oracle.xml.parser.v2.XSLException;

import oracle.xml.parser.v2.XMLDocument;

import oracle.xml.parser.v2.DOMParser;

import org.w3c.dom.Node;

import org.w3c.dom.Element;

import org.xml.sax.SAXException;

/**

 * A Class that transforms XML documents utitlizing XSL style sheets

 */

public class DBTransform {

  private Connection	conn = null;

  private String 	configDir = null;

  private String	defaultStyle = null;

  /**

   * construct a DBTransform instance.

   *

   * Generally, one calls transformXMLDocument() after constructing the instance

   *

   * @param conn the database connection from which to lookup the public ids

   */

  public DBTransform( Connection conn )

                  throws IOException,

                         SQLException,

                         ClassNotFoundException

  {

    this.conn = conn;

    configDir = util.getOption("config-dir");

    defaultStyle = util.getOption("default-style");

  /**

   * Transform an XML document using the stylesheet reference from the db

   *

   * @param doc the document to be transformed

   * @param sourcetype the document type of the source

   * @param targettype the target document type

   * @param pw the PrintWriter to which output is printed

                String targetType, String qformat, PrintWriter pw) {

      try {

        Transformer transformer = tFactory.newTransformer(

        transformer.setParameter("qformat", qformat);

                              new StreamResult(pw));

    } else {

      // No stylesheet registered form this document type, so just return the

      // XML stream we were passed

  }

   * Transform an XML document to StringWriter using the stylesheet reference

   * from the db

   * @param doc the document to be transformed

   * @param sourceType the document type of the source

   * @param targetType the target document type

   * @param qFormat the name of the style set to use

   * @param pw the StringWriter to which output will be stored

   */

  public void transformXMLDocument(String doc, String sourceType,

                String targetType, String qFormat, StringWriter pw) {

    // Look up the stylesheet for this type combination

    String xslSystemId = getStyleSystemId(qFormat, sourceType, targetType);

    if (xslSystemId != null) {

      // Create a stylesheet from the system id that was found

      try {

        TransformerFactory tFactory = TransformerFactory.newInstance();

        Transformer transformer = tFactory.newTransformer(

                                  new StreamSource(xslSystemId));

        transformer.setParameter("qFormat", qFormat);

        transformer.transform(new StreamSource(new StringReader(doc)),

                              new StreamResult(pw));

      } catch (Exception e) {

        util.debugMessage(xslSystemId + "Error transforming document in " +

                   "DBTransform.transformXMLDocument: " +

                   e.getMessage());

      }

    } else {

      // No stylesheet registered form this document type, so just return the

      // XML stream we were passed

  }

  /**

   * gets the content of a tag in a given xml file with the given path

   * @param f the file to parse

   * @param path the path to get the content from

   */

  public static NodeList getPathContent(File f, String path)

  {

    if(f == null)

    {

      return null;

    }

    DOMParser parser = new DOMParser();

    InputSource in;

    FileInputStream fs;

    try

    {

      fs = new FileInputStream(f);

      in = new InputSource(fs);

    }

    catch(FileNotFoundException fnf)

    {

      fnf.printStackTrace();

      return null;

    }

    try

    {

      parser.parse(in);

      fs.close();

    }

    catch(Exception e1)

    {

      System.err.println("File: " + f.getPath() + " : parse threw: " +

                         e1.toString());

      return null;

    }

    Document doc = parser.getDocument();

    try

    {

      NodeList docNodeList = XPathAPI.selectNodeList(doc, path);

      return docNodeList;

    }

    catch(Exception se)

    {

      System.err.println("file: " + f.getPath() + " : parse threw: " +

                         se.toString());

      return null;

    }

  }

  /**

   * Lookup a stylesheet reference from the db catalog

   *

   * @param sourcetype the document type of the source

   * @param targettype the document type of the target

   */

  public String getStyleSystemId(String qformat, String sourcetype,

                String targettype) {

    String systemId = null;

    if ((qformat == null) || (qformat.equals("html"))) {

      qformat = defaultStyle;

    }

    // Load the style-set map for this qformat into a DOM

    try {

      util.debugMessage("Trying style-set file: " + filename);

      NodeList nlDoctype = getPathContent(f, "/style-set/doctype");

      NodeList nlDefault = getPathContent(f, "/style-set/default-style");

      Node nDefault = nlDefault.item(0);

      systemId = nDefault.getFirstChild().getNodeValue(); //set the default

      { //look for the right sourcetype

        Node nDoctype = nlDoctype.item(i);

        NamedNodeMap atts = nDoctype.getAttributes();

        Node nAtt = atts.getNamedItem("publicid");

        String doctype = nAtt.getFirstChild().getNodeValue();

        if(doctype.equals(sourcetype))

        { //found the right sourcetype now we need to get the target type

          NodeList nlChildren = nDoctype.getChildNodes();

          for(int j=0; j<nlChildren.getLength(); j++)

          {

            Node nChild = nlChildren.item(j);

            String childName = nChild.getNodeName();

            if(childName.equals("target"))

            {

              NamedNodeMap childAtts = nChild.getAttributes();

              Node nTargetPublicId = childAtts.getNamedItem("publicid");

              String target = nTargetPublicId.getFirstChild().getNodeValue();

              if(target.equals(targettype))

              { //we found the right target type

                NodeList nlTarget = nChild.getChildNodes();

                for(int k=0; k<nlTarget.getLength(); k++)

                {

                  Node nChildText = nlTarget.item(k);

                  if(nChildText.getNodeType() == Node.TEXT_NODE)

                  { //get the text from the target node

                    systemId = nChildText.getNodeValue();

                    breakflag = true;

                    break;

                  }

                }

            }

            if(breakflag)

            {

              break;

            }

        }

        if(breakflag)

        {

          break;

        }

    }

    {

      System.out.println("Error parsing style-set file: " + e.getMessage());

      e.printStackTrace();

    }

    // Return the system ID for this particular source document type

    return systemId;

  }

  /**

   * Lookup a stylesheet reference from the db catalog

   *

   * @param sourcetype the document type of the source

   * @param targettype the document type of the target

   */

  public String getSystemId(String objecttype, String sourcetype,

                String targettype) {

    // Look up the System ID of a particular object

    PreparedStatement pstmt;

    String the_system_id = null;

    try {

      pstmt =

        conn.prepareStatement("SELECT system_id " +

                "AND source_doctype = ? " +

                "AND target_doctype = ? ");

      pstmt.setString(2, sourcetype);

      pstmt.setString(3, targettype);

      try {

        ResultSet rs = pstmt.getResultSet();

        try {

          boolean tableHasRows = rs.next();

          if (tableHasRows) {

            try {

              the_system_id = rs.getString(1);

            } catch (SQLException e) {

                                 "DBTransform.getSystemId: " + e.getMessage());

            }

            the_system_id = null;

          }

        } catch (SQLException e) {

                              e.getMessage());

        }

      } catch (SQLException e) {

                            e.getMessage());

      }

      pstmt.close();

    } catch (SQLException e) {

                          e.getMessage());

      return ("Error getting id in DBTransform.getSystemId:: " +

               e.getMessage());

    return the_system_id;

  }

  /**

   * the main routine used to test the transform utility.

   *

  static public void main(String[] args) {

        System.err.println("Wrong number of arguments!!!");

     } else {

        try {

          // Open a connection to the database

          Connection dbconn = util.openDBConnection();

          // Create a test document

          StringBuffer testdoc = new StringBuffer();

          testdoc.append("<?xml version=\"1.0\"?>");

          testdoc.append("<eml-dataset><metafile_id>NCEAS-0001</metafile_id>");

          testdoc.append("<dataset_id>DS001</dataset_id>");

          testdoc.append("<title>My test doc</title></eml-dataset>");

          // Transform the document to the new doctype

          DBTransform dbt = new DBTransform(dbconn);

          dbt.transformXMLDocument(testdoc.toString(),

                                   "-//NCEAS//eml-dataset//EN",

                                   "-//W3C//HTML//EN",

        } catch (Exception e) {

          System.err.println("EXCEPTION HANDLING REQUIRED");

          System.err.println(e.getMessage());

          e.printStackTrace(System.err);

        }

     }

  }

  }