add_overview_constraints()

static int add_overview_constraints ( const char *  ovschema, const char *  ovtable, const char *  ovcolumn, const char *  schema, const char *  table, const char *  column, const int  factor, STRINGBUFFER *  buffer  )

static

Definition at line 1244 of file raster2pgsql.c.

References _, append_sql_to_buffer(), chartrim(), MAXOVFACTOR, MINOVFACTOR, rtalloc(), rtdealloc(), rterror(), rtgdalraster::sql, and strreplace().

Referenced by process_rasters().

  {
        char *sql = NULL;
        uint32_t len = 0;

        char *_tmp = NULL;

        char *_ovschema = NULL;
        char *_ovtable = NULL;
        char *_ovcolumn = NULL;

        char *_schema = NULL;
        char *_table = NULL;
        char *_column = NULL;

        assert(ovtable != NULL);
        assert(ovcolumn != NULL);
        assert(table != NULL);
        assert(column != NULL);
        assert(factor >= MINOVFACTOR && factor <= MAXOVFACTOR);

        /* overview schema */
        if (ovschema != NULL) {
                _tmp = chartrim(ovschema, ".");
                _ovschema = chartrim(_tmp, "\"");
                rtdealloc(_tmp);
                _tmp = strreplace(_ovschema, "'", "''", NULL);
                rtdealloc(_ovschema);
                _ovschema = _tmp;
        }

        /* overview table */
        _tmp = chartrim(ovtable, "\"");
        _ovtable = strreplace(_tmp, "'", "''", NULL);
        rtdealloc(_tmp);

        /* overview column*/
        _tmp = chartrim(ovcolumn, "\"");
        _ovcolumn = strreplace(_tmp, "'", "''", NULL);
        rtdealloc(_tmp);

        /* 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 AddOverviewConstraints('','','','','','',);") + 5;
        if (_ovschema != NULL)
                len += strlen(_ovschema);
        len += strlen(_ovtable);
        len += strlen(_ovcolumn);
        if (_schema != NULL)
                len += strlen(_schema);
        len += strlen(_table);
        len += strlen(_column);

        sql = rtalloc(sizeof(char) * len);
        if (sql == NULL) {
                rterror(_("add_overview_constraints: Could not allocate memory for AddOverviewConstraints statement"));
                return 0;
        }
        sprintf(sql, "SELECT AddOverviewConstraints('%s','%s','%s','%s','%s','%s',%d);",
                (_ovschema != NULL ? _ovschema : ""),
                _ovtable,
                _ovcolumn,
                (_schema != NULL ? _schema : ""),
                _table,
                _column,
                factor
        );

        if (_ovschema != NULL)
                rtdealloc(_ovschema);
        rtdealloc(_ovtable);
        rtdealloc(_ovcolumn);

        if (_schema != NULL)
                rtdealloc(_schema);
        rtdealloc(_table);
        rtdealloc(_column);

        append_sql_to_buffer(buffer, sql);

        return 1;
}

Here is the call graph for this function:

Here is the caller graph for this function: