put the name of the database in a variable

[moira.git] / server / increment.dc

diff --git a/server/increment.dc b/server/increment.dc
index 3e121fe3210091527e06876f3fe03db6520b28a1..555ed7e8a4ddee1a404a3968583d3d38929640ae 100644 (file)
--- a/server/increment.dc
+++ b/server/increment.dc
@@ -13,6 +13,7 @@
 static char *rcsid_increment_dc = "$Header$";
 #endif lint
 
+#include <fcntl.h>
 #include <mit-copyright.h>
 #include <moira.h>
 #include "query.h"
@@ -125,20 +126,20 @@ char **argv;
     beforetable = table;
 
     if (!strcmp(table, "users")) {
-       EXEC SQL SELECT login, CHAR(uid), shell, last, first, middle, 
-           CHAR(status), clearid, type
+       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 WHERE :qual;
+         FROM users u WHERE :qual;
        beforec = 9;
     } else if (!strcmp(table, "machine")) {
-       EXEC SQL SELECT name, type INTO :barg0, :barg1 FROM machine
+       EXEC SQL SELECT m.name, m.type INTO :barg0, :barg1 FROM machine m
          WHERE :qual;
        beforec = 2;
     } else if (!strcmp(table, "cluster")) {
-       EXEC SQL SELECT name, description, location 
+       EXEC SQL SELECT c.name, c.description, c.location 
          INTO :barg0, :barg1, :barg2
-         FROM cluster WHERE :qual;
+         FROM cluster c WHERE :qual;
        beforec = 3;
     } else if (!strcmp(table, "mcmap")) {
        strcpy(barg0, argv[0]);
@@ -150,11 +151,12 @@ char **argv;
        strcpy(barg2, argv[2]);
        beforec = 3;
     } else if (!strcmp(table, "filesys")) {
-       EXEC SQL SELECT label, type, CHAR(mach_id), name, mount, access,
-           comments, CHAR(owner), CHAR(owners), CHAR(createflg), lockertype
+       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 WHERE :qual;
+         FROM filesys fs WHERE :qual;
         name = malloc(0);
         id = atoi(barg2);
         id_to_name(id, "MACHINE", &name);
@@ -171,18 +173,18 @@ char **argv;
        strcpy(barg0, "?");
        strcpy(barg1, argv[1]);
        strcpy(barg2, "?");
-       sprintf(buffer, "%s and fs.filsys_id = q.filsys_id", qual);
+       sprintf(buffer, "%s AND fs.filsys_id = q.filsys_id", qual);
        qual = buffer;
-       EXEC SQL SELECT q.quota, fs.name INTO :barg3, :barg4
+       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")) {
-       EXEC SQL SELECT name, CHAR(active), CHAR(publicflg), CHAR(hidden),
-           CHAR(maillist), CHAR(grouplist), CHAR(gid), acl_type,
-           CHAR(acl_id), description
+       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 WHERE :qual;
+           :barg7, :barg8, :barg9
+         FROM list l WHERE :qual;
        beforec = 10;
     } else if (!strcmp(table, "members")) {
        id = (int) argv[0];
@@ -231,26 +233,27 @@ char **argv;
 {
     char buffer[2048], *name;
 EXEC SQL BEGIN DECLARE SECTION; 
+    char *type;
     int id, i;
 EXEC SQL END DECLARE SECTION; 
     struct iupdate *iu;
     char **copy_argv();
 
     if (!strcmp(table, "users")) {
-       EXEC SQL SELECT login, CHAR(uid), shell, last, first, middle,
-           CHAR(status), clearid, type
+       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 WHERE :qual;
+         FROM users u WHERE :qual;
        afterc = 9;
     } else if (!strcmp(table, "machine")) {
-       EXEC SQL SELECT name, type INTO :aarg0, :aarg1
-         FROM machine WHERE :qual;
+       EXEC SQL SELECT m.name, m.type INTO :aarg0, :aarg1
+         FROM machine m WHERE :qual;
        afterc = 2;
     } else if (!strcmp(table, "cluster")) {
-       EXEC SQL SELECT name, description, location 
+       EXEC SQL SELECT c.name, c.description, c.location 
          INTO :aarg0, :aarg1, :aarg2
-         FROM cluster WHERE :qual;
+         FROM cluster c WHERE :qual;
        afterc = 3;
     } else if (!strcmp(table, "mcmap")) {
        strcpy(aarg0, argv[0]);
@@ -262,8 +265,9 @@ EXEC SQL END DECLARE SECTION;
        strcpy(aarg2, argv[2]);
        afterc = 3;
     } else if (!strcmp(table, "filesys")) {
-        EXEC SQL SELECT CHAR(label), type, CHAR(mach_id), name, mount, access,
-           comments, CHAR(owner), CHAR(owners), CHAR(createflg), lockertype
+        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;
@@ -283,18 +287,23 @@ EXEC SQL END DECLARE SECTION;
        strcpy(aarg0, "?");
        strcpy(aarg1, argv[1]);
        strcpy(aarg2, "?");
-       sprintf(buffer, "%s and fs.filsys_id = q.filsys_id", qual);
+       if (!strcmp(argv[1], "ANY"))
+         type = "NONE";
+       else
+         type = argv[1];
+       sprintf(buffer, "%s and fs.filsys_id = q.filsys_id and q.type = '%s'",
+               qual, type);
        qual = buffer;
        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")) {
-       EXEC SQL SELECT name, CHAR(active), CHAR(publicflg), CHAR(hidden),
-           CHAR(maillist), CHAR(grouplist), CHAR(gid), acl_type,
-           CHAR(acl_id), description
+       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 WHERE :qual;
+         FROM list l WHERE :qual;
        afterc = 10;
     } else if (!strcmp(table, "members")) {
        id = (int) argv[0];
@@ -393,6 +402,7 @@ incremental_update()
            cache = c;
        }
        EXEC SQL CLOSE inc;
+       EXEC SQL COMMIT WORK;
     }
 
     while (sq_remove_data(incremental_sq, &iu)) {
@@ -445,7 +455,7 @@ next_incremental()
     switch (inc_pid) {
     case 0:
        execv(prog, argv);
-       exit(1);
+       _exit(1);
     case -1:
        com_err(whoami, 0, "Failed to start incremental update");
        break;