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