package cities.utils;

import csip.api.server.ServiceException;
import java.sql.Connection;
import m.utils.Layer;
import m.utils.Table;

/**
* Last Updated: 31-August-2016
* @author Tyler Wible
* @since 30-August-2016
*/
public class PostgresqlCitiesDatabase extends PostgresqlLocationsDatabase {
    
    public static final String DEFAULT_SCHEMA = "csip_wrap";
    
    public PostgresqlCitiesDatabase(String hostname, String port, String dbName, String username, String password) throws ServiceException {
        super(hostname, port, dbName, username, password);
    }
    
    public PostgresqlCitiesDatabase(Connection conn) throws Exception {
        super(conn);
    }
    
    public Table getCities(Layer one) throws Exception {
        return this.getLocations("public", "city_extents", one);
    }
    
    public Layer getCity(int oid) throws Exception {
        return this.getLocation("public", "city_extents", oid);
    }
 
}