Function msMSSQL2008LayerParseData

mapmssql2008.c:1754–1875

Function to parse the Mapserver DATA parameter for geometry * column name, table name and name of a column to serve as a * unique record id */

 * unique record id
 */
static int msMSSQL2008LayerParseData(layerObj *layer, char **geom_column_name, char **geom_column_type, char **table_name, char **urid_name, char **user_srid, char **index_name, int debug)
{
    char    *pos_opt, *pos_scn, *tmp, *pos_srid, *pos_urid, *pos_geomtype, *pos_geomtype2, *pos_indexHint, *data;
    int     slength;

    data = layer->data;

    /* given a string of the from 'geom from ctivalues' or 'geom from () as foo'
     * return geom_column_name as 'geom'
     * and table name as 'ctivalues' or 'geom from () as foo'
     */

    /* First look for the optional ' using unique ID' string */
    pos_urid = strstrIgnoreCase(data, " using unique ");

    if(pos_urid) {
        /* CHANGE - protect the trailing edge for thing like 'using unique ftab_id using srid=33' */
        tmp = strstr(pos_urid + 14, " ");
        if(!tmp) {
            tmp = pos_urid + strlen(pos_urid);
        }
        *urid_name = (char *) msSmallMalloc((tmp - (pos_urid + 14)) + 1);
        strlcpy(*urid_name, pos_urid + 14, (tmp - (pos_urid + 14)) + 1);
    }

    /* Find the srid */
    pos_srid = strstrIgnoreCase(data, " using SRID=");
    if(!pos_srid) {
        *user_srid = (char *) msSmallMalloc(2);
        (*user_srid)[0] = '0';
        (*user_srid)[1] = 0;
    } else {
        slength = strspn(pos_srid + 12, "-0123456789");
        if(!slength) {
            msSetError(MS_QUERYERR, DATA_ERROR_MESSAGE, "msMSSQL2008LayerParseData()", "Error parsing MSSQL2008 data variable: You specified 'using SRID=#' but didnt have any numbers!<br><br>\n\nMore Help:<br><br>\n\n", data);

            return MS_FAILURE;
        } else {
            *user_srid = (char *) msSmallMalloc(slength + 1);
            strlcpy(*user_srid, pos_srid + 12, slength+1);
        }
    }

	pos_indexHint = strstrIgnoreCase(data, " using index ");
    if(pos_indexHint) {
        /* CHANGE - protect the trailing edge for thing like 'using unique ftab_id using srid=33' */
        tmp = strstr(pos_indexHint + 13, " ");
        if(!tmp) {
            tmp = pos_indexHint + strlen(pos_indexHint);
        }
        *index_name = (char *) msSmallMalloc((tmp - (pos_indexHint + 13)) + 1);
        strlcpy(*index_name, pos_indexHint + 13, tmp - (pos_indexHint + 13)+1);
    }

    /* this is a little hack so the rest of the code works.  If the ' using SRID=' comes before */
    /* the ' using unique ', then make sure pos_opt points to where the ' using SRID' starts! */
    pos_opt = pos_urid;
	if ( !pos_opt || ( pos_srid && pos_srid < pos_opt ) ) pos_opt = pos_srid;