Metacat

// No copyright, no warranty; use as you will.

// Written by Ronald Bourret, Technical University of Darmstadt, 1998-9

import de.tudarmstadt.ito.domutils.DF_Oracle;

import de.tudarmstadt.ito.domutils.NQ_Oracle;

import de.tudarmstadt.ito.xmldbms.DBMSToDOM;

import de.tudarmstadt.ito.xmldbms.DOMToDBMS;

import de.tudarmstadt.ito.xmldbms.Map;

import de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl;

import de.tudarmstadt.ito.xmldbms.mapfactories.MapFactory_MapDocument;

import java.io.File;

import java.io.FileOutputStream;

import java.io.OutputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import oracle.xml.parser.XMLParser;

import oracle.xml.parser.XMLDocument;

import org.xml.sax.InputSource;

import org.xml.sax.Parser;

import org.w3c.dom.Document;

/**

 * This application accepts a map document name, an XML document name, and

 * (in the case of transferring data from the database to an XML document) a

 * table name and key value. It transfers data in the specified direction.

 *

 * <P>The command line syntax for this application is:</P>

 * <PRE>

 *    java Transfer {-todbms|-toxml} <map-file> <xml-file> [<table-name> <key-value>...]

 * </PRE>

 *

 * <P>where:</P>

 *

 *    -todbms | -toxml indicates the direction of data transfer

 *    <map-file> is the name of the XML-DBMS map document

 *    <xml-file> is the name of the input or output XML document

 *    <table-name> is the name of the table containing the data to retrieve

 *       (-toxml direction only)

 *    <key-value>... is one or more values in a (multi-part) key

 *       (-toxml direction only)

 *

 * <P>For this application to work, there must be an ODBC data source named

 * "xmldbms" and the Oracle parser must be installed. The tables used to store

 * data must have already been created in the data source. If the map document

 * specifies that keys are to be generated, the default KeyGenerator

 * implementation is used; for more information, see

 * de.tudarmstadt.ito.xmldbms.helper.KeyGeneratorImpl.</P>

 */

public class Transfer

{

   public static void main (String[] argv)

   {

      String   mapFilename = null,

               xmlFilename = null,

               url = "jdbc:odbc:xmldbms",

               tableName = null;

      Object[] key = null;

      boolean  toxml;

      try

      {

         if (argv.length < 3) throw new IllegalArgumentException();

         if ((!argv[0].equals("-todbms")) && (!argv[0].equals("-toxml")))

            throw new IllegalArgumentException();

         toxml = (argv[0].equals("-toxml"));

         mapFilename = argv[1];

         xmlFilename = argv[2];

         if (toxml)

         {

            if (argv.length < 5) throw new IllegalArgumentException();

            tableName = argv[3];

            key = new Object[argv.length - 4];

            for (int i = 4; i < argv.length; i++)

            {

               key[i - 4] = argv[i];

            }

         }

         if (toxml)

         {

            toXML(mapFilename, xmlFilename, url, tableName, key);

         }

         else

         {

            toDBMS(mapFilename, xmlFilename, url);

         }

      }

      catch (IllegalArgumentException iae)

      {

         System.out.println("\nUsage: java Transfer {-todbms|-toxml} <map-file> <xml-file> [<table-name> <key-value>...]\n<table-name> and <key-value> are required when -toxml is chosen.\n");

      }

      catch (Exception e)

      {

         e.printStackTrace();

      }

   }

   static void toDBMS(String mapFilename, String xmlFilename, String url)

      throws Exception

   {

      Connection       conn1, conn2;

      Map              map;

      Document         doc;

      DOMToDBMS        domToDBMS;

      KeyGeneratorImpl keyGenerator = null;

      // Connect to the database

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      conn1 = DriverManager.getConnection(url);

      conn2 = DriverManager.getConnection(url);

      // Create and initialize a key generator

      keyGenerator = new KeyGeneratorImpl(conn1);

      keyGenerator.initialize();

      // Create the map, open the XML document, and transfer the data

      // to the database

      map = createMap(mapFilename, conn2);

      doc = openDocument(xmlFilename);

      domToDBMS = new DOMToDBMS(map, keyGenerator, new NQ_Oracle());

      domToDBMS.storeDocument(doc);

   }

   static void toXML(String mapFilename, String xmlFilename, String url, String tableName, Object[]key)

      throws Exception

   {

      Connection       conn;

      Map              map;

      DBMSToDOM        dbmsToDOM;

      Document         doc;

      FileOutputStream xmlFile;

      // Connect to the database

      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      conn = DriverManager.getConnection(url);

      // Create the Map and transfer the data to a DOM tree.

      map = createMap(mapFilename, conn);

      dbmsToDOM = new DBMSToDOM(map, new DF_Oracle());

      doc = dbmsToDOM.retrieveDocument(tableName, key);

      // Write the DOM tree to a file.

      // WARNING! This code is specific to the Oracle parser.

      xmlFile = new FileOutputStream(xmlFilename);

      ((XMLDocument)doc).print((OutputStream)xmlFile);

      xmlFile.close();

   }

   static Document openDocument(String xmlFilename) throws Exception

   {

      XMLParser parser;

      // WARNING! This code is specific to the Oracle parser.

      // Instantiate the parser and set various options.

      parser = new XMLParser();

      parser.showWarnings(true);

      // Parse the input file

      parser.parse(new InputSource(getFileURL(xmlFilename)));

      // Return the DOM tree

      return parser.getDocument();

   }

   static Map createMap(String mapFilename, Connection conn) throws Exception

   {

      MapFactory_MapDocument factory;

      XMLParser              parser;

      // Instantiate the parser and set various options

      // WARNING! This code is specific to the Oracle parser.

      parser = new XMLParser();

      parser.setValidationMode(true);

      parser.showWarnings(true);

      // Create a new map factory and create the Map. This code is not specific

      // to the Oracle parser -- any SAX Parser will do.

      factory = new MapFactory_MapDocument(conn, parser);

      return factory.createMap(new InputSource(getFileURL(mapFilename)));

   }

   static String getFileURL(String fileName)

   {

      File   file;

      String path, separator;

      file = new File(fileName);

      return "file:///" + file.getAbsolutePath();

   }

}