commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jstrac...@apache.org
Subject cvs commit: jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/task JdbcToSchemaTask.java
Date Mon, 28 Oct 2002 16:16:47 GMT
jstrachan    2002/10/28 08:16:47

  Added:       sql/src/java/org/apache/commons/sql/task
                        JdbcToSchemaTask.java
  Log:
  applied J. Russell Smyth 's patches
  
  a Task that uses JdbcModelReader and Betwixt to read a JDBC database
  and write the CommonsSql schema for it.
  
  Revision  Changes    Path
  1.1                  jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/task/JdbcToSchemaTask.java
  
  Index: JdbcToSchemaTask.java
  ===================================================================
  /*
   * $Header: $
   * $Revision: $
   * $Date: $
   *
   * ====================================================================
   *
   * The Apache Software License, Version 1.1
   *
   * Copyright (c) 1999-2002 The Apache Software Foundation.  All rights
   * reserved.
   *
   * Redistribution and use in source and binary forms, with or without
   * modification, are permitted provided that the following conditions
   * are met:
   *
   * 1. Redistributions of source code must retain the above copyright
   *    notice, this list of conditions and the following disclaimer.
   *
   * 2. Redistributions in binary form must reproduce the above copyright
   *    notice, this list of conditions and the following disclaimer in
   *    the documentation and/or other materials provided with the
   *    distribution.
   *
   * 3. The end-user documentation included with the redistribution, if
   *    any, must include the following acknowlegement:
   *       "This product includes software developed by the
   *        Apache Software Foundation (http://www.apache.org/)."
   *    Alternately, this acknowlegement may appear in the software itself,
   *    if and wherever such third-party acknowlegements normally appear.
   *
   * 4. The names "The Jakarta Project", "Commons", and "Apache Software
   *    Foundation" must not be used to endorse or promote products derived
   *    from this software without prior written permission. For written
   *    permission, please contact apache@apache.org.
   *
   * 5. Products derived from this software may not be called "Apache"
   *    nor may "Apache" appear in their names without prior written
   *    permission of the Apache Group.
   *
   * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
   * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
   * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
   * DISCLAIMED.  IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR
   * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
   * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
   * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
   * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
   * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
   * SUCH DAMAGE.
   * ====================================================================
   *
   * This software consists of voluntary contributions made by many
   * individuals on behalf of the Apache Software Foundation.  For more
   * information on the Apache Software Foundation, please see
   * <http://www.apache.org/>.
   * 
   */
  
  package org.apache.commons.sql.task;
  
  import java.io.FileOutputStream;
  import java.io.PrintWriter;
  import java.io.IOException;
  import java.io.FileWriter;
  import java.sql.Connection;
  import java.sql.DatabaseMetaData;
  import java.sql.DriverManager;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.Hashtable;
  import java.util.List;
  import java.util.Vector;
  import java.util.Iterator;
  import org.apache.tools.ant.BuildException;
  import org.apache.tools.ant.Task;
  import org.apache.commons.sql.io.DatabaseWriter;
  import org.apache.commons.sql.io.JdbcModelReader;
  
  import org.apache.commons.sql.model.*;
  
  /**
   * This class generates an XML schema of an existing database from
   * JDBC metadata.
   *
   * @author <a href="mailto:drfish@cox.net">J. Russell Smyth</a>
   * @version $Id: $
   */
  public class JdbcToSchemaTask extends Task
  {
      /** Name of database schema file produced. */
      protected String outputFile;
  
      /** JDBC URL. */
      protected String dbUrl;
  
      /** JDBC driver. */
      protected String dbDriver;
  
      /** JDBC user name. */
      protected String dbUser;
  
      /** JDBC password. */
      protected String dbPassword;
  
      /** DB catalog to use. */
      protected String dbCatalog;
  
      /** DB schema to use. */
      protected String dbSchema;
  
      /** Hashtable of columns that have primary keys. */
      protected Hashtable primaryKeys;
  
      /** Hashtable to track what table a column belongs to. */
      protected Hashtable columnTableMap;
      
      protected boolean useTypeNames = false;
  
      
      public String getDbSchema()
      {
          return dbSchema;
      }
  
      public void setDbCatalog(String dbCatalog)
      {
          this.dbCatalog = dbCatalog;
      }
  
      public void setDbSchema(String dbSchema)
      {
          this.dbSchema = dbSchema;
      }
  
      public void setDbUrl(String v)
      {
          dbUrl = v;
      }
  
      public void setDbDriver(String v)
      {
          dbDriver = v;
      }
  
      public void setDbUser(String v)
      {
          dbUser = v;
      }
  
      public void setDbPassword(String v)
      {
          dbPassword = v;
      }
  
      public void setOutputFile (String v)
      {
          outputFile = v;
      }
      public void setUseTypeNames(boolean b)
      {
          useTypeNames = b;
      }
          
  
      /**
       * Default constructor.
       */
      public void execute() throws BuildException
      {
          System.err.println("Commons-Sql JdbcToSchema starting\n");
          System.err.println("Your DB settings are:");
          System.err.println("driver : " + dbDriver);
          System.err.println("URL : " + dbUrl);
          System.err.println("user : " + dbUser);
          System.err.println("password : " + dbPassword);
          System.err.println("schema : " + dbSchema);
  
          Database db = null;
          try{
              db = getDbFromJdbc(); 
              DatabaseWriter w = new DatabaseWriter(new FileWriter(outputFile));
             // w.setWriteIDs(true);
              w.write(db);
              w.close();
          }catch(Exception e){
              System.out.println("exception during load:"+e.getMessage());
          }
      }
  
      /**
       */
      public Database getDbFromJdbc() throws Exception
      {
          // Load the database Driver.
          Class.forName(dbDriver);
          System.err.println("DB driver sucessfuly instantiated");
  
          // Attemtp to connect to a database.
          Connection con = DriverManager.getConnection(dbUrl,
                                                       dbUser,
                                                       dbPassword);
          System.err.println("DB connection established");
  
          JdbcModelReader reader = new JdbcModelReader(con);
          if ( dbCatalog!=null ) {
              reader.setCatalog(dbCatalog);
          }
          if ( dbSchema!=null ) {
              reader.setSchema(dbSchema);
          }
  
          Database db = reader.getDatabase();
          return db;
      } 
  }
  
  

--
To unsubscribe, e-mail:   <mailto:commons-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@jakarta.apache.org>


Mime
View raw message