File: sqlptest.c

package info (click to toggle)
grass 6.4.4-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 104,028 kB
  • ctags: 40,409
  • sloc: ansic: 419,980; python: 63,559; tcl: 46,692; cpp: 29,791; sh: 18,564; makefile: 7,000; xml: 3,505; yacc: 561; perl: 559; lex: 480; sed: 70; objc: 7
file content (55 lines) | stat: -rw-r--r-- 979 bytes parent folder | download | duplicates (7)
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
#include <stdlib.h>
#include <string.h>
#include <grass/gis.h>
#include <grass/dbmi.h>
#include <grass/sqlp.h>

int main(int argc, char **argv)
{
    SQLPSTMT *st;
    char buf[5000], buf2[5000];
    dbString stmt;
    int len;


    st = sqpInitStmt();

    db_init_string(&stmt);

    while (fgets(buf, 5000, stdin)) {
	fprintf(stdout, "\nInput row: -->>%s<<--\n", buf);
	strcpy(buf2, buf);
	G_chop(buf2);
	len = strlen(buf2);

	if (buf2[len - 1] == ';') {	/* end of statement */
	    buf2[len - 1] = 0;	/* truncate ';' */
	    db_append_string(&stmt, buf2);

	    st->stmt = db_get_string(&stmt);
	    sqpInitParser(st);

	    fprintf(stdout, "Input statement: -->>%s<<--\n", st->stmt);

	    if (yyparse() != 0) {
		fprintf(stdout,
			"Error: statement was not parsed successfully.\n");
		sqpFreeStmt(st);
		return (1);
	    }

	    sqpPrintStmt(st);

	    db_zero_string(&stmt);

	}
	else {
	    db_append_string(&stmt, buf);
	}
    }


    sqpFreeStmt(st);

    exit(0);
}