package net.sourceforge.addam.util;

 import java.util.List;

 import java.util.ArrayList;

 import java.sql.Connection;

 import java.sql.DatabaseMetaData;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import net.sourceforge.addam.ddlgen.GeneratorSpec;

 /**

  * Created by IntelliJ IDEA.

  * User: TIM3

  * Date: Oct 27, 2006

  * Time: 11:59:34 PM

  * To change this template use File | Settings | File Templates.

  */

 public class DatabaseMetaDataUtil {

     public static List<String> getTables(String catalog, String schema, Connection connection) throws SQLException {

         DatabaseMetaData metadata = connection.getMetaData();

         if (metadata.storesUpperCaseIdentifiers()) {

             catalog = (catalog == null) ? null : catalog.toUpperCase();

             schema = (schema == null) ? null : schema.toUpperCase();

         } else if (metadata.storesLowerCaseIdentifiers()) {

             catalog = (catalog == null) ? null : catalog.toLowerCase();

             schema = (schema == null) ? null : schema.toLowerCase();

         }

         ResultSet tablesRS = metadata.getTables(catalog, schema, "%", new String[]{"TABLE"});

         List<String> objects = new ArrayList<String>();

         while (tablesRS.next()) {

             String dbObject = tablesRS.getString(3);

             objects.add(dbObject);

         }

         return objects;

     }

 }