PostGIS  2.5.0dev-r@@SVN_REVISION@@

◆ update_table_chooser_from_database()

static void update_table_chooser_from_database ( )
static

Definition at line 668 of file shp2pgsql-gui.c.

References _, chooser_table_list_store, free(), malloc(), pg_connection, ShpDumperGetConnectionStringFromConn(), TABLECHOOSER_GEO_COLUMN, TABLECHOOSER_GEO_LISTSTORE_COLUMN, TABLECHOOSER_GEOCOL_COMBO_COLUMNS, TABLECHOOSER_GEOCOL_COMBO_TEXT, TABLECHOOSER_HASGEO_COLUMN, TABLECHOOSER_SCHEMA_COLUMN, and TABLECHOOSER_TABLE_COLUMN.

Referenced by pgui_action_open_table_dialog().

669 {
670  PGresult *result, *geocol_result;
671  GtkTreeIter iter, geocol_iter;
672  GtkListStore *dumper_geocol_combo_list;
673  char *connection_string, *sql_form, *query, *schema, *table, *geocol_query, *geocol_name=NULL;
674  int hasgeo, i, j;
675 
676  /* Open a connection to the database */
677  connection_string = ShpDumperGetConnectionStringFromConn(conn);
678  pg_connection = PQconnectdb(connection_string);
679 
680  /* Here we find a list of all tables/views that not in a pg_* schema (or information_schema) and
681  we return the schema name, table name and whether or not the table/view contains any geo
682  columns */
683  query = "SELECT tableoids.oid, n.nspname, tableoids.relname, COALESCE((SELECT 1 from pg_attribute WHERE attrelid = tableoids.oid AND atttypid IN (SELECT oid FROM pg_type WHERE typname in ('geometry', 'geography')) LIMIT 1), 0) hasgeo FROM (SELECT c.oid, c.relname, c.relnamespace FROM pg_class c WHERE c.relkind IN ('r', 'v', 'm', 'f','p') AND c.relnamespace IN (SELECT oid FROM pg_namespace WHERE nspname NOT ILIKE 'pg_%' AND nspname <> 'information_schema')) tableoids, pg_namespace n WHERE tableoids.relnamespace = n.oid ORDER BY n.nspname, tableoids.relname";
684 
685  result = PQexec(pg_connection, query);
686 
687  /* Free any existing entries in the model */
688  gtk_list_store_clear(chooser_table_list_store);
689 
690  /* Now insert one row for each query result */
691  for (i = 0; i < PQntuples(result); i++)
692  {
693  gtk_list_store_insert_before(chooser_table_list_store, &iter, NULL);
694 
695  /* Look up the geo columns; if there are none then we set the field to (None). If we have just one
696  column then we set the column name directly. If we have more than one then we create a combo
697  dropdown containing the column names */
698  schema = PQgetvalue(result, i, PQfnumber(result, "nspname"));
699  table = PQgetvalue(result, i, PQfnumber(result, "relname"));
700 
701  sql_form = "SELECT n.nspname, c.relname, a.attname FROM pg_class c, pg_namespace n, pg_attribute a WHERE c.relnamespace = n.oid AND n.nspname = '%s' AND c.relname = '%s' AND a.attrelid = c.oid AND a.atttypid IN (SELECT oid FROM pg_type WHERE typname in ('geometry', 'geography'))";
702 
703  geocol_query = malloc(strlen(sql_form) + strlen(schema) + strlen(table) + 1);
704  sprintf(geocol_query, sql_form, schema, table);
705 
706  geocol_result = PQexec(pg_connection, geocol_query);
707 
708  /* Create a combo list loaded with the column names. Note that while we create the model and load
709  the data here, we don't actually display the geo column in this dialog. Instead we build the
710  list here so that we can pass to the export table list store when creating a new entry. This
711  is to ensure that the export table list model can directly represent a SHPDUMPERCONFIG. */
712  dumper_geocol_combo_list = gtk_list_store_new(TABLECHOOSER_GEOCOL_COMBO_COLUMNS, G_TYPE_STRING);
713 
714  if (PQntuples(geocol_result) > 0)
715  {
716  /* Load the columns into the list store */
717  for (j = 0; j < PQntuples(geocol_result); j++)
718  {
719  geocol_name = PQgetvalue(geocol_result, j, PQfnumber(geocol_result, "attname"));
720 
721  gtk_list_store_insert_before(dumper_geocol_combo_list, &geocol_iter, (GtkTreeIter *)TABLECHOOSER_GEOCOL_COMBO_TEXT);
722  gtk_list_store_set(dumper_geocol_combo_list, &geocol_iter,
723  TABLECHOOSER_GEOCOL_COMBO_TEXT, geocol_name,
724  -1);
725  }
726  }
727  else
728  {
729  /* Add a "default" entry */
730  geocol_name = NULL;
731 
732  gtk_list_store_insert_before(dumper_geocol_combo_list, &geocol_iter, (GtkTreeIter *)TABLECHOOSER_GEOCOL_COMBO_TEXT);
733  gtk_list_store_set(dumper_geocol_combo_list, &geocol_iter,
735  -1);
736  }
737 
738  /* Free the query result */
739  PQclear(geocol_result);
740 
741  /* Free the query string */
742  free(geocol_query);
743 
744  /* Set the list store data */
745  hasgeo = atoi(PQgetvalue(result, i, PQfnumber(result, "hasgeo")));
746  gtk_list_store_set(chooser_table_list_store, &iter,
749  TABLECHOOSER_GEO_LISTSTORE_COLUMN, dumper_geocol_combo_list,
750  TABLECHOOSER_GEO_COLUMN, geocol_name,
752  -1);
753  }
754 
755  /* Clear up the result set */
756  PQclear(result);
757 
758  /* Close the existing connection */
759  PQfinish(pg_connection);
760  pg_connection = NULL;
761 
762  return;
763 }
#define _(String)
Definition: shpcommon.h:24
static SHPCONNECTIONCONFIG * conn
char * ShpDumperGetConnectionStringFromConn(SHPCONNECTIONCONFIG *conn)
void free(void *)
void * malloc(YYSIZE_T)
static PGconn * pg_connection
GtkListStore * chooser_table_list_store
Here is the call graph for this function:
Here is the caller graph for this function: