1 /***************************************************************************** 2 * sql.h 3 ***************************************************************************** 4 * conversion of dbf files to sql 5 * 6 * Version 0.2, 2003-09-08 7 * Author: Dr Georg Roesler, groesle@gwdg.de 8 * 9 * History: 10 * 2003-09-08 teterin,berg Fixing some errors in the produced SQL statements 11 * Support for MySQL and PostGres 12 * 2003-02-24 jones some minor changes 13 * - Version 0.1 - February 2003 14 * first implementation in dbf.c 15 ******************************************************************************/ 16 17 #ifndef _SQL_H_ 18 #define _SQL_H_ 19 20 #include "dbf.h" 21 22 int setNoDrop (FILE *fp, P_DBF *p_dbf, 23 const char *input, const char *separator); 24 int setNoCreate (FILE *fp, P_DBF *p_dbf, 25 const char *input, const char *separator); 26 int setSQLTrim(FILE *fp, P_DBF *p_dbf, 27 const char *filename, const char *mode); 28 int setSQLUsecopy(FILE *fp, P_DBF *p_dbf, 29 const char *filename, const char *mode); 30 int setSQLEmptyStrIsNULL(FILE *fp, P_DBF *p_dbf, 31 const char *filename, const char *mode); 32 int writeSQLHeader(FILE *fp, P_DBF *p_dbf, 33 const char *filename, const char *export_filename); 34 int writeSQLFooter(FILE *fp, P_DBF *p_dbf, 35 const char *filename, const char *export_filename); 36 int writeSQLLine(FILE *fp, P_DBF *p_dbf, 37 const unsigned char *value, int header_length, 38 const char *filename, const char *export_filename); 39 40 #endif 41