[Perfparse-cvs] _perfparse/db_tools convert.c, 1.3, 1.4 convert.h, 1.1.1.1, 1.2

[Florian G. <re...@us...>]

Update of /cvsroot/perfparse/_perfparse/db_tools
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1270/db_tools

Modified Files:
	convert.c convert.h 
Log Message:
some small changes


Index: convert.c
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/db_tools/convert.c,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** convert.c	29 Oct 2006 22:29:34 -0000	1.3
--- convert.c	30 Oct 2006 21:35:06 -0000	1.4
***************
*** 112,115 ****
--- 112,116 ----
  		printf(_("Creating new group table:\n"));
  		query("create table perfdata_groups (group_id INT AUTO_INCREMENT PRIMARY KEY, group_name VARCHAR(75) UNIQUE) type=InnoDB select group_name from perfdata_host_group");
+ 		DropForeignKey("perfdata_host","perfdata_host_group");
  		query("drop table perfdata_host_group");
  		}
***************
*** 135,141 ****
  void DropForeignKey(char *TableName, char *ForeignTableName) {
  	GString *querystr=g_string_new("");
! 	GString *resultstr=g_string_new("");
  	g_string_printf(querystr,"show create table %s",TableName);
! 	query(querystr);
  }
  
--- 136,151 ----
  void DropForeignKey(char *TableName, char *ForeignTableName) {
  	GString *querystr=g_string_new("");
! 	GString *resultstr;
  	g_string_printf(querystr,"show create table %s",TableName);
! 	query(querystr->str);
! 	#ifdef USE_DB_MYSQL
! 	while ((result_row = mysql_fetch_row(query_result))) {
! 	#elif defined USE_DB_POSTGRESQL
! 	numberOfRows = rows();
! 	for (currentRow=0;currentRow<numberOfRows;currentRow++){
! 	#endif	
! 		resultstr=g_string_new(result_row[0]);
! 		printf("Resultstring: %s\n",resultstr->str);
! 	}
  }
  

Index: convert.h
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/db_tools/convert.h,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** convert.h	26 Sep 2005 14:36:33 -0000	1.1.1.1
--- convert.h	30 Oct 2006 21:35:06 -0000	1.2
***************
*** 4,8 ****
   *
   * Copyright (c) 2004 Ben Clewett (per...@cl...)
!  * Last Modified:   2004-05-28
   *
   * License:
--- 4,8 ----
   *
   * Copyright (c) 2004 Ben Clewett (per...@cl...)
!  * $Id$
   *
   * License:
***************
*** 31,34 ****
--- 31,35 ----
  void autoConvert();
  void install_database(void);
+ void DropForeignKey(char *TableName, char *ForeignTableName);
  
  #endif