Application: gvSIG desktop

package org.gvsig.fmap.dal.store.jdbc2.spi.operations;

import java.sql.Connection;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.List;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.store.jdbc2.JDBCHelper;

import org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException;

import org.gvsig.fmap.dal.store.jdbc2.JDBCUtils;

public class UpdateTableStatisticsOperation extends AbstractConnectionOperation {

    private final String schemaName;

    private final String tableName;

    private final String dbName;

    public UpdateTableStatisticsOperation(

            JDBCHelper helper

        ) {

        this(helper, null, null, null);

    }

    public UpdateTableStatisticsOperation(

            JDBCHelper helper,

            String dbName,

            String schemaName,

            String tableName

        ) {

        super(helper);

        this.dbName = dbName;

        this.schemaName = schemaName;

        this.tableName = tableName;

    }

    @Override

    public final Object perform(Connection conn) throws DataException {

        this.updateTableStatistics(conn, dbName, schemaName, tableName);

        return true;

    }

    public void updateTableStatistics(

            Connection conn,

            String database,

            String schema,

            String table

        ) throws DataException {

        JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder();

        sqlbuilder.update_table_statistics().table().database(database).schema(schema).name(table);

        List<String> sqls;

        sqls = sqlbuilder.update_table_statistics().toStrings();

        Statement st = null;

        try {

            st = conn.createStatement();

            for (String sql : sqls) {

                JDBCUtils.execute(st, sql);

            }

        } catch (SQLException ex) {

            throw new JDBCSQLException(ex);

        } finally {

            JDBCUtils.closeQuietly(st);

        }

    }

}