---

fmapsmetadata.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

/* this procedure initialise all the widgets that Glade cannot initialise */
void
FM_Init_MetaData                 (GtkWidget     *metadatawindow)
{
        GtkWidget *widget;
        static gchar* spatial_rep_type_code0[1]={"none"};
        static gchar* spatial_rep_type_code1[1]={"text"};
        static gchar* spatial_rep_type_code2[1]={"vector"};
        static gchar* spatial_rep_type_code3[1]={"raster"};
        static gchar* spatial_rep_type_code4[1]={"image"};
        
  g_return_if_fail(metadatawindow!=NULL);
  
  widget=lookup_widget(metadatawindow,"spatial_rep_type_code"); 
  gtk_clist_append(GTK_CLIST(widget),spatial_rep_type_code0);
  gtk_clist_append(GTK_CLIST(widget),spatial_rep_type_code1);
  gtk_clist_append(GTK_CLIST(widget),spatial_rep_type_code2);
  gtk_clist_append(GTK_CLIST(widget),spatial_rep_type_code3);
  gtk_clist_append(GTK_CLIST(widget),spatial_rep_type_code4);  
  
}

void
FM_Display_MetaData                 (GtkWidget     *metadatawindow,
                                           gchar         *tablename)
{

  gchar *buffer;
  PGresult *qryResult;
  gint nbtuples;
  GtkWidget *widget;
  gchar *oid=NULL;
  gint i;

  g_return_if_fail(metadatawindow!=NULL);

  /* f_catalogue */  
  buffer=g_strdup_printf("SELECT OID,* from f_catalogue WHERE meta_file_id='%s' ",tablename);
  qryResult = PQexec(conn,buffer);
  g_free(buffer);

        nbtuples = PQntuples(qryResult);
  if (nbtuples>0)
  {
        buffer = PQgetvalue(qryResult,0,0);
    widget=lookup_widget(metadatawindow,"oid");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    oid=g_strdup(buffer);
    
    buffer = PQgetvalue(qryResult,0,1);
    widget=lookup_widget(metadatawindow,"meta_file_id");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    widget=lookup_widget(metadatawindow,"global_meta_file_id");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    
    buffer = PQgetvalue(qryResult,0,2);
    widget=lookup_widget(metadatawindow,"meta_parent_id");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);

    buffer = PQgetvalue(qryResult,0,3);
    widget=lookup_widget(metadatawindow,"title");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    
    buffer = PQgetvalue(qryResult,0,4);
    widget=lookup_widget(metadatawindow,"edition");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    
    buffer = PQgetvalue(qryResult,0,5);
    widget=lookup_widget(metadatawindow,"series");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    
    buffer = PQgetvalue(qryResult,0,6);
    widget=lookup_widget(metadatawindow,"issue_id");
    gtk_entry_set_text(GTK_ENTRY(widget),buffer);
    
  }                          
  PQclear(qryResult);
  /* end of f_catalogue */
  
  /* f_catalogue_spatial_rep_type_code */
  buffer=g_strdup_printf("SELECT OID,* from f_catalogue_spatial_rep_type_code WHERE CID=%s ",oid);
  qryResult = PQexec(conn,buffer);
  g_free(buffer);

  nbtuples = PQntuples(qryResult);
  if (nbtuples>0)
  {
    widget=lookup_widget(metadatawindow,"spatial_rep_type_code");
    for (i=0;i<nbtuples;i++)
    {
      buffer = PQgetvalue(qryResult,i,2);
      gtk_clist_select_row(GTK_CLIST(widget),atoi(buffer),0);
    }

    
  }
  PQclear(qryResult);  
  /* end of f_catalogue_spatial_rep_type_code */

  
  g_free(oid);
  return;
}

void
FM_Save_MetaData                 (GtkWidget     *metadatawindow)
{
  gchar *buffer;
  gchar *buffer2;
  gchar *text;
  PGresult *qryResult;
  GtkWidget *widget;
  gboolean boid;
  gchar *oid;

  g_return_if_fail(metadatawindow!=NULL);

  widget=lookup_widget(metadatawindow,"oid");
  text=gtk_entry_get_text(GTK_ENTRY(widget)); 

  if (strcmp(text,"")==0)
  {
        boid=FALSE;
  } else
  {
        boid=TRUE;
  }
  oid=g_strdup(text);

  widget=lookup_widget(metadatawindow,"meta_file_id");
  text=gtk_entry_get_text(GTK_ENTRY(widget));
  if (boid)
  {
        buffer=g_strdup_printf("meta_file_id = '%s',",text);
  } else
  {
    buffer=g_strdup_printf("'%s',",text);
  }
    
  widget=lookup_widget(metadatawindow,"meta_parent_id");
  text=gtk_entry_get_text(GTK_ENTRY(widget));
  if (boid)
  {
        buffer2=g_strdup_printf("%s meta_parent_id = '%s',",buffer,text);
  } else
  {
    buffer2=g_strdup_printf("%s'%s',",buffer,text);
  }
  g_free(buffer);
  
  widget=lookup_widget(metadatawindow,"title");
  text=gtk_entry_get_text(GTK_ENTRY(widget));
  if (boid)
  {
        buffer=g_strdup_printf("%s title = '%s',",buffer2,text);
  } else
  {
    buffer=g_strdup_printf("%s'%s',",buffer2,text);
  }
  g_free(buffer2);
      
  widget=lookup_widget(metadatawindow,"edition");
  text=gtk_entry_get_text(GTK_ENTRY(widget));
  if (boid)
  {
        buffer2=g_strdup_printf("%s edition = '%s',",buffer,text);
  } else
  {
    buffer2=g_strdup_printf("%s'%s',",buffer,text);
  }
  g_free(buffer);
        
  widget=lookup_widget(metadatawindow,"series");
  text=gtk_entry_get_text(GTK_ENTRY(widget));
  if (boid)
  {
        buffer=g_strdup_printf("%s series = '%s',",buffer2,text);
  } else
  {
    buffer=g_strdup_printf("%s'%s',",buffer2,text);
  }
  g_free(buffer2);
        
  widget=lookup_widget(metadatawindow,"issue_id");
  text=gtk_entry_get_text(GTK_ENTRY(widget));      
  if (boid)
  {
        buffer2=g_strdup_printf("%s issue_id = '%s'",buffer,text);
  } else
  {
    buffer2=g_strdup_printf("%s'%s'",buffer,text);
  }
  g_free(buffer);
  
  if (boid)
  {
        /* there is plenty to do here: check if the name_file_id has changed and update table names accordingly */
    buffer=g_strdup_printf("UPDATE f_catalogue SET %s WHERE oid=%s",buffer2,oid);
  } else
  {
    buffer=g_strdup_printf("INSERT INTO f_catalogue (meta_file_id,meta_parent_id,title,edition,series,issue_id) VALUES (%s)",buffer2);  
  }
  qryResult = PQexec(conn,buffer);

  /* debug */
  if (!(g_str_equal(PQresultErrorMessage(qryResult),"")))
  {
    g_warning("%s : %s",buffer, PQresultErrorMessage(qryResult));
  }

  if (!boid)
  {
        text = (gchar *) PQoidStatus(qryResult);
        widget = lookup_widget(metadatawindow,"oid");
    gtk_entry_set_text(GTK_ENTRY(widget),text);
  }

  g_free(buffer);
  PQclear(qryResult);
    
  g_free(buffer2);
  
  g_free(oid);

  return;
}       

---