Function prepare_database

mapmssql2008.c:500–679

Prepare and execute the SQL statement for this layer */

/* Prepare and execute the SQL statement for this layer */
static int prepare_database(layerObj *layer, rectObj rect, char **query_string)
{
    msMSSQL2008LayerInfo *layerinfo;
    char        *columns_wanted = 0;
    char        *data_source = 0;
    char        *f_table_name = 0;
	char		*geom_table = 0;
	/*
		"Geometry::STGeomFromText('POLYGON(())',)" + terminator = 40 chars
		Plus 10 formatted doubles (15 digits of precision, a decimal point, a space/comma delimiter each = 17 chars each)
		Plus SRID + comma - if SRID is a long...we'll be safe with 10 chars 
	*/
	char        box3d[40 + 10 * 22 + 11];
    char        query_string_temp[10000];       /* Should be big enough */
    int         t;

    char        *pos_from, *pos_ftab, *pos_space, *pos_paren;

    layerinfo =  getMSSQL2008LayerInfo(layer);

    /* Extract the proper f_table_name from the geom_table string.
     * We are expecting the geom_table to be either a single word
     * or a sub-select clause that possibly includes a join --
     *
     * (select column[,column[,...]] from ftab[ natural join table2]) as foo
     *
     * We are expecting whitespace or a ')' after the ftab name.
     *
     */

	geom_table = msStrdup(layerinfo->geom_table);
    pos_from = strstrIgnoreCase(geom_table, " from ");

    if(!pos_from) {
        f_table_name = (char *) msSmallMalloc(strlen(geom_table) + 1);
        strcpy(f_table_name, geom_table);
    } else { /* geom_table is a sub-select clause */
        pos_ftab = pos_from + 6; /* This should be the start of the ftab name */
        pos_space = strstr(pos_ftab, " "); /* First space */

        /* TODO strrchr is POSIX and C99, rindex is neither */
#if defined(_WIN32) && !defined(__CYGWIN__)
        pos_paren = strrchr(pos_ftab, ')');
#else
        pos_paren = rindex(pos_ftab, ')');
#endif

        if(!pos_space || !pos_paren) {
            msSetError(MS_QUERYERR, DATA_ERROR_MESSAGE, "prepare_database()", geom_table, "Error parsing MSSQL2008 data variable: Something is wrong with your subselect statement.<br><br>\n\nMore Help:<br><br>\n\n");

            return MS_FAILURE;
        }

        if (pos_paren < pos_space) { /* closing parenthesis preceeds any space */
            f_table_name = (char *) msSmallMalloc(pos_paren - pos_ftab + 1);
            strlcpy(f_table_name, pos_ftab, pos_paren - pos_ftab + 1);
        } else {
            f_table_name = (char *) msSmallMalloc(pos_space - pos_ftab + 1);