---

fmapstable.c

Go to the documentation of this file.

#ifdef HAVE_CONFIG_H
#  include <config.h>
#endif

#include <gnome.h>

#include "callbacks.h"
#include "interface.h"
#include "support.h"

#include "fmaps.h"

#include "gtkfmaps.h"

#ifndef LIBPQ_H
#  include "libpq-fe.h"
#  define LIBPQ_H
#endif

void
FM_Display_Table                    (GtkWidget     *tablewindow,
                                           gchar         *tablename)
{

  gchar *buffer;
  gchar **text=NULL;
  PGresult *qryResult;
  gint nfields;
  gint nbtuples;
  gint fieldsize=0;
  gint i;
  gint j;
  GtkWidget *TableWindow_clist_browse;
  GtkWidget *TableWindow_scrolledwindow;
  GtkWidget **label;

        TableWindow_scrolledwindow=lookup_widget(tablewindow,"TableWindow_scrolledwindow");
    
  buffer=g_strdup_printf("SELECT * from %s ",tablename);
  qryResult = PQexec(conn,buffer);
  g_free(buffer);

  nfields=PQnfields(qryResult);

  TableWindow_clist_browse = gtk_clist_new (nfields);
  gtk_widget_ref (TableWindow_clist_browse);
  gtk_object_set_data_full (GTK_OBJECT (tablewindow), "TableWindow_clist_browse", TableWindow_clist_browse,
                            (GtkDestroyNotify) gtk_widget_unref);
  gtk_widget_show (TableWindow_clist_browse);
  gtk_container_add (GTK_CONTAINER (TableWindow_scrolledwindow), TableWindow_clist_browse);
  gtk_clist_column_titles_show (GTK_CLIST (TableWindow_clist_browse));

        label=g_malloc(sizeof(gpointer)*nfields);

  for (i=0;i<nfields;i++)
  {
    buffer=PQfname(qryResult,i);
        
        label[i] = gtk_label_new (buffer);
        gtk_widget_ref (label[i]);
        gtk_object_set_data_full (GTK_OBJECT (tablewindow), buffer, label[i],
                            (GtkDestroyNotify) gtk_widget_unref);
        gtk_widget_show (label[i]);
        gtk_clist_set_column_widget (GTK_CLIST (TableWindow_clist_browse), i, label[i]);
        fieldsize=PQfsize(qryResult,i);
        if (fieldsize==-1)
        {
          fieldsize=25;
        }
        gtk_clist_set_column_width (GTK_CLIST (TableWindow_clist_browse), i, fieldsize*10);

  }

        nbtuples = PQntuples(qryResult);
  for (i=0;i<nbtuples;i++)
  {
    text=g_malloc(sizeof(gpointer)*nfields);
    for (j=0;j<nfields;j++)
    {
      text[j] = PQgetvalue(qryResult,i,j);
    }     
    gtk_clist_append(GTK_CLIST(TableWindow_clist_browse),text);    
    g_free(text);
  } 
                             
  PQclear(qryResult);
  return;
}

---