PostGIS  3.1.6dev-r@@SVN_REVISION@@

◆ ShpLoaderGetSQLFooter()

int ShpLoaderGetSQLFooter ( SHPLOADERSTATE state,
char **  strfooter 
)

We need to copy from the temp table to the real table, transforming to to_srid

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

1877 {
1878  stringbuffer_t *sb;
1879  char *ret;
1880 
1881  /* Create the stringbuffer containing the header; we use this API as it's easier
1882  for handling string resizing during append */
1883  sb = stringbuffer_create();
1884  stringbuffer_clear(sb);
1885 
1886  if ( state->config->dump_format && state->to_srid != state->from_srid){
1888  stringbuffer_aprintf(sb, "ALTER TABLE \"pgis_tmp_%s\" ALTER COLUMN \"%s\" TYPE ", state->config->table, state->geo_col);
1889  if (state->config->geography){
1890  stringbuffer_aprintf(sb, "geography USING (ST_Transform(\"%s\", %d)::geography );\n", state->geo_col, state->to_srid);
1891  }
1892  else {
1893  stringbuffer_aprintf(sb, "geometry USING (ST_Transform(\"%s\", %d)::geometry );\n", state->geo_col, state->to_srid);
1894  }
1895  stringbuffer_aprintf(sb, "INSERT INTO ");
1896  // /* Schema is optional, include if present. */
1897  if (state->config->schema)
1898  {
1899  stringbuffer_aprintf(sb, "\"%s\".", state->config->schema);
1900  }
1901  stringbuffer_aprintf(sb, "\"%s\" (%s) ", state->config->table, state->col_names);
1902  stringbuffer_aprintf(sb, "SELECT %s FROM \"pgis_tmp_%s\";\n", state->col_names, state->config->table);
1903  }
1904 
1905  /* Create gist index if specified and not in "prepare" mode */
1906  if (state->config->readshape && state->config->createindex)
1907  {
1908  stringbuffer_aprintf(sb, "CREATE INDEX ON ");
1909  /* Schema is optional, include if present. */
1910  if (state->config->schema)
1911  {
1912  stringbuffer_aprintf(sb, "\"%s\".",state->config->schema);
1913  }
1914  stringbuffer_aprintf(sb, "\"%s\" USING GIST (\"%s\")", state->config->table, state->geo_col);
1915  /* Tablespace is also optional. */
1916  if (state->config->idxtablespace != NULL)
1917  {
1918  stringbuffer_aprintf(sb, " TABLESPACE \"%s\"", state->config->idxtablespace);
1919  }
1920  stringbuffer_aprintf(sb, ";\n");
1921  }
1922 
1923  /* End the transaction if there is one. */
1924  if (state->config->usetransaction)
1925  {
1926  stringbuffer_aprintf(sb, "COMMIT;\n");
1927  }
1928 
1929  /* Always ANALYZE the resulting table, for better stats */
1930  stringbuffer_aprintf(sb, "ANALYZE ");
1931  if (state->config->schema)
1932  {
1933  stringbuffer_aprintf(sb, "\"%s\".", state->config->schema);
1934  }
1935  stringbuffer_aprintf(sb, "\"%s\";\n", state->config->table);
1936 
1937  /* Copy the string buffer into a new string, destroying the string buffer */
1938  ret = (char *)malloc(strlen((char *)stringbuffer_getstring(sb)) + 1);
1939  strcpy(ret, (char *)stringbuffer_getstring(sb));
1941 
1942  *strfooter = ret;
1943 
1944  return SHPLOADEROK;
1945 }
void * malloc(YYSIZE_T)
#define SHPLOADEROK
void stringbuffer_clear(stringbuffer_t *s)
Reset the stringbuffer_t.
Definition: stringbuffer.c:88
int stringbuffer_aprintf(stringbuffer_t *s, const char *fmt,...)
Appends a formatted string to the current string buffer, using the format and argument list provided.
Definition: stringbuffer.c:228
stringbuffer_t * stringbuffer_create(void)
Allocate a new stringbuffer_t.
Definition: stringbuffer.c:33
void stringbuffer_destroy(stringbuffer_t *s)
Free the stringbuffer_t and all memory managed within it.
Definition: stringbuffer.c:76
const char * stringbuffer_getstring(stringbuffer_t *s)
Returns a reference to the internal string being managed by the stringbuffer.
Definition: stringbuffer.c:113
SHPLOADERCONFIG * config

References shp_loader_state::col_names, shp_loader_state::config, shp_loader_config::createindex, shp_loader_config::dump_format, shp_loader_state::from_srid, shp_loader_state::geo_col, shp_loader_config::geography, shp_loader_config::idxtablespace, malloc(), shp_loader_config::readshape, shp_loader_config::schema, SHPLOADEROK, stringbuffer_aprintf(), stringbuffer_clear(), stringbuffer_create(), stringbuffer_destroy(), stringbuffer_getstring(), shp_loader_config::table, shp_loader_state::to_srid, and shp_loader_config::usetransaction.

Referenced by pgui_action_import().

Here is the call graph for this function:
Here is the caller graph for this function: