//

 // Copyright (c) 2004, International Decision Systems

 // all rights reserved

 //

 package net.sourceforge.addam.ddlgen.oracle;

 import java.io.BufferedWriter;

 import java.sql.*;

 import java.util.List;

 import net.sourceforge.addam.ddlgen.Filter;

 public class IndexGenerator extends DBMSMetadataGenerator {

     private static final String TABLE_SQL = "select distinct table_name from all_indexes ao where owner=? " +

         "and index_name not in (select constraint_name from all_constraints where owner=ao.owner)";

     private static final String INDEX_SQL = "select index_name from all_indexes ao where owner=? and table_name=?" +

         "and index_name not in (select constraint_name from all_constraints where owner=ao.owner)";

     public String objectType() {

         return "TABLE";

     }

     public List<String> getObjects(String catalog, String schema, Filter filter,

                                    Connection connection, DatabaseMetaData metadata) throws Exception {

         return getObjects(catalog, schema, objectType(), filter, connection, metadata, TABLE_SQL, schema);

     }

     public void generate(String catalog, String schema, String object,

                          String vendor, Connection connection, DatabaseMetaData metadata, BufferedWriter writer)

             throws Exception {

         Filter allIndexes = new Filter() {

             public boolean includes(String objectName) {

                 return true;

             }

         };

         List<String> indexes = getObjects(catalog, schema, "INDEX", allIndexes, connection, metadata, INDEX_SQL, schema, object);

         for (String index : indexes) {

             super.generate(catalog,schema,"INDEX",index,vendor,connection,metadata,writer);

         }

     }

 }