static char *rcsid_increment_dc = "$Header$";
#endif lint
+#include <fcntl.h>
#include <mit-copyright.h>
#include <moira.h>
#include "query.h"
#include "mr_server.h"
-EXEC SQL INCLUDE sqlca
+EXEC SQL INCLUDE sqlca;
extern char *whoami;
-char *malloc();
int inc_pid = 0;
int inc_running = 0;
#define MAXARGC 15
+EXEC SQL WHENEVER SQLERROR CALL ingerr;
+
/* structures to save before args */
static char beforeb[MAXARGC][ARGLEN];
static char *before[MAXARGC];
incremental_before(table, qual, argv)
char *table;
+EXEC SQL BEGIN DECLARE SECTION;
char *qual;
+EXEC SQL END DECLARE SECTION;
char **argv;
{
EXEC SQL BEGIN DECLARE SECTION;
beforetable = table;
if (!strcmp(table, "users")) {
-/*
- * retrieve (barg0 = u.login, barg1 = text(u.uid),
- * barg2 = u.shell, barg3 = u.last, barg4 = u.first,
- * barg5 = u.middle, barg6 = text(u.status),
- * barg7 = u.mit_id, barg8 = u.mit_year)
- * where qual
- */
- EXEC SQL SELECT login, uid, shell, last, first, middle,
- text(u.status), mit_id, mit_year
- FROM users WHERE :qual;
+ EXEC SQL SELECT u.login, CHAR(u.uid), u.shell, u.last, u.first, u.middle,
+ CHAR(u.status), u.clearid, u.type
+ INTO :barg0, :barg1, :barg2, :barg3, :barg4, :barg5, :barg6,
+ :barg7, :barg8
+ FROM users u WHERE :qual;
beforec = 9;
} else if (!strcmp(table, "machine")) {
-## retrieve (barg0 = m.name, barg1 = m.type) where qual
+ EXEC SQL SELECT m.name, m.vendor INTO :barg0, :barg1 FROM machine m
+ WHERE :qual;
beforec = 2;
} else if (!strcmp(table, "cluster")) {
-## retrieve (barg0 = c.name, barg1 = c.desc, barg2 = c.location)
-## where qual
+ EXEC SQL SELECT c.name, c.description, c.location
+ INTO :barg0, :barg1, :barg2
+ FROM cluster c WHERE :qual;
beforec = 3;
} else if (!strcmp(table, "mcmap")) {
strcpy(barg0, argv[0]);
strcpy(barg2, argv[2]);
beforec = 3;
} else if (!strcmp(table, "filesys")) {
-## range of fs is filesys
-## retrieve (barg0 = fs.label, barg1 = fs.type, barg2 = text(fs.mach_id),
-## barg3 = fs.name, barg4 = fs.mount, barg5 = fs.access,
-## barg6 = fs.comments, barg7 = text(fs.owner),
-## barg8 = text(fs.owners), barg9 = text(fs.createflg),
-## barg10 = fs.lockertype)
-## where qual
+ EXEC SQL SELECT fs.label, fs.type, CHAR(fs.mach_id), fs.name,
+ fs.mount, fs.access, fs.comments, CHAR(fs.owner), CHAR(fs.owners),
+ CHAR(fs.createflg), fs.lockertype
+ INTO :barg0, :barg1, :barg2, :barg3, :barg4, :barg5, :barg6,
+ :barg7, :barg8, :barg9, :barg10
+ FROM filesys fs WHERE :qual;
+ name = malloc(0);
+ id = atoi(barg2);
+ id_to_name(id, "MACHINE", &name);
+ strcpy(barg2, name);
+ id = atoi(barg7);
+ id_to_name(id, "USER", &name);
+ strcpy(barg7, name);
+ id = atoi(barg8);
+ id_to_name(id, "LIST", &name);
+ strcpy(barg8, name);
+ free(name);
beforec = 11;
} else if (!strcmp(table, "quota")) {
strcpy(barg0, "?");
strcpy(barg1, argv[1]);
strcpy(barg2, "?");
- sprintf(buffer, "%s and filesys.filsys_id = q.filsys_id", qual);
+ sprintf(buffer, "%s AND fs.filsys_id = q.filsys_id", qual);
qual = buffer;
-## range of q is quota
-## retrieve (barg3 = text(q.quota), barg4 = filesys.name) where qual
+ EXEC SQL SELECT CHAR(q.quota), fs.name INTO :barg3, :barg4
+ FROM quota q, filesys fs WHERE :qual;
beforec = 5;
} else if (!strcmp(table, "list")) {
-## retrieve (barg0 = l.name, barg1 = text(l.active),
-## barg2 = text(l.public), barg3 = text(l.hidden),
-## barg4 = text(l.maillist), barg5 = text(l.group),
-## barg6 = text(l.gid), barg7 = l.acl_type,
-## barg8 = text(l.acl_id), barg9 = l.desc)
-## where qual
+ EXEC SQL SELECT l.name, CHAR(l.active), CHAR(l.publicflg),
+ CHAR(l.hidden), CHAR(l.maillist), CHAR(l.grouplist), CHAR(l.gid),
+ l.acl_type, CHAR(l.acl_id), l.description
+ INTO :barg0, :barg1, :barg2, :barg3, :barg4, :barg5, :barg6,
+ :barg7, :barg8, :barg9
+ FROM list l WHERE :qual;
beforec = 10;
} else if (!strcmp(table, "members")) {
id = (int) argv[0];
-## retrieve (barg3 = text(list.group)) where list.list_id = id
+ EXEC SQL SELECT CHAR(active), CHAR(publicflg), CHAR(hidden),
+ CHAR(maillist), CHAR(grouplist), CHAR(gid)
+ INTO :barg3, :barg4, :barg5, :barg6, :barg7, :barg8
+ FROM list WHERE list_id = :id;
name = malloc(0);
id_to_name(id, "LIST", &name);
strcpy(barg0, name);
strcpy(barg1, argv[1]);
id = (int) argv[2];
+ beforec = 9;
if (!strcmp(barg1, "USER")) {
id_to_name(id, barg1, &name);
+ EXEC SQL SELECT CHAR(status) INTO :barg9 FROM users
+ WHERE users_id=:id;
+ beforec = 10;
} else if (!strcmp(barg1, "LIST")) {
id_to_name(id, barg1, &name);
} else if (!strcmp(barg1, "STRING")) {
}
strcpy(barg2, name);
free(name);
- beforec = 4;
} /* else
com_err(whoami, 0, "unknown table in incremental_before"); */
-##}
+}
incremental_clear_before()
-##incremental_after(table, qual, argv)
-##char *table;
-##char *qual;
+incremental_after(table, qual, argv)
+char *table;
+EXEC SQL BEGIN DECLARE SECTION;
+char *qual;
+EXEC SQL END DECLARE SECTION;
char **argv;
-##{
+{
char buffer[2048], *name;
-## int id, i;
+EXEC SQL BEGIN DECLARE SECTION;
+ int id, i;
+EXEC SQL END DECLARE SECTION;
struct iupdate *iu;
char **copy_argv();
if (!strcmp(table, "users")) {
-## retrieve (aarg0 = u.login, aarg1 = text(u.uid),
-## aarg2 = u.shell, aarg3 = u.last, aarg4 = u.first,
-## aarg5 = u.middle, aarg6 = text(u.status),
-## aarg7 = u.mit_id, aarg8 = u.mit_year)
-## where qual
+ EXEC SQL SELECT u.login, CHAR(u.uid), u.shell, u.last, u.first,
+ u.middle, CHAR(u.status), u.clearid, u.type
+ INTO :aarg0, :aarg1, :aarg2, :aarg3, :aarg4, :aarg5,
+ :aarg6, :aarg7, :aarg8
+ FROM users u WHERE :qual;
afterc = 9;
} else if (!strcmp(table, "machine")) {
-## retrieve (aarg0 = m.name, aarg1 = m.type) where qual
+ EXEC SQL SELECT m.name, m.vendor INTO :aarg0, :aarg1
+ FROM machine m WHERE :qual;
afterc = 2;
} else if (!strcmp(table, "cluster")) {
-## retrieve (aarg0 = c.name, aarg1 = c.desc, aarg2 = c.location)
-## where qual
+ EXEC SQL SELECT c.name, c.description, c.location
+ INTO :aarg0, :aarg1, :aarg2
+ FROM cluster c WHERE :qual;
afterc = 3;
} else if (!strcmp(table, "mcmap")) {
strcpy(aarg0, argv[0]);
strcpy(aarg2, argv[2]);
afterc = 3;
} else if (!strcmp(table, "filesys")) {
-## range of fs is filesys
-## retrieve (aarg0 = fs.label, aarg1 = fs.type,
-## aarg2 = text(fs.mach_id),
-## aarg3 = fs.name, aarg4 = fs.mount, aarg5 = fs.access,
-## aarg6 = fs.comments, aarg7 = text(fs.owner),
-## aarg8 = text(fs.owners), aarg9 = text(fs.createflg),
-## aarg10 = fs.lockertype)
-## where qual
+ EXEC SQL SELECT CHAR(fs.label), fs.type, CHAR(fs.mach_id), fs.name,
+ fs.mount, fs.access, fs.comments, CHAR(fs.owner), CHAR(fs.owners),
+ CHAR(fs.createflg), fs.lockertype
+ INTO :aarg0, :aarg1, :aarg2, :aarg3, :aarg4, :aarg5, :aarg6,
+ :aarg7, :aarg8, :aarg9, :aarg10
+ FROM filesys fs WHERE :qual;
+ name = malloc(0);
+ id = atoi(aarg2);
+ id_to_name(id, "MACHINE", &name);
+ strcpy(aarg2, name);
+ id = atoi(aarg7);
+ id_to_name(id, "USER", &name);
+ strcpy(aarg7, name);
+ id = atoi(aarg8);
+ id_to_name(id, "LIST", &name);
+ strcpy(aarg8, name);
+ free(name);
afterc = 11;
} else if (!strcmp(table, "quota")) {
strcpy(aarg0, "?");
strcpy(aarg1, argv[1]);
strcpy(aarg2, "?");
- sprintf(buffer, "%s and filesys.filsys_id = q.filsys_id", qual);
+ sprintf(buffer, "%s and fs.filsys_id = q.filsys_id and q.type = '%s'",
+ qual, argv[1]);
qual = buffer;
-## range of q is quota
-## retrieve (aarg3 = text(q.quota), aarg4 = filesys.name) where qual
+ EXEC SQL SELECT CHAR(q.quota), fs.name INTO :aarg3, :aarg4
+ FROM quota q, filesys fs WHERE :qual;
afterc = 5;
} else if (!strcmp(table, "list")) {
-## retrieve (aarg0 = l.name, aarg1 = text(l.active),
-## aarg2 = text(l.public), aarg3 = text(l.hidden),
-## aarg4 = text(l.maillist), aarg5 = text(l.group),
-## aarg6 = text(l.gid), aarg7 = l.acl_type,
-## aarg8 = text(l.acl_id), aarg9 = l.desc)
-## where qual
+ EXEC SQL SELECT l.name, CHAR(l.active), CHAR(l.publicflg),
+ CHAR(l.hidden), CHAR(l.maillist), CHAR(l.grouplist), CHAR(l.gid),
+ l.acl_type, CHAR(l.acl_id), l.description
+ INTO :aarg0, :aarg1, :aarg2, :aarg3, :aarg4, :aarg5, :aarg6,
+ :aarg7, :aarg8, :aarg9
+ FROM list l WHERE :qual;
afterc = 10;
} else if (!strcmp(table, "members")) {
id = (int) argv[0];
-## retrieve (aarg3 = text(list.group)) where list.list_id = id
+ EXEC SQL SELECT CHAR(active), CHAR(publicflg), CHAR(hidden),
+ CHAR(maillist), CHAR(grouplist), CHAR(gid)
+ INTO :aarg3, :aarg4, :aarg5, :aarg6, :aarg7, :aarg8
+ FROM list WHERE list_id = :id;
name = malloc(0);
id_to_name(id, "LIST", &name);
strcpy(aarg0, name);
strcpy(aarg1, argv[1]);
id = (int) argv[2];
+ afterc = 9;
if (!strcmp(aarg1, "USER")) {
id_to_name(id, aarg1, &name);
+ EXEC SQL SELECT CHAR(status) INTO :aarg9 FROM users
+ WHERE users_id=:id;
+ afterc = 10;
} else if (!strcmp(aarg1, "LIST")) {
id_to_name(id, aarg1, &name);
} else if (!strcmp(aarg1, "STRING")) {
}
strcpy(aarg2, name);
free(name);
- afterc = 4;
} else if (!strcmp(table, "clear")) {
afterc = 0;
table = beforetable;
strcat(buffer, "])");
com_err(whoami, 0, buffer);
#endif DEBUG
-##}
+}
/* Called when the current transaction is committed to start any queued
if (!inited) {
inited++;
- EXEC SQL DECLARE inc CURSOR FOR SELECT table, service FROM incremental;
+ EXEC SQL DECLARE inc CURSOR FOR SELECT tablename, service FROM incremental;
EXEC SQL OPEN inc;
while (1) {
EXEC SQL FETCH inc INTO :tab, :serv;
cache = c;
}
EXEC SQL CLOSE inc;
+ EXEC SQL COMMIT WORK;
}
while (sq_remove_data(incremental_sq, &iu)) {
switch (inc_pid) {
case 0:
execv(prog, argv);
- exit(1);
+ _exit(1);
case -1:
com_err(whoami, 0, "Failed to start incremental update");
break;