add_raster_constraints()

static int add_raster_constraints ( const char *  schema, const char *  table, const char *  column, int  regular_blocking, int  max_extent, STRINGBUFFER *  buffer  )

static

Definition at line 1156 of file raster2pgsql.c.

  {
        char *sql = NULL;
        uint32_t len = 0;
 
        char *_tmp = NULL;
        char *_schema = NULL;
        char *_table = NULL;
        char *_column = NULL;
 
        assert(table != NULL);
        assert(column != NULL);
 
        /* schema */
        if (schema != NULL) {
                _tmp = chartrim(schema, ".");
                _schema = chartrim(_tmp, "\"");
                rtdealloc(_tmp);
                _tmp = strreplace(_schema, "'", "''", NULL);
                rtdealloc(_schema);
                _schema = _tmp;
        }
 
        /* table */
        _tmp = chartrim(table, "\"");
        _table = strreplace(_tmp, "'", "''", NULL);
        rtdealloc(_tmp);
 
        /* column */
        _tmp = chartrim(column, "\"");
        _column = strreplace(_tmp, "'", "''", NULL);
        rtdealloc(_tmp);
 
        len = strlen("SELECT AddRasterConstraints('','','',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,FALSE);") + 1;
        if (_schema != NULL)
                len += strlen(_schema);
        len += strlen(_table);
        len += strlen(_column);
 
        sql = rtalloc(sizeof(char) * len);
        if (sql == NULL) {
                rterror(_("add_raster_constraints: Could not allocate memory for AddRasterConstraints statement"));
                return 0;
        }
        sprintf(sql, "SELECT AddRasterConstraints('%s','%s','%s',TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,%s,TRUE,TRUE,TRUE,TRUE,%s);",
                (_schema != NULL ? _schema : ""),
                _table,
                _column,
                (regular_blocking ? "TRUE" : "FALSE"),
                (max_extent ? "TRUE" : "FALSE")
        );
 
        if (_schema != NULL)
                rtdealloc(_schema);
        rtdealloc(_table);
        rtdealloc(_column);
 
        append_sql_to_buffer(buffer, sql);
 
        return 1;
}

References _, append_sql_to_buffer(), buffer(), chartrim(), rtalloc(), rtdealloc(), rterror(), and strreplace().

Referenced by process_rasters().

Here is the call graph for this function:

Here is the caller graph for this function: