dbtoy/xml_format.c at master · drotiro/dbtoy · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
#include "xml_format.h"

#include <stdio.h>
#include <syslog.h>

#define VAL 1
#define ONOFF 2

static char * XMLSTART = "<?xml version=\"1.0\" ?>\n"
			"<!-- Created by DBToy http://freshmeat.net/projects/dbtoy -->\n";
/* types */
static char * TYPES_PROLOGUE = "<columns ";
static char * TYPES_EPILOGUE = "</columns>\n";
static char * COL_START = "\t<column ";
static char * ATTRS[] = {"sqlType","primaryKey"};
static int ATTR_TYPES[] = {VAL, ONOFF};
static char * COL_END = "</column>\n";
#define NATTRS (sizeof(ATTRS)/sizeof(ATTRS[0]))
#define ROWLEN (NATTRS+1)
/* data */
static char * DATA_PROLOGUE = "<rows ";
static char * DATA_EPILOGUE = "\n</rows>\n";
static char * DATA_ERROR_START = "\n\t<error>";
static char * DATA_ERROR_END = "</error>";
static char * ROW_START = "\n\t<row>";
static char * ROW_END = "\n\t</row>";
static char * DATA_START = "\n\t\t<";
static char * DATA_END = "</";
static char * TAG_CLOSE=">";
static char * CDATA_START = "<![CDATA[";
static char * CDATA_END = "]]>";

char * format_types(char ** types, int n_types, const char * prolog, char * name, char * tabname)
{
		int i, j;
		char * res;
		struct lt * l = lt_new();

		lt_cat(l,XMLSTART);
		if(prolog) {
			lt_cat(l,prolog);
			lt_cat(l,"\n");
		}
		lt_cat(l,TYPES_PROLOGUE);
		lt_cat(l,"schema=\"");
		lt_cat(l,name);
		lt_cat(l,"\" table=\"");
		lt_cat(l,tabname);
		lt_cat(l,"\">\n");
		for(i = 0; i < n_types; ++i)
		{
		  lt_cat(l,COL_START);
			/*attrs...*/
			for(j =0; j< NATTRS; ++j)
			{
				switch(ATTR_TYPES[j]) {
					case VAL:
						lt_cat(l,ATTRS[j]);
						lt_cat(l,"=\"");
						lt_cat(l,types[i*ROWLEN+j+1]);
						lt_cat(l,"\" ");
						break;
					case ONOFF:
						if(*types[i*ROWLEN+j+1]) {
							lt_cat(l,ATTRS[j]);
							lt_cat(l,"=\"yes\"");
						}
						break;
				}
			}
			lt_cat(l,">");
			lt_cat(l,types[i*ROWLEN]);
			lt_cat(l,COL_END);
		}
		lt_cat(l,TYPES_EPILOGUE);
		res = lt_text(l);
		lt_free(l);
		return res;
}

void format_data_start(struct lt * l, const char * prolog, char * xname, char * xtabname)
{
		lt_cat(l,XMLSTART);
		if(prolog) {
			lt_cat(l,prolog);
			lt_cat(l,"\n");
		}
		lt_cat(l,DATA_PROLOGUE);
		lt_cat(l,"schema=\"");
		lt_cat(l,xname);
		lt_cat(l,"\" table=\"");
		lt_cat(l,xtabname);
		lt_cat(l,"\">");
}

void format_data_end(struct lt * l)
{
                lt_cat(l,DATA_EPILOGUE);
}

void format_data_error(struct lt * l, DBTOY_NAME msg)
{
	lt_cat(l, DATA_ERROR_START);
	lt_cat(l, msg);
	lt_cat(l, DATA_ERROR_END);
}

void format_data_next(struct lt * l, DBTOY_ROW row, int len, int cdata[], char * label[])
{
	int j;

	lt_cat(l,ROW_START);
	for(j=0; j<len; ++j)
	{
		lt_cat(l,DATA_START); lt_cat(l,label[j]); lt_cat(l,TAG_CLOSE);
		if(cdata[j]) lt_cat(l,CDATA_START);
		lt_cat(l,row[j]);
		if(cdata[j]) lt_cat(l,CDATA_END);
		lt_cat(l,DATA_END); lt_cat(l,label[j]); lt_cat(l,TAG_CLOSE);
	}
        lt_cat(l,ROW_END);
}