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 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;

 */

public class DBTransform {

  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

   */

                  throws IOException,

                         SQLException,

  {

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

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

   *            String targetType, String qformat, PrintWriter pw,

   *            String sessionid)

   */

  public void transformXMLDocument(String doc, String sourceType,

                Hashtable param)

  /**

   *

   * @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, Hashtable param,

                                   String sessionid)

      try {

        Transformer transformer = tFactory.newTransformer(

        //MetaCatUtil.debugMessage("qformat: "+qformat, 30);

        if(sessionid != null)

        {

          transformer.setParameter("sessid", sessionid);

        }

        {

          while (en.hasMoreElements())

          {

            String key =(String)en.nextElement();

            String value = ((String[])(param.get(key)))[0];

            MetaCatUtil.debugMessage(key+" : "+value, 30);

            transformer.setParameter(key, value);

          }

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

    } else {

  }

   * @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 sessionid) {

    // 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("sessid", sessionid);

        }

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

                              new StreamResult(pw));

      } catch (Exception e) {

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

                   "DBTransform.transformXMLDocument: " +

    } else {

  }

   *            String targetType, String qFormat, StringWriter pw

   *            String sessionid)

   */

  public void transformXMLDocument(String doc, String sourceType,

                String targetType, String qFormat, StringWriter pw)

  {

    transformXMLDocument(doc, sourceType, targetType, qFormat, pw, null);

  }

  /**

   * @param f the file to parse

   * @param path the path to get the content from

   */

    if(f == null)

    {

      return null;

    }

    InputSource in;

    FileInputStream fs;

      in = new InputSource(fs);

    }

    catch(FileNotFoundException fnf)

    {

      fnf.printStackTrace();

      return null;

    }

    {

      parser.parse(in);

      fs.close();

    }

    catch(Exception e1)

    {

      return null;

    }

    {

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

      return docNodeList;

    }

    catch(Exception se)

    {

      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

   */

    String systemId = null;

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

      qformat = defaultStyle;

    }

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

    try {

      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;

                  }

                }

            }

            {

              break;

            }

        }

        {

          break;

        }

    }

    {

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

      e.printStackTrace();

    }

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

  }

  /**

   * Lookup a stylesheet reference from the db catalog

   *

   * @param sourcetype the document type of the source

   * @param targettype the document type of the target

   */

    // Look up the System ID of a particular object

    int serialNumber = -1;

                  getDBConnection("DBTransform.getSystemId");

      serialNumber=dbConn.getCheckOutSerialNumber();

                "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());

        } catch (SQLException e) {

        }

      } catch (SQLException e) {

      }

      pstmt.close();

    } catch (SQLException e) {

    {

      try

      {

        pstmt.close();

      }//try

      catch (SQLException sqlE)

      {

        MetaCatUtil.debugMessage("Error in DBTransform.getSystemId: "

                                   +sqlE.getMessage(), 30);

      }//catch

      finally

      {

        DBConnectionPool.returnDBConnection(dbConn, serialNumber);

      }//finally

    }//finally

  }

  /**

   * the main routine used to test the transform utility.

   *

  static public void main(String[] args) {

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

     } else {

        try {

          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

                                   "-//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);

        }

     }

  }

  }