2 * ============LICENSE_START====================================================
4 * ===========================================================================
5 * Copyright (c) 2018 AT&T Intellectual Property. All rights reserved.
6 * ===========================================================================
7 * Licensed under the Apache License, Version 2.0 (the "License");
8 * you may not use this file except in compliance with the License.
9 * You may obtain a copy of the License at
11 * http://www.apache.org/licenses/LICENSE-2.0
13 * Unless required by applicable law or agreed to in writing, software
14 * distributed under the License is distributed on an "AS IS" BASIS,
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 * See the License for the specific language governing permissions and
17 * limitations under the License.
18 * ============LICENSE_END====================================================
22 package org.onap.aaf.auth.batch.update;
25 import java.io.IOException;
26 import java.text.ParseException;
27 import java.util.ArrayList;
28 import java.util.Date;
29 import java.util.GregorianCalendar;
30 import java.util.List;
32 import java.util.Map.Entry;
33 import java.util.TreeMap;
35 import org.onap.aaf.auth.batch.Batch;
36 import org.onap.aaf.auth.batch.BatchPrincipal;
37 import org.onap.aaf.auth.batch.approvalsets.ApprovalSet;
38 import org.onap.aaf.auth.batch.approvalsets.Pending;
39 import org.onap.aaf.auth.batch.approvalsets.URApprovalSet;
40 import org.onap.aaf.auth.batch.helpers.BatchDataView;
41 import org.onap.aaf.auth.batch.helpers.CQLBatch;
42 import org.onap.aaf.auth.batch.helpers.CQLBatchLoop;
43 import org.onap.aaf.auth.batch.helpers.LastNotified;
44 import org.onap.aaf.auth.batch.helpers.NS;
45 import org.onap.aaf.auth.batch.helpers.Notification;
46 import org.onap.aaf.auth.batch.helpers.Notification.TYPE;
47 import org.onap.aaf.auth.batch.helpers.Role;
48 import org.onap.aaf.auth.batch.helpers.UserRole;
49 import org.onap.aaf.auth.batch.reports.Notify;
50 import org.onap.aaf.auth.batch.reports.bodies.NotifyPendingApprBody;
51 import org.onap.aaf.auth.dao.cass.UserRoleDAO;
52 import org.onap.aaf.auth.env.AuthzTrans;
53 import org.onap.aaf.auth.layer.Result;
54 import org.onap.aaf.auth.org.OrganizationException;
55 import org.onap.aaf.cadi.Access;
56 import org.onap.aaf.cadi.CadiException;
57 import org.onap.aaf.cadi.client.Holder;
58 import org.onap.aaf.cadi.util.CSV;
59 import org.onap.aaf.misc.env.APIException;
60 import org.onap.aaf.misc.env.TimeTaken;
61 import org.onap.aaf.misc.env.Trans;
62 import org.onap.aaf.misc.env.util.Chrono;
64 public class Approvals extends Batch {
65 private final Access access;
66 private final AuthzTrans noAvg;
67 private BatchDataView dataview;
68 private List<CSV> csvList;
69 private GregorianCalendar now;
70 private final Notify notify;
73 public Approvals(AuthzTrans trans) throws APIException, IOException, OrganizationException {
75 notify = new Notify(trans);
76 access = env.access();
77 noAvg = env.newTransNoAvg();
78 noAvg.setUser(new BatchPrincipal("batch:Approvals"));
79 session = cluster.connect();
80 dataview = new BatchDataView(noAvg,session,dryRun);
81 NS.load(trans, session, NS.v2_0_11);
82 Role.load(trans, session);
83 UserRole.load(trans, session, UserRole.v2_0_11);
85 now = new GregorianCalendar();
87 csvList = new ArrayList<>();
90 for(int i=0;i<args().length;++i) {
91 f = new File(logDir(), args()[i]);
93 csvList.add(new CSV(env.access(),f).processAll());
95 trans.error().printf("CSV File %s does not exist",f.getAbsolutePath());
99 f = new File(logDir(), "Approvals"+Chrono.dateOnlyStamp()+".csv");
101 csvList.add(new CSV(env.access(),f).processAll());
103 trans.error().printf("CSV File %s does not exist",f.getAbsolutePath());
109 protected void run(AuthzTrans trans) {
110 Map<String,Pending> mpending = new TreeMap<>();
111 Holder<Integer> count = new Holder<>(0);
112 final CQLBatchLoop cbl = new CQLBatchLoop(new CQLBatch(noAvg.info(),session),100,dryRun);
113 for(CSV approveCSV : csvList) {
114 TimeTaken tt = trans.start("Load Analyzed Reminders",Trans.SUB,approveCSV.name());
116 approveCSV.visit(row -> {
120 String user = row.get(1);
121 Pending p = new Pending(row);
122 Pending mp = mpending.get(user);
124 mpending.put(user, p);
126 mp.inc(p); // FYI, unlikely
128 count.set(count.get()+1);
129 } catch (ParseException e) {
130 trans.error().log(e);
135 } catch (IOException | CadiException e) {
137 // .... but continue with next row
142 trans.info().printf("Processed %d Reminder Rows", count.get());
145 for(CSV approveCSV : csvList) {
146 TimeTaken tt = trans.start("Processing %s's UserRoles",Trans.SUB,approveCSV.name());
148 approveCSV.visit(row -> {
150 case UserRole.APPROVE_UR:
151 UserRoleDAO.Data urdd = UserRole.row(row);
152 // Create an Approval
153 ApprovalSet uras = new URApprovalSet(noAvg, now, dataview, () -> {
156 Result<Void> rw = uras.write(noAvg);
158 Pending p = new Pending();
159 Pending mp = mpending.get(urdd.user);
161 mpending.put(urdd.user, p);
165 count.set(count.get()+1);
167 trans.error().log(rw.errorString());
173 } catch (IOException | CadiException e) {
175 // .... but continue with next row
179 trans.info().printf("Processed %d UserRoles", count.get());
182 NotifyPendingApprBody npab = new NotifyPendingApprBody(access);
184 GregorianCalendar gc = new GregorianCalendar();
185 gc.add(GregorianCalendar.DAY_OF_MONTH, 7);
186 Date oneWeek = gc.getTime();
187 CSV.Saver rs = new CSV.Saver();
189 tt = trans.start("Obtain Last Notifications", Trans.SUB);
192 lastN = new LastNotified(session);
193 lastN.add(mpending.keySet());
199 tt = trans.start("Notify for Pending", Trans.SUB);
201 for(Entry<String, Pending> es : mpending.entrySet()) {
203 Date dateLastNotified = lastN.lastNotified(es.getKey());
204 if(p.newApprovals() || dateLastNotified==null || dateLastNotified.after(oneWeek) ) {
205 rs.row("appr", es.getKey(),p.qty(),batchEnv);
206 npab.store(rs.asList());
207 if(notify.notify(noAvg, npab)>0) {
210 update(cbl.inc(),es.getKey(),Notification.TYPE.OA);
217 trans.info().printf("Created %d Notifications", count.get());
221 private void update(StringBuilder sb, String user, TYPE oa) {
222 sb.append("UPDATE authz.notify SET last=dateof(now()) WHERE user='");
224 sb.append("' AND type=");
231 protected void _close(AuthzTrans trans) {