escape_insert_string()

char * escape_insert_string

(

char *

str

)

Escape input string suitable for INSERT.

If no characters require escaping, simply return the input pointer. Otherwise return a new allocated string.

Definition at line 174 of file shp2pgsql-core.c.

Referenced by ShpLoaderGenerateSQLRowStatement().

{
        /*
         * Escape single quotes by adding a preceding single quote
         *
         * 1. find # of characters
         * 2. make new string
         */

        char *result;
        char *ptr, *optr;
        int toescape = 0;
        size_t size;

        ptr = str;

        /* Count how many characters we need to escape so we know the size of the string we need to return */
        while (*ptr)
        {
                if (*ptr == '\'')
                        toescape++;

                ptr++;
        }

        /* If we don't have to escape anything, simply return the input pointer */
        if (toescape == 0)
                return str;

        size = ptr - str + toescape + 1;
        result = calloc(1, size);
        optr = result;
        ptr = str;

        while (*ptr)
        {
                if (*ptr == '\'')
                        *optr++='\'';

                *optr++ = *ptr++;
        }

        *optr='\0';

        return result;
}

Here is the caller graph for this function: