#include <gnome.h>
#include "gxsnmp.h"

#include "dbapi.h"
#include "ddserver.h"

GxSNMP_GSQLDB_RowInterface *
impl_GetRowInterface(PortableServer_Servant servant, 
                CORBA_Environment *ev)
{

G_sql *sql;
impl_POA_GxSNMP_GSQLDB *newservant;
gpointer data;
GxSNMP_GSQLDB_RowInterface *row;
gchar nulstr[] = "";
gchar nulint = 0;


	newservant = servant;
	sql = newservant->sql;
	row = GxSNMP_GSQLDB_RowInterface__alloc();
	memset(row, 0, sizeof(row));

	if(g_sql_next_row(sql) == FALSE){ /*stupid*/
		goto fail;
	}


	/* Move database row to the corba row */
	data = g_sql_field_pos(sql, 0); /* get field data */
	if(!(row->objid = strtol(data,0,0))) data = &nulint;  /* assign to corba field */

	if(!(data = g_sql_field_pos(sql, 1))) data = nulstr;
	row->created = CORBA_string_dup(data);

	if(!(data = g_sql_field_pos(sql, 2))) data = nulstr;
	row->modified = CORBA_string_dup(data);

	data = g_sql_field_pos(sql, 4); 
	if(!(row->host = strtol(data,0,0))) data = &nulint;

	data = g_sql_field_pos(sql, 5); 
	if(!(row->snmp = strtol(data,0,0))) data = &nulint;

	data = g_sql_field_pos(sql, 6); 
	if(!(row->transport = strtol(data,0,0))) data = &nulint;

	if(!(data = g_sql_field_pos(sql, 7))) data = nulstr;
	row->address = CORBA_string_dup(data);

	if(!(data = g_sql_field_pos(sql, 8))) data = nulstr;
	row->netmask = CORBA_string_dup(data);

	if(!(data = g_sql_field_pos(sql, 9))) data = nulstr;
	row->name = CORBA_string_dup(data);

	if(!(data = g_sql_field_pos(sql, 10))) data = nulstr;
	row->tags = CORBA_string_dup(data);

	return row;

fail: /* I CANT RESOLV, CLIENT GETS ev._major EXCEPTION correctly, BUT WE CORE DUMP****/
	return row;
}