9 #include <moira_site.h>
10 EXEC SQL INCLUDE sqlca;
28 struct entry *e, *get_next_entry();
30 char buf[BUFSIZ], *file = NULL, *p, *p1;
33 whoami = rindex(argv[0], '/');
39 for (i = 1; i < argc; i++) {
40 if (!strcmp(argv[i], "-w"))
42 else if (!strcmp(argv[i], "-D"))
43 setenv("ING_SET", "set printqry");
44 else if (!strcmp(argv[i], "-d"))
46 else if (file != NULL)
47 fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami);
52 in = fopen(file, "r");
54 fprintf(stderr, "Unable to open %s for input\n", file);
61 EXEC SQL CONNECT moira;
62 if (sqlca.sqlcode != 0) {
63 com_err(whoami, 0, "ingres error %d", sqlca.sqlcode);
67 while (e = get_next_entry(in)) {
72 for (p1 = e->login; *p1; p1++)
74 for (; p < &(e->line[10]); p++)
76 fputs(e->line, stdout);
90 struct entry *get_next_entry(in)
93 static struct entry e;
94 static char buf[BUFSIZ];
96 if (fgets(buf, sizeof(buf), in) == NULL)
97 return((struct entry *)NULL);
100 strncpy(e.id, &buf[0], 9);
110 EXEC SQL BEGIN DECLARE SECTION;
112 EXEC SQL END DECLARE SECTION;
116 EXEC SQL REPEATED SELECT login INTO :login FROM users
118 if (sqlca.sqlcode != 0) {
119 fprintf(stderr, "Error %d on %s\n", sqlca.sqlcode, e->line);
122 strncpy(e->login, login, 8);
125 printf("Got username %s\n", login);