/*
*
* SchemaCrawler
* http://sourceforge.net/projects/schemacrawler
* Copyright (c) 2000-2009, Sualeh Fatehi.
*
* This library is free software; you can redistribute it and/or modify it under the terms
* of the GNU Lesser General Public License as published by the Free Software Foundation;
* either version 2.1 of the License, or (at your option) any later version.
*
* This library 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 Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License along with this
* library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
* Boston, MA 02111-1307, USA.
*
*/
package schemacrawler.tools.integration;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.logging.Level;
import java.util.logging.Logger;
import schemacrawler.schemacrawler.Config;
import schemacrawler.tools.Executable;
import schemacrawler.tools.OutputOptions;
import schemacrawler.tools.main.Command;
import schemacrawler.tools.main.Commands;
import schemacrawler.tools.main.HelpOptions;
import schemacrawler.tools.main.SchemaCrawlerCommandLine;
import schemacrawler.tools.text.schema.SchemaTextDetailType;
import schemacrawler.tools.text.schema.SchemaTextOptions;
/**
* Basic SchemaCrawler integrations executor.
*
* @author Sualeh Fatehi
*/
public abstract class IntegrationsExecutable
extends Executable<SchemaTextOptions>
{
private static final Logger LOGGER = Logger
.getLogger(IntegrationsExecutable.class.getName());
protected IntegrationsExecutable(final String name)
{
super(name);
}
/**
* Get connection parameters, and creates a connection, and crawls the
* schema.
*
* @param args
* Arguments passed into the program from the command line.
* @throws Exception
* On an exception
*/
public final void main(final String[] args)
throws Exception
{
final SchemaCrawlerCommandLine commandLine = new SchemaCrawlerCommandLine(args,
getHelpOptions());
schemaCrawlerOptions = commandLine.getSchemaCrawlerOptions();
final OutputOptions outputOptions = commandLine.getOutputOptions();
final Commands commands = commandLine.getCommands();
final SchemaTextDetailType schemaTextDetailType = SchemaTextDetailType
.valueOf(getCommand(commands));
final Config config = commandLine.getConfig();
toolOptions = new SchemaTextOptions(config,
outputOptions,
schemaTextDetailType);
final Connection connection = commandLine.createConnection();
execute(connection);
try
{
if (connection != null)
{
connection.close();
LOGGER.log(Level.INFO, "Closed database connection, " + connection);
}
}
catch (final SQLException e)
{
final String errorMessage = e.getMessage();
LOGGER.log(Level.WARNING, "Could not close the connection: "
+ errorMessage);
}
}
/**
* Expect one command (further, of type schema text.
*/
private String getCommand(final Commands commands)
{
final Iterator<Command> iterator = commands.iterator();
if (!iterator.hasNext())
{
throw new IllegalArgumentException("No commands specified");
}
return iterator.next().getName();
}
protected abstract HelpOptions getHelpOptions();
}