]> andersk Git - moira.git/blame - gen/directory.pc
Don't explicitly call out students anymore; we get that information from
[moira.git] / gen / directory.pc
CommitLineData
7ac48069 1/* $Id$
20b9980f 2 *
3 * This generates a master /etc/passwd containing all active (status != 0)
4 * accounts.
5 *
7ac48069 6 * Copyright (C) 1998 by the Massachusetts Institute of Technology.
7 * For copying and distribution information, please see the file
8 * <mit-copyright.h>.
20b9980f 9 */
10
11#include <mit-copyright.h>
20b9980f 12#include <moira.h>
7ac48069 13
20b9980f 14#include <sys/stat.h>
7ac48069 15
16#include <stdio.h>
17#include <time.h>
18
dfaf9b68 19#include "util.h"
20
20b9980f 21EXEC SQL INCLUDE sqlca;
22
7ac48069 23RCSID("$Header$");
24
20b9980f 25char *whoami = "directory.gen";
26char *db = "moira/moira";
27
28int main(int argc, char **argv)
29{
30 FILE *out = stdout;
dfaf9b68 31 char *outf = NULL, outft[MAXPATHLEN];
20b9980f 32 EXEC SQL BEGIN DECLARE SECTION;
dfaf9b68 33 char login[USERS_LOGIN_SIZE], last_name[USERS_LAST_SIZE];
34 char first_name[USERS_FIRST_SIZE], middle_name[USERS_MIDDLE_SIZE];
35 char office_address[USERS_OFFICE_ADDR_SIZE];
36 char office_phone[USERS_OFFICE_PHONE_SIZE];
37 char home_address[USERS_HOME_ADDR_SIZE], home_phone[USERS_HOME_PHONE_SIZE];
38 char id[USERS_CLEARID_SIZE], type[USERS_TYPE_SIZE];
20b9980f 39 EXEC SQL END DECLARE SECTION;
40
41 EXEC SQL CONNECT :db;
42
43 if (argc == 2)
44 {
20b9980f 45 outf = argv[1];
46 sprintf(outft, "%s~", outf);
47 if (!(out = fopen(outft, "w")))
48 {
49 fprintf(stderr, "unable to open %s for output\n", outf);
50 exit(MR_OCONFIG);
51 }
52 }
53 else if (argc != 1)
54 {
55 fprintf(stderr, "usage: %s [outfile]\n", argv[0]);
56 exit(MR_ARGS);
57 }
58 else
59 outf = NULL;
60
61 EXEC SQL WHENEVER SQLERROR GOTO sqlerr;
62
63 EXEC SQL DECLARE x CURSOR FOR SELECT
64 login, last, first, middle, office_addr, office_phone,
65 home_addr, home_phone, clearid, type
66 FROM users WHERE status = 1 AND type != 'SYSTEM' AND type != 'STAFF'
7477c5a7 67 AND type != 'TEST' and type != 'REGTEST' AND type NOT LIKE 'GUES%';
20b9980f 68 EXEC SQL OPEN x;
69 while (1)
70 {
71 EXEC SQL FETCH x INTO :login, :last_name, :first_name, :middle_name,
72 :office_address, :office_phone, :home_address, :home_phone,
73 :id, :type;
74 if (sqlca.sqlcode)
75 break;
76 strtrim(login);
77 strtrim(last_name);
78 strtrim(first_name);
79 strtrim(middle_name);
80 strtrim(office_address);
81 strtrim(office_phone);
82 strtrim(home_address);
83 strtrim(home_phone);
84 strtrim(id);
85 strtrim(type);
86#ifdef notdef
87 if(isdigit(*id))
88 fprintf(out, "%s^4:p\t24:%s %s\t7:%s, %s %s\t3:%s, %s "
89 "%s\t5:%s\t2:%s@mit.edu\t1:%s\t0:%s\t14:%s\t15:%s\t10:"
90 "Unlisted Account\n", id, last_name, login, last_name,
91 first_name, middle_name, last_name, first_name,
92 middle_name, login, login, office_phone, office_address,
93 home_phone, home_address);
94#else
95 if(isdigit(*id))
96 fprintf(out, "%s^4:p\t24:%s %s\t7:%s, %s %s\t3:%s, %s "
97 "%s\t5:%s\t2:%s@mit.edu\t1:%s\t0:%s\t14:%s\t15:%s\t10:%s\n",
98 id, last_name, login, last_name, first_name, middle_name,
99 last_name, first_name, middle_name, login, login,
68849238 100 "", "", "", "", "MIT Affiliate");
20b9980f 101#endif
102 }
103 EXEC SQL CLOSE x;
104
105 EXEC SQL COMMIT;
106
107 if (fclose(out))
108 {
109 perror("close failed");
110 exit(MR_CCONFIG);
111 }
112 if (outf)
113 fix_file(outf);
114 exit(MR_SUCCESS);
115
116sqlerr:
117 db_error(sqlca.sqlcode);
118 exit(MR_DBMS_ERR);
119}
This page took 0.095247 seconds and 5 git commands to generate.