/*
 * JBoss, Home of Professional Open Source.
 *
 * See the LEGAL.txt file distributed with this work for information regarding copyright ownership and licensing.
 *
 * See the AUTHORS.txt file distributed with this work for a full listing of individual contributors.
 */
package org.teiid.designer.jdbc.metadata.impl;

import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.eclipse.core.runtime.IStatus;
import org.teiid.designer.jdbc.JdbcPlugin;
import org.teiid.designer.jdbc.JdbcUtil;
import org.teiid.designer.jdbc.data.MetadataRequest;
import org.teiid.designer.jdbc.data.Response;

/**
 * GetIndexesRequest
 *
 * @since 8.0
 */
public class GetIndexesRequest extends MetadataRequest {
    
    public static final String NAME = JdbcPlugin.Util.getString("GetIndexesRequestName"); //$NON-NLS-1$
    private static final String METHOD_NAME = "getIndexInfo"; //$NON-NLS-1$
    
    /**
     * Construct an instance of GetIndexesRequest.
     * @param metadata
     * @param catalogNamePattern
     * @param schemaNamePattern
     * @param tableNamePattern
     * @param uniqueValuesOnly
     * @param approximateAllowed
     */
    public GetIndexesRequest( final DatabaseMetaData metadata,
                              final String catalogNamePattern, 
                              final String schemaNamePattern,
                              final String tableNamePattern,
                              final boolean uniqueValuesOnly, 
                              final boolean approximateAllowed  ) {
        super(NAME, metadata, METHOD_NAME, 
              new Object[]{catalogNamePattern,schemaNamePattern,tableNamePattern,
                           new Boolean(uniqueValuesOnly), new Boolean(approximateAllowed)});
    }
    
    /** 
     * This method is overridden to optimize performance.
     * @see org.teiid.designer.jdbc.data.MethodRequest#performInvocation(org.teiid.designer.jdbc.data.Response)
     * @since 4.2
     */
    @Override
    protected IStatus performInvocation(final Response results) {
        // Override to optimize ...
        final DatabaseMetaData dbmd = this.getDatabaseMetaData();
        ResultSet resultSet = null;
        IStatus status = null;
        try {
            final String catalogPattern = (String)getParameters()[0];
            final String schemaPattern  = (String)getParameters()[1];
            final String tablePattern   = (String)getParameters()[2];
            final boolean unique       = ((Boolean)getParameters()[3]).booleanValue();
            final boolean approximate  = ((Boolean)getParameters()[4]).booleanValue();
            resultSet = dbmd.getIndexInfo(catalogPattern, schemaPattern, tablePattern, unique, approximate);
            Response.addResults(results,resultSet,this.isMetadataRequested());
        } catch ( SQLException e ) {
            status = JdbcUtil.createIStatus(e,e.getLocalizedMessage());
        } finally {
            if ( resultSet != null ) {
                try {
                    resultSet.close();
                } catch (SQLException e1) {
                }
            }
        }
        return status;
    }
    
}