Function msPostGISLayerWhichShapes

mappostgis.c:2402–2503

** msPostGISLayerWhichShapes() ** ** Registered vtable->LayerWhichShapes function. */

** Registered vtable->LayerWhichShapes function.
*/
int msPostGISLayerWhichShapes(layerObj *layer, rectObj rect, int isQuery) {
#ifdef USE_POSTGIS
    msPostGISLayerInfo *layerinfo = NULL;
    char *strSQL = NULL;
    PGresult *pgresult = NULL;
    char** layer_bind_values = (char**)msSmallMalloc(sizeof(char*) * 1000);
    char* bind_value;
    char* bind_key = (char*)msSmallMalloc(3);

    int num_bind_values = 0;

	/* try to get the first bind value */
	bind_value = msLookupHashTable(&layer->bindvals, "1");
	while(bind_value != NULL) {
		/* put the bind value on the stack */
		layer_bind_values[num_bind_values] = bind_value;
		/* increment the counter */
		num_bind_values++;
		/* create a new lookup key */
		sprintf(bind_key, "%d", num_bind_values+1);
		/* get the bind_value */
		bind_value = msLookupHashTable(&layer->bindvals, bind_key);
	}

    assert(layer != NULL);
    assert(layer->layerinfo != NULL);

    if (layer->debug) {
        msDebug("msPostGISLayerWhichShapes called.\n");
    }

    /* Fill out layerinfo with our current DATA state. */
    if ( msPostGISParseData(layer) != MS_SUCCESS) {
        return MS_FAILURE;
    }

    /* 
    ** This comes *after* parsedata, because parsedata fills in 
    ** layer->layerinfo.
    */
    layerinfo = (msPostGISLayerInfo*) layer->layerinfo;

    /* Build a SQL query based on our current state. */
    strSQL = msPostGISBuildSQL(layer, &rect, NULL);
    if ( ! strSQL ) {
        msSetError(MS_QUERYERR, "Failed to build query SQL.", "msPostGISLayerWhichShapes()");
        return MS_FAILURE;
    }

    if (layer->debug) {
        msDebug("msPostGISLayerWhichShapes query: %s\n", strSQL);
    }

    if(num_bind_values > 0) {
        pgresult = PQexecParams(layerinfo->pgconn, strSQL, num_bind_values, NULL, (const char**)layer_bind_values, NULL, NULL, 1);
    } else {
      pgresult = PQexecParams(layerinfo->pgconn, strSQL,0, NULL, NULL, NULL, NULL, 0);
    }