/*
 * GeometryMetadataTable.java
 *
 * Created on January 24, 2001, 10:59 AM
 */

package uk.ac.leeds.ccg.sfsql;

import java.sql.*;
/**
 *
 * @author  jamesm
 * @version 
 */
public class GeometryMetadataTable extends Object {
    
     Connection con;

    /** Creates new GeometryMetadataTable */
    public GeometryMetadataTable(Connection c) {
        con = c;
    }
    
    public GeometryMetadata[] getMetadata() throws SQLException{
        Statement stmt = con.createStatement();
        String query = "select * from GEOMETRY_COLUMNS";
        ResultSet res = stmt.executeQuery(query);
      //  res.getObject(colName
        int size = res.getFetchSize();
       
        GeometryMetadata[] metadata = new GeometryMetadata[size];
        
        int index=0;
        while(res.next()){
            /*res.getString("F_TABLE_CATALOG");
            res.getString("F_TABLE_SCHEMA");
            res.getString("F_TABLE_NAME");*/
            GeometryMetadata gm = new GeometryMetadata(con,res.getString("F_TABLE_CATALOG"),res.getString("F_TABLE_SCHEMA"),res.getString("F_TABLE_NAME"),res.getString("F_GEOMETRY_COLUMN"),res.getString("G_TABLE_CATALOG"),res.getString("G_TABLE_SCHEMA"),res.getString("G_TABLE_NAME"),res.getInt("STORAGE_TYPE")==1,res.getInt("GEOMETRY_TYPE"),res.getInt("COORD_DIMENSION"),res.getInt("MAX_PPR"),res.getInt("SRID"));
            metadata[index]=gm;
            index++;
        }
        return metadata;
    }

}