]> andersk Git - moira.git/blame - regtape/students.pc
andersk / moira.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
this is no longer used for anything
[moira.git] / regtape / students.pc
CommitLineData
7ac48069 1/* $Id$
2 *
3 * Load data into Moira from Registrar's Office data file
4 *
5 * Copyright (C) 1990-1998 by the Massachusetts Institute of Technology
6 * For copying and distribution information, please see the file
7 * <mit-copyright.h>.
093c49c9 8 */
9
7ac48069 10#include <mit-copyright.h>
932028de 11#include <moira.h>
12#include <moira_site.h>
dfaf9b68 13#include <moira_schema.h>
7ac48069 14
15#include <ctype.h>
16#include <stdio.h>
17#include <stdlib.h>
18#include <string.h>
19#include <time.h>
20
8638fcf9 21EXEC SQL INCLUDE sqlca;
7ac48069 22extern void sqlglm(char *, unsigned int *, unsigned int *);
093c49c9 23
7ac48069 24RCSID("$Header$");
093c49c9 25
8638fcf9 26#define WHO 11859 /* root */
27#define PROG "stu-tape"
5e2b5b5f 28
397e9044 29#define MAX_ID_VALUE 31999
5e2b5b5f 30#define MIN_ID_VALUE 101
31
093c49c9 32/* File format is:
33
340-29 name
3530-38 id number
3650-54 school code
3755-79 year
3880-109 address
39110-124 room
40125-144 city
41145-158 state
42159-168 dorm phone
43169-212 home address
44213-232 home city
45243-251 mit phone (?)
46*/
47
48#define LOC_NAME 0
49#define LOC_ID 30
50#define LOC_COURSE 50
51#define LOC_YEAR 55
52#define LOC_ADDRESS 80
53#define LOC_DORM_ROOM 110
54#define LOC_CITY 125
55#define LOC_STATE 145
c48e3c93 56#define LOC_DPHONE 155
e3c8ca24 57#define LOC_MPHONE 243
093c49c9 58
e3c8ca24 59#define LEN_NAME 30
093c49c9 60#define LEN_ID 9
e3c8ca24 61#define LEN_COURSE 5
62#define LEN_YEAR 25
63#define LEN_ADDRESS 30
64#define LEN_DORM_ROOM 15
65#define LEN_CITY 20
c48e3c93 66#define LEN_STATE 10
67#define LEN_DPHONE 12
68#define LEN_MPHONE 12
093c49c9 69
70struct entry {
5eaef520 71 char *name;
72 char *last;
73 char *first;
74 char *middle;
75 char *title;
76 char *id;
77 char *eid;
78 char *course;
79 char *year;
80 char *address;
81 char *dorm;
82 char *city;
83 char *state;
84 char *dphone;
85 char *mphone;
86 char *class;
093c49c9 87};
88
093c49c9 89char *whoami;
a97bc039 90int newfinger = 0;
093c49c9 91
7ac48069 92struct entry *get_next_entry(FILE *in);
93void process_entry(struct entry *e);
94void newuser(struct entry *e);
95int set_next_users_id(int limit);
96int set_next_uid(int limit);
97void sqlexit(void);
98void dbmserr(char *where, int what);
99
bd22473a 100#define SQL_DUPLICATE -2112
9f5e5c05 101#define sqlfail() (sqlca.sqlcode && sqlca.sqlcode != 1403)
093c49c9 102
5eaef520 103int main(int argc, char **argv)
8638fcf9 104{
5eaef520 105 FILE *in;
7ac48069 106 struct entry *e;
5eaef520 107 int i, wait = 0;
dfaf9b68 108 char buf[80], *file = NULL;
5eaef520 109 EXEC SQL BEGIN DECLARE SECTION;
110 char *db = "moira";
111 EXEC SQL END DECLARE SECTION;
112
113 whoami = strrchr(argv[0], '/');
114 if (whoami)
115 whoami++;
116 else
117 whoami = argv[0];
118
119 setvbuf(stdout, NULL, _IOLBF, BUFSIZ);
120 setvbuf(stderr, NULL, _IOLBF, BUFSIZ);
121
122 for (i = 1; i < argc; i++)
123 {
124 if (!strcmp(argv[i], "-w"))
125 wait++;
5eaef520 126 else if (!strcmp(argv[i], "-n"))
127 newfinger++;
128 else if (file)
129 fprintf(stderr, "Usage: %s [-w] [-D] [-n] inputfile\n", whoami);
130 else
131 file = argv[i];
132 }
133
134 in = fopen(file, "r");
135 if (!in)
136 {
137 fprintf(stderr, "Unable to open %s for input\n", file);
138 exit(1);
139 }
140
141 initialize_sms_error_table();
142
143 EXEC SQL CONNECT :db IDENTIFIED BY :db;
144 if (sqlca.sqlcode)
145 {
146 dbmserr("connecting", sqlca.sqlcode);
147 exit(1);
148 }
149
150 while ((e = get_next_entry(in)))
151 {
5eaef520 152 process_entry(e);
153 EXEC SQL COMMIT WORK;
154 if (sqlca.sqlcode)
155 {
9f5e5c05 156 dbmserr("committing work", sqlca.sqlcode);
157 exit(1);
837b0ec6 158 }
5eaef520 159 if (wait)
160 {
161 printf("Next");
162 fflush(stdout);
dfaf9b68 163 fgets(buf, sizeof(buf), stdin);
093c49c9 164 }
165 }
166
5eaef520 167 exit(0);
8638fcf9 168}
093c49c9 169
170
5eaef520 171struct entry *get_next_entry(FILE *in)
093c49c9 172{
5eaef520 173 static struct entry e;
7ac48069 174 static char buf[BUFSIZ], eid[16], classbuf[10];
5eaef520 175 static char name[LEN_NAME + 1], id[LEN_ID + 1], course[LEN_COURSE + 1];
176 static char year[LEN_YEAR + 1], address[LEN_ADDRESS + 1];
177 static char dorm_room[LEN_DORM_ROOM + 1], city[LEN_CITY + 1];
178 static char state[LEN_STATE + 1], dphone[LEN_DPHONE + 1];
179 static char mphone[LEN_MPHONE + 1], sname[LEN_NAME + 1], title[128];
180 static int nyear = 0;
181 int ends_jr, ends_iii, ends_iv, ends_sr, ends_ii, ends_v;
182 char *p;
183
184 if (nyear == 0)
185 {
186 struct tm *tm;
187 struct timeval tv;
188
189 gettimeofday(&tv, NULL);
190 tm = localtime(&tv.tv_sec);
191 nyear = tm->tm_year;
192 if (tm->tm_mon > 5)
193 nyear++;
194 }
195
196 if (!fgets(buf, sizeof(buf), in))
197 return NULL;
198
199 strncpy(name, &buf[LOC_NAME], LEN_NAME);
200 name[LEN_NAME] = '\0';
201 strncpy(id, &buf[LOC_ID], LEN_ID);
202 id[LEN_ID] = '\0';
203 strncpy(course, &buf[LOC_COURSE], LEN_COURSE);
204 course[LEN_COURSE] = '\0';
205 strncpy(year, &buf[LOC_YEAR], LEN_YEAR);
206 year[LEN_YEAR] = '\0';
207 strncpy(address, &buf[LOC_ADDRESS], LEN_ADDRESS);
208 address[LEN_ADDRESS] = '\0';
209 strncpy(dorm_room, &buf[LOC_DORM_ROOM], LEN_DORM_ROOM);
210 dorm_room[LEN_DORM_ROOM] = '\0';
211 strncpy(city, &buf[LOC_CITY], LEN_CITY);
212 city[LEN_CITY] = '\0';
213 strncpy(state, &buf[LOC_STATE], LEN_STATE);
214 state[LEN_STATE] = '\0';
215 strncpy(dphone, &buf[LOC_DPHONE], LEN_DPHONE);
216 dphone[LEN_DPHONE] = '\0';
217 strncpy(mphone, &buf[LOC_MPHONE], LEN_MPHONE);
218 mphone[LEN_MPHONE] = '\0';
219
220 strcpy(sname, name);
221 e.name = strtrim(sname);
222 p = strchr(name, ',');
223 if (p)
224 *p = '\0';
225 e.last = strtrim(name);
226 if (p)
227 {
228 p++;
229 while (isspace(*p))
e3c8ca24 230 p++;
5eaef520 231 e.first = p;
7ac48069 232 if ((p = strchr(e.first, ' ')))
5eaef520 233 {
234 *p = '\0';
235 e.first = strtrim(e.first);
236 e.middle = strtrim(p + 1);
237 }
238 else
239 {
240 e.first = strtrim(e.first);
241 e.middle = "";
6d6c60e6 242 }
5eaef520 243 }
244 else
245 {
246 e.first = "";
247 e.middle = "";
248 }
249 ends_jr = ends_iii = ends_iv = ends_sr = ends_ii = ends_v = 0;
250 LookForSt(e.last);
251 LookForO(e.last);
252 LookForJrAndIII(e.last, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
253 &ends_ii, &ends_v);
254 LookForJrAndIII(e.first, &ends_sr, &ends_jr, &ends_iii, &ends_iv,
255 &ends_ii, &ends_v);
256 FixCase(e.last);
257 FixCase(e.first);
258 FixCase(e.middle);
259
260 e.id = id;
261 e.id[LEN_ID] = '\0';
262 e.eid = eid;
263 EncryptID(e.eid, e.id, e.first, e.last);
264
265 e.year = strtrim(year);
266 e.title = title;
267 if (e.year[0] == 'G')
268 {
269 e.class = "G";
270 sprintf(title, "Grad Student");
271 }
272 else
273 {
274 e.class = classbuf;
275 sprintf(classbuf, "%d", nyear + 4 - atoi(e.year) + 1900);
276 sprintf(title, "Undergrad (class of %s)", classbuf);
277 }
278
279 e.course = strtrim(course);
280 e.address = strtrim(address);
281 e.dorm = strtrim(dorm_room);
282 e.city = strtrim(city);
283 e.state = strtrim(state);
284 e.dphone = strtrim(dphone);
285 e.mphone = strtrim(mphone);
286 return &e;
093c49c9 287}
288
289
7ac48069 290void process_entry(struct entry *e)
8638fcf9 291{
5eaef520 292 int changed, nochange, encrypted;
dfaf9b68 293 char buf[MAX_FIELD_WIDTH], *from, *to;
5eaef520 294 EXEC SQL BEGIN DECLARE SECTION;
7ac48069 295 char *first, *last, *middle, *eid, *sid, *name, *rdept;
5eaef520 296 char *rtitle, *rophone, *rhphone, *prog;
dfaf9b68 297 char class[USERS_TYPE_SIZE], haddr[USERS_HOME_ADDR_SIZE];
298 char hphone[USERS_HOME_PHONE_SIZE], ophone[USERS_OFFICE_PHONE_SIZE];
299 char dept[USERS_DEPARTMENT_SIZE], raddr[USERS_XADDRESS_SIZE];
300 char dfirst[USERS_FIRST_SIZE], dlast[USERS_LAST_SIZE];
301 char dmiddle[USERS_MIDDLE_SIZE];
5eaef520 302 int id, status, who;
303 EXEC SQL END DECLARE SECTION;
304
305 who = WHO;
306 prog = PROG;
307 first = e->first;
dfaf9b68 308 if (strlen(first) > USERS_FIRST_SIZE - 1)
309 first[USERS_FIRST_SIZE - 1] = '\0';
5eaef520 310 last = e->last;
dfaf9b68 311 if (strlen(last) > USERS_LAST_SIZE - 1)
312 last[USERS_LAST_SIZE - 1] = '\0';
5eaef520 313 middle = e->middle;
dfaf9b68 314 if (strlen(middle) > USERS_MIDDLE_SIZE - 1)
315 middle[USERS_MIDDLE_SIZE - 1] = '\0';
5eaef520 316 eid = e->eid;
317 sid = e->id;
318 id = 0;
319 encrypted = 0;
320
321 /* Get user info */
322 EXEC SQL SELECT users_id, first, last, middle, type, home_addr, home_phone,
323 office_phone, status, department
324 INTO :id, :dfirst, :dlast, :dmiddle, :class, :haddr, :hphone,
325 :ophone, :status, :dept
326 FROM users
327 WHERE clearid = :sid;
328 if (sqlfail())
329 {
330 if (sqlca.sqlcode == SQL_DUPLICATE)
331 {
332 com_err(whoami, 0, "duplicate ID number %s on user %s %s",
333 sid, first, last);
334 return;
335 }
336 else
337 sqlexit();
338 }
339 if (id == 0)
340 {
341 EXEC SQL SELECT users_id, first, last, middle, type, home_addr,
342 home_phone, office_phone, status, department
343 INTO :id, :dfirst, :dlast, :dmiddle, :class, :haddr,
344 :hphone, :ophone, :status, :dept
345 FROM users
346 WHERE last = :last and first = :first and clearid = :eid;
347 if (sqlfail())
348 sqlexit();
349 encrypted++;
350 if (id == 0)
351 {
352 newuser(e);
353 return;
c48e3c93 354 }
093c49c9 355 }
c48e3c93 356
5eaef520 357 /* See if class changed: if it's different, and the value in the database
358 * is not STAFF or SIPBMEM, and the value from the tape is actually
359 * meaningful, then update the database. Since they were on the
360 * students tape, make the account usable.
361 */
362 if (strcmp(e->class, strtrim(class)) &&
363 strcmp(class, "STAFF") && strcmp(class, "SIPBMEM") &&
364 e->year[0])
365 {
366 com_err(whoami, 0, "updating class for user %s %s from %s to %s",
367 first, last, class, e->class);
368 if (status == US_NOT_ALLOWED)
369 status = US_NO_LOGIN_YET;
370 if (status == US_ENROLL_NOT_ALLOWED)
371 status = US_ENROLLED;
372 strcpy(class, e->class);
373 EXEC SQL UPDATE users
374 SET type = NVL(:class, CHR(0)), status = :status, modtime = SYSDATE,
375 modby = :who, modwith = :prog
376 WHERE users_id = :id;
377 if (sqlca.sqlcode)
378 {
379 dbmserr("updating class", sqlca.sqlcode);
380 exit(1);
837b0ec6 381 }
093c49c9 382 }
c48e3c93 383
5eaef520 384 /* Update name if necessary */
385 if (strcmp(first, strtrim(dfirst)) ||
386 strcmp(last, strtrim(dlast)) ||
387 strcmp(middle, strtrim(dmiddle)))
388 {
389 com_err(whoami, 0, "updating real name for %s %s", first, last);
390 EXEC SQL UPDATE users
391 SET first = NVL(:first, CHR(0)), last = NVL(:last, CHR(0)),
392 middle = NVL(:middle, CHR(0)), modby = :who, modwith = :prog,
393 modtime = SYSDATE
394 WHERE users_id = :id;
395 if (sqlca.sqlcode != 0)
396 {
397 dbmserr("updating name", sqlca.sqlcode);
398 exit(1);
ca64f2fb 399 }
400 }
c48e3c93 401
5eaef520 402 /* Deal with updating the finger info if necessary */
403 changed = nochange = 0;
404 if (encrypted)
405 changed++;
406 strcpy(buf, e->address);
407 if (*e->dorm)
408 {
409 strcat(buf, " ");
410 strcat(buf, e->dorm);
411 }
412 if (*e->city)
413 {
414 strcat(buf, " ");
415 strcat(buf, e->city);
416 }
417 FixCase(buf);
418 if (*e->state)
419 {
420 strcat(buf, " ");
421 strcat(buf, e->state);
422 }
423 while ((to = strchr(buf, ',')))
424 *to = ';';
425 while ((to = strchr(buf, ':')))
426 *to = ';';
427 if (newfinger)
428 {
429 if (haddr[0] == ' ')
430 {
dfaf9b68 431 strncpy(haddr, buf, USERS_HOME_ADDR_SIZE - 1);
432 haddr[USERS_HOME_ADDR_SIZE - 1] = '\0';
a97bc039 433 changed++;
8638fcf9 434 }
dfaf9b68 435 else if (strncmp(strtrim(haddr), buf, USERS_HOME_ADDR_SIZE - 1))
5eaef520 436 nochange++;
437 }
438 else
439 {
dfaf9b68 440 if (strncmp(strtrim(haddr), buf, USERS_HOME_ADDR_SIZE - 1))
5eaef520 441 changed++;
dfaf9b68 442 strncpy(haddr, buf, USERS_HOME_ADDR_SIZE - 1);
443 haddr[USERS_HOME_ADDR_SIZE - 1] = '\0';
5eaef520 444 }
445 from = e->dphone;
446 to = buf;
447 while (*from)
448 {
449 if (isdigit(*from))
450 *to++ = *from;
451 from++;
452 }
453 *to = '\0';
454 if (newfinger)
455 {
456 if (hphone[0] == ' ')
457 {
dfaf9b68 458 strncpy(hphone, buf, USERS_HOME_PHONE_SIZE - 1);
459 hphone[USERS_HOME_PHONE_SIZE - 1] = '\0';
5eaef520 460 }
dfaf9b68 461 else if (strncmp(strtrim(hphone), buf, USERS_HOME_PHONE_SIZE - 1))
5eaef520 462 nochange++;
463 }
464 else
465 {
dfaf9b68 466 if (strncmp(strtrim(hphone), buf, USERS_HOME_PHONE_SIZE - 1))
5eaef520 467 changed++;
dfaf9b68 468 strncpy(hphone, buf, USERS_HOME_PHONE_SIZE - 1);
469 hphone[USERS_HOME_PHONE_SIZE - 1] = '\0';
5eaef520 470 }
471 from = e->mphone;
472 to = buf;
473 while (*from)
474 {
475 if (isdigit(*from))
476 *to++ = *from;
477 from++;
478 }
479 *to = '\0';
480 if (newfinger)
481 {
482 if (ophone[0] == ' ')
483 {
dfaf9b68 484 strncpy(ophone, buf, USERS_OFFICE_PHONE_SIZE - 1);
485 ophone[USERS_OFFICE_PHONE_SIZE - 1] = '\0';
5eaef520 486 }
dfaf9b68 487 else if (strncmp(strtrim(ophone), buf, USERS_OFFICE_PHONE_SIZE - 1))
5eaef520 488 nochange++;
489 }
490 else
491 {
dfaf9b68 492 if (strncmp(strtrim(ophone), buf, USERS_OFFICE_PHONE_SIZE - 1))
5eaef520 493 changed++;
dfaf9b68 494 strncpy(ophone, buf, USERS_OFFICE_PHONE_SIZE - 1);
495 ophone[USERS_OFFICE_PHONE_SIZE - 1] = '\0';
5eaef520 496 }
497 e->course = e->course;
498 if (newfinger)
499 {
500 if (dept[0] == ' ')
501 {
dfaf9b68 502 strncpy(dept, e->course, USERS_DEPARTMENT_SIZE - 1);
503 dept[USERS_DEPARTMENT_SIZE - 1] = '\0';
5eaef520 504 }
dfaf9b68 505 else if (strncmp(strtrim(dept), e->course, USERS_DEPARTMENT_SIZE - 1))
5eaef520 506 nochange++;
507 }
508 else
509 {
dfaf9b68 510 if (strncmp(strtrim(dept), e->course, USERS_DEPARTMENT_SIZE - 1))
5eaef520 511 changed++;
dfaf9b68 512 strncpy(dept, e->course, USERS_DEPARTMENT_SIZE - 1);
513 dept[USERS_DEPARTMENT_SIZE - 1] = '\0';
5eaef520 514 }
515 sid = e->id;
516 name = e->name;
517 rdept = e->course;
518 rtitle = e->title;
519 rophone = e->mphone;
520 rhphone = e->dphone;
521 strcpy(raddr, e->address);
522 if (*e->dorm)
523 {
524 strcat(raddr, " ");
525 strcat(raddr, e->dorm);
526 }
527 strcat(raddr, "|");
528 if (*e->city)
529 {
530 strcat(raddr, e->city);
531 FixCase(raddr);
532 if (*e->state)
533 {
534 strcat(raddr, " ");
535 if (isupper(e->state[0]) && isupper(e->state[1]) &&
536 isdigit(e->state[2]) && isdigit(e->state[3]) &&
537 isdigit(e->state[4]) && isdigit(e->state[5]) &&
538 isdigit(e->state[6]))
539 {
540 sprintf(buf, "%c%c %s", e->state[0], e->state[1],
541 &(e->state[2]));
542 strcat(raddr, buf);
543 }
544 else
545 strcat(raddr, e->state);
546 }
547 }
548 else
549 {
550 FixCase(raddr);
551 strcat(raddr, "MIT INTERDEPARTMENTAL MAIL");
552 }
553 if (changed)
554 {
555 com_err(whoami, 0, "updating finger for %s %s", first, last);
556 EXEC SQL UPDATE users
557 SET home_addr = NVL(:haddr, CHR(0)), home_phone = NVL(:hphone, CHR(0)),
558 office_phone = NVL(:ophone, CHR(0)), department = NVL(:dept, CHR(0)),
559 fmodtime = SYSDATE, fmodby = :who, fmodwith = :prog,
560 xname = NVL(:name, CHR(0)), xdept = NVL(:rdept, CHR(0)),
561 xtitle = NVL(:rtitle, CHR(0)), xaddress = NVL(:raddr, CHR(0)),
562 xphone1 = NVL(:rhphone, CHR(0)), xphone2 = NVL(:rophone, CHR(0)),
563 xmodtime = SYSDATE, clearid = NVL(:sid, CHR(0))
564 WHERE users_id = :id;
565 if (sqlca.sqlcode)
566 {
9f5e5c05 567 dbmserr(NULL, sqlca.sqlcode);
568 exit(1);
837b0ec6 569 }
5eaef520 570 }
571 else
572 {
573 EXEC SQL UPDATE users
574 SET xname = NVL(:name, CHR(0)), xdept = NVL(:rdept, CHR(0)),
575 xtitle = NVL(:rtitle, CHR(0)), xaddress = NVL(:raddr, CHR(0)),
576 xphone1 = NVL(:rhphone, CHR(0)), xphone2 = NVL(:rophone, CHR(0)),
577 xmodtime = SYSDATE, clearid = NVL(:sid, CHR(0))
578 WHERE users_id = :id;
579 if (sqlca.sqlcode)
580 {
9f5e5c05 581 dbmserr(NULL, sqlca.sqlcode);
582 exit(1);
837b0ec6 583 }
e3c8ca24 584 }
8638fcf9 585}
093c49c9 586
7ac48069 587void newuser(struct entry *e)
8638fcf9 588{
5eaef520 589 char buf[512], *from, *to;
590 EXEC SQL BEGIN DECLARE SECTION;
591 int id, uid, who;
dfaf9b68 592 char *last, *first, *class, *middle, login[USERS_LOGIN_SIZE], *sid;
593 char fullname[USERS_FULLNAME_SIZE], *prog;
594 char haddr[USERS_HOME_ADDR_SIZE], hphone[USERS_HOME_PHONE_SIZE];
595 char ophone[USERS_OFFICE_PHONE_SIZE], dept[USERS_DEPARTMENT_SIZE];
596 char *title, raddr[USERS_XADDRESS_SIZE], *name;
5eaef520 597 EXEC SQL END DECLARE SECTION;
598
599 who = WHO;
600 prog = PROG;
601 strcpy(buf, e->address);
602 if (*e->dorm)
603 {
604 strcat(buf, " ");
605 strcat(buf, e->dorm);
606 }
607 if (*e->city)
608 {
609 strcat(buf, " ");
610 strcat(buf, e->city);
611 }
612 if (*e->state)
613 {
614 strcat(buf, " ");
615 strcat(buf, e->state);
616 }
dfaf9b68 617 strncpy(haddr, buf, USERS_HOME_ADDR_SIZE - 1);
618 haddr[USERS_HOME_ADDR_SIZE - 1] = '\0';
5eaef520 619 from = e->dphone;
620 to = buf;
621 while (*from)
622 {
623 if (isdigit(*from))
624 *to++ = *from;
625 from++;
626 }
627 *to = '\0';
dfaf9b68 628 strncpy(hphone, buf, USERS_HOME_PHONE_SIZE - 1);
629 hphone[USERS_HOME_PHONE_SIZE - 1] = '\0';
5eaef520 630 from = e->mphone;
631 to = buf;
632 while (*from)
633 {
634 if (isdigit(*from))
635 *to++ = *from;
636 from++;
637 }
638 *to = '\0';
dfaf9b68 639 strncpy(ophone, buf, USERS_OFFICE_PHONE_SIZE - 1);
640 ophone[USERS_OFFICE_PHONE_SIZE - 1] = '\0';
641 strncpy(dept, e->course, USERS_DEPARTMENT_SIZE - 1);
642 dept[USERS_DEPARTMENT_SIZE - 1] = '\0';
5eaef520 643
644 id = set_next_users_id(0);
645 uid = set_next_uid(1);
646 sprintf(login, "#%d", uid);
647 last = e->last;
648 first = e->first;
649 middle = e->middle;
650 sid = e->id;
651 class = e->class;
652 title = e->title;
653 if (*middle)
654 sprintf(fullname, "%s %s %s", first, middle, last);
655 else
656 sprintf(fullname, "%s %s", first, last);
657 name = e->name;
658 strcpy(raddr, e->address);
659 if (*e->dorm)
660 {
661 strcat(raddr, " ");
662 strcat(raddr, e->dorm);
663 }
664 strcat(raddr, "|");
665 if (*e->city)
666 {
667 strcat(raddr, e->city);
668 FixCase(raddr);
669 if (*e->state)
670 {
671 strcat(raddr, " ");
672 if (isupper(e->state[0]) && isupper(e->state[1]) &&
673 isdigit(e->state[2]) && isdigit(e->state[3]) &&
674 isdigit(e->state[4]) && isdigit(e->state[5]) &&
675 isdigit(e->state[6]))
676 {
677 sprintf(buf, "%c%c %s", e->state[0], e->state[1],
678 &(e->state[2]));
679 strcat(raddr, buf);
680 }
681 else
682 strcat(raddr, e->state);
8638fcf9 683 }
5eaef520 684 }
685 else
686 {
687 FixCase(raddr);
688 strcat(raddr, "MIT INTERDEPARTMENTAL MAIL");
689 }
690 EXEC SQL INSERT INTO users
691 (login, users_id, unix_uid, shell, last, first, middle, status,
692 clearid, type, modtime, modby, modwith, fullname, home_addr,
693 home_phone, office_phone, department, fmodtime, fmodby, fmodwith,
0e0db404 694 potype, xname, xdept, xtitle, xaddress, xphone1, xphone2, xmodtime,
695 secure)
5eaef520 696 VALUES (:login, :id, :uid, '/bin/athena/tcsh', NVL(:last, CHR(0)),
697 NVL(:first, CHR(0)), NVL(:middle, CHR(0)), 0, NVL(:sid, CHR(0)),
698 NVL(:class, CHR(0)), SYSDATE, :who, :prog, NVL(:fullname, CHR(0)),
699 NVL(:haddr, CHR(0)), NVL(:hphone, CHR(0)), NVL(:ophone, CHR(0)),
700 NVL(:dept, CHR(0)), SYSDATE, :who, :prog, 'NONE',
701 NVL(:name, CHR(0)), NVL(:dept, CHR(0)), NVL(:title, CHR(0)),
702 NVL(:raddr, CHR(0)), NVL(:hphone, CHR(0)), NVL(:ophone, CHR(0)),
0e0db404 703 SYSDATE, 1);
5eaef520 704 if (sqlca.sqlcode)
705 {
9f5e5c05 706 dbmserr("adding user", sqlca.sqlcode);
707 exit(1);
5eaef520 708 }
709 else
710 com_err(whoami, 0, "adding user %s %s", e->first, e->last);
8638fcf9 711}
5e2b5b5f 712
713
5eaef520 714int set_next_users_id(int limit)
8638fcf9 715{
5eaef520 716 EXEC SQL BEGIN DECLARE SECTION;
7ac48069 717 int flag, value, retval;
5eaef520 718 EXEC SQL END DECLARE SECTION;
719
720 EXEC SQL SELECT value INTO :value FROM numvalues
721 WHERE name = 'users_id';
722 if (sqlfail())
723 sqlexit();
724 if (sqlca.sqlerrd[2] != 1)
725 {
726 EXEC SQL ROLLBACK;
727 com_err(whoami, MR_INTERNAL, "values table inconsistancy");
728 exit(1);
093c49c9 729 }
5e2b5b5f 730
5eaef520 731 flag = 0;
732 EXEC SQL SELECT users_id INTO :flag FROM users
733 WHERE users_id = :value;
734 if (sqlfail())
735 sqlexit();
736 if (sqlca.sqlerrd[2] == 0)
8638fcf9 737 flag = 0;
5eaef520 738 while (flag)
739 {
740 value++;
741 if (limit && value > MAX_ID_VALUE)
742 value = MIN_ID_VALUE;
8638fcf9 743 flag = 0;
5eaef520 744 EXEC SQL SELECT users_id INTO :flag FROM users
745 WHERE users_id = :value;
746 if (sqlfail())
747 sqlexit();
748 if (sqlca.sqlerrd[2] == 0)
8638fcf9 749 flag = 0;
5eaef520 750 }
751
752 retval = value++;
753 if (limit && value > MAX_ID_VALUE)
754 value = MIN_ID_VALUE;
755 EXEC SQL UPDATE numvalues SET value = :value
756 WHERE name = 'users_id';
757 if (sqlca.sqlcode)
758 {
759 dbmserr("updating numvalues", sqlca.sqlcode);
760 exit(1);
761 }
762 return retval;
837b0ec6 763}
764
5eaef520 765int set_next_uid(int limit)
837b0ec6 766{
5eaef520 767 EXEC SQL BEGIN DECLARE SECTION;
7ac48069 768 int flag, value, retval;
5eaef520 769 EXEC SQL END DECLARE SECTION;
770
771 EXEC SQL SELECT value INTO :value FROM numvalues
772 WHERE name = 'unix_uid';
773 if (sqlfail())
774 sqlexit();
775 if (sqlca.sqlerrd[2] != 1)
776 {
777 EXEC SQL ROLLBACK;
778 com_err(whoami, MR_INTERNAL, "values table inconsistancy");
779 exit(1);
837b0ec6 780 }
781
5eaef520 782 flag = 0;
783 EXEC SQL SELECT unix_uid INTO :flag FROM users WHERE unix_uid = :value;
784 if (sqlfail())
785 sqlexit();
786 if (sqlca.sqlerrd[2] == 0)
837b0ec6 787 flag = 0;
5eaef520 788 while (flag)
789 {
790 value++;
791 if (limit && value > MAX_ID_VALUE)
792 value = MIN_ID_VALUE;
837b0ec6 793 flag = 0;
5eaef520 794 EXEC SQL SELECT unix_uid INTO :flag FROM users WHERE unix_uid = :value;
795 if (sqlfail())
796 sqlexit();
797 if (sqlca.sqlerrd[2] == 0)
837b0ec6 798 flag = 0;
837b0ec6 799 }
800
5eaef520 801 retval = value++;
802 if (limit && value > MAX_ID_VALUE)
803 value = MIN_ID_VALUE;
804 EXEC SQL UPDATE numvalues SET value = :value WHERE name = 'unix_uid';
805 if (sqlca.sqlcode)
806 {
807 dbmserr("updating numvalues", sqlca.sqlcode);
808 exit(1);
837b0ec6 809 }
5eaef520 810 return retval;
837b0ec6 811}
812
813
7ac48069 814void sqlexit(void)
837b0ec6 815{
5eaef520 816 dbmserr(NULL, sqlca.sqlcode);
817 EXEC SQL ROLLBACK WORK;
818 exit(1);
8638fcf9 819}
9f5e5c05 820
7ac48069 821void dbmserr(char *where, int what)
9f5e5c05 822{
823 char err_msg[256];
5eaef520 824 int bufsize = 256, msglength = 0;
9f5e5c05 825
826 sqlglm(err_msg, &bufsize, &msglength);
5eaef520 827 err_msg[msglength] = '\0';
9f5e5c05 828
5eaef520 829 if (where)
9f5e5c05 830 com_err(whoami, 0, "DBMS error %swhile %s", err_msg, where);
831 else
832 com_err(whoami, 0, "DBMS error %s", err_msg);
833}
Moira, the Athena Service Management system
This page took 0.229779 seconds and 5 git commands to generate.