[Perfparse-cvs] _perfparse/db_tools convert.c,1.5,1.6

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

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

Modified Files:
	convert.c 
Log Message:
start db conversion program


Index: convert.c
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/db_tools/convert.c,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** convert.c	2 Dec 2006 21:31:09 -0000	1.5
--- convert.c	5 Dec 2006 22:17:10 -0000	1.6
***************
*** 138,162 ****
  	GString *querystr=g_string_new("");
  	char *resultstr;
! 	regex_t *preg;
  	char regex[512];
! 	size_t nmatch;
  	regmatch_t pmatch[10];
  	int i;
  
  	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=result_row[0];
  		printf("Resultstring: %s\n",resultstr);
! 		snprintf(regex,511,"CONSTRAINT `(\\S+)` FOREIGN KEY \\S+ REFERENCES `%s`",ForeignTableName);
  		printf("Using regex to find FK: %s\n",regex);
! 		regcomp(preg, regex,REG_EXTENDED|REG_ICASE);
! 		regexec(preg,resultstr,nmatch,pmatch,0);
! 		for (i=0;i<=nmatch;i++) {
  			printf("Match %d so: %d, eo:%d\n",i,pmatch[i].rm_so,pmatch[i].rm_eo);
  		}
--- 138,161 ----
  	GString *querystr=g_string_new("");
  	char *resultstr;
! 	regex_t preg_struct;
! 	regex_t *preg=&preg_struct;
  	char regex[512];
! 	size_t nmatch=0;
  	regmatch_t pmatch[10];
  	int i;
  
+ 	
  	g_string_printf(querystr,"show create table %s",TableName);
  	query(querystr->str);
  	while ((result_row = mysql_fetch_row(query_result))) {
! 		resultstr=result_row[1];
  		printf("Resultstring: %s\n",resultstr);
! 		snprintf(regex,511,".*CONSTRAINT `(\\S+)` FOREIGN KEY \\S+ REFERENCES `%s`.*",ForeignTableName);
  		printf("Using regex to find FK: %s\n",regex);
! 		i=regcomp(preg, regex,REG_EXTENDED|REG_ICASE);
! 		printf("Returncode compiling the pattern is %d\n",i);
! 		i=regexec(preg,resultstr,nmatch,pmatch,REG_NOTEOL);
! 		printf("Returncode matching the pattern is %d\n",i);
! 		for (i=0;i<nmatch;i++) {
  			printf("Match %d so: %d, eo:%d\n",i,pmatch[i].rm_so,pmatch[i].rm_eo);
  		}