--- /dev/null
+/*******************************************************************************\r
+ * ============LICENSE_START====================================================\r
+ * * org.onap.aaf\r
+ * * ===========================================================================\r
+ * * Copyright © 2017 AT&T Intellectual Property. All rights reserved.\r
+ * * ===========================================================================\r
+ * * Licensed under the Apache License, Version 2.0 (the "License");\r
+ * * you may not use this file except in compliance with the License.\r
+ * * You may obtain a copy of the License at\r
+ * * \r
+ * * http://www.apache.org/licenses/LICENSE-2.0\r
+ * * \r
+ * * Unless required by applicable law or agreed to in writing, software\r
+ * * distributed under the License is distributed on an "AS IS" BASIS,\r
+ * * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\r
+ * * See the License for the specific language governing permissions and\r
+ * * limitations under the License.\r
+ * * ============LICENSE_END====================================================\r
+ * *\r
+ * * ECOMP is a trademark and service mark of AT&T Intellectual Property.\r
+ * *\r
+ ******************************************************************************/\r
+package org.onap.aaf.dao.aaf.cass;\r
+\r
+import java.util.Date;\r
+import java.util.List;\r
+import java.util.UUID;\r
+\r
+import org.onap.aaf.authz.env.AuthzTrans;\r
+import org.onap.aaf.authz.layer.Result;\r
+import org.onap.aaf.dao.CassDAOImpl;\r
+import org.onap.aaf.dao.Loader;\r
+\r
+import com.datastax.driver.core.Cluster;\r
+import com.datastax.driver.core.Row;\r
+\r
+\r
+public class ApprovalDAO extends CassDAOImpl<AuthzTrans,ApprovalDAO.Data> {\r
+ public static final String PENDING = "pending";\r
+ public static final String DENIED = "denied";\r
+ public static final String APPROVED = "approved";\r
+ \r
+ private static final String TABLE = "approval";\r
+ private HistoryDAO historyDAO;\r
+ private PSInfo psByUser, psByApprover, psByTicket, psByStatus;\r
+\r
+ \r
+ public ApprovalDAO(AuthzTrans trans, Cluster cluster, String keyspace) {\r
+ super(trans, ApprovalDAO.class.getSimpleName(),cluster,keyspace,Data.class,TABLE, readConsistency(trans,TABLE), writeConsistency(trans,TABLE));\r
+ historyDAO = new HistoryDAO(trans, this);\r
+ init(trans);\r
+ }\r
+\r
+\r
+ public ApprovalDAO(AuthzTrans trans, HistoryDAO hDAO) {\r
+ super(trans, ApprovalDAO.class.getSimpleName(),hDAO,Data.class,TABLE, readConsistency(trans,TABLE), writeConsistency(trans,TABLE));\r
+ historyDAO=hDAO;\r
+ init(trans);\r
+ }\r
+\r
+ private static final int KEYLIMIT = 1;\r
+ public static class Data {\r
+ public UUID id;\r
+ public UUID ticket;\r
+ public String user;\r
+ public String approver;\r
+ public String type;\r
+ public String status;\r
+ public String memo;\r
+ public String operation;\r
+ public Date updated;\r
+ }\r
+ \r
+ private static class ApprovalLoader extends Loader<Data> {\r
+ public static final ApprovalLoader deflt = new ApprovalLoader(KEYLIMIT);\r
+ \r
+ public ApprovalLoader(int keylimit) {\r
+ super(keylimit);\r
+ }\r
+ \r
+ @Override\r
+ public Data load(Data data, Row row) {\r
+ data.id = row.getUUID(0);\r
+ data.ticket = row.getUUID(1);\r
+ data.user = row.getString(2);\r
+ data.approver = row.getString(3);\r
+ data.type = row.getString(4);\r
+ data.status = row.getString(5);\r
+ data.memo = row.getString(6);\r
+ data.operation = row.getString(7);\r
+ if(row.getColumnDefinitions().size()>8) {\r
+ // Rows reported in MicroSeconds\r
+ data.updated = new Date(row.getLong(8)/1000);\r
+ }\r
+ return data;\r
+ }\r
+\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ obj[idx]=data.id;\r
+ }\r
+\r
+ @Override\r
+ protected void body(Data data, int _idx, Object[] obj) {\r
+ int idx = _idx;\r
+ obj[idx]=data.ticket;\r
+ obj[++idx]=data.user;\r
+ obj[++idx]=data.approver;\r
+ obj[++idx]=data.type;\r
+ obj[++idx]=data.status;\r
+ obj[++idx]=data.memo;\r
+ obj[++idx]=data.operation;\r
+ }\r
+ } \r
+ \r
+ private void init(AuthzTrans trans) {\r
+ String[] helpers = setCRUD(trans, TABLE, Data.class, ApprovalLoader.deflt,8);\r
+ // Need a specialty Creator to handle the "now()"\r
+ replace(CRUD.create, new PSInfo(trans, "INSERT INTO " + TABLE + " (" + helpers[FIELD_COMMAS] +\r
+ ") VALUES(now(),?,?,?,?,?,?,?)",new ApprovalLoader(0) {\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ // Overridden because key is the "now()"\r
+ }\r
+ },writeConsistency)\r
+ );\r
+\r
+ psByUser = new PSInfo(trans, SELECT_SP + helpers[FIELD_COMMAS] + ", WRITETIME(status) FROM " + TABLE + \r
+ " WHERE user = ?", new ApprovalLoader(1) {\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ obj[idx]=data.user;\r
+ }\r
+ }, readConsistency);\r
+ \r
+ psByApprover = new PSInfo(trans, SELECT_SP + helpers[FIELD_COMMAS] + ", WRITETIME(status) FROM " + TABLE + \r
+ " WHERE approver = ?", new ApprovalLoader(1) {\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ obj[idx]=data.approver;\r
+ }\r
+ }, readConsistency);\r
+\r
+ psByTicket = new PSInfo(trans, SELECT_SP + helpers[FIELD_COMMAS] + ", WRITETIME(status) FROM " + TABLE + \r
+ " WHERE ticket = ?", new ApprovalLoader(1) {\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ obj[idx]=data.ticket;\r
+ }\r
+ }, readConsistency);\r
+\r
+ psByStatus = new PSInfo(trans, SELECT_SP + helpers[FIELD_COMMAS] + ", WRITETIME(status) FROM " + TABLE + \r
+ " WHERE status = ?", new ApprovalLoader(1) {\r
+ @Override\r
+ protected void key(Data data, int idx, Object[] obj) {\r
+ obj[idx]=data.status;\r
+ }\r
+ }, readConsistency);\r
+\r
+\r
+ }\r
+ \r
+ public Result<List<ApprovalDAO.Data>> readByUser(AuthzTrans trans, String user) {\r
+ return psByUser.read(trans, R_TEXT, new Object[]{user});\r
+ }\r
+\r
+ public Result<List<ApprovalDAO.Data>> readByApprover(AuthzTrans trans, String approver) {\r
+ return psByApprover.read(trans, R_TEXT, new Object[]{approver});\r
+ }\r
+\r
+ public Result<List<ApprovalDAO.Data>> readByTicket(AuthzTrans trans, UUID ticket) {\r
+ return psByTicket.read(trans, R_TEXT, new Object[]{ticket});\r
+ }\r
+\r
+ public Result<List<ApprovalDAO.Data>> readByStatus(AuthzTrans trans, String status) {\r
+ return psByStatus.read(trans, R_TEXT, new Object[]{status});\r
+ } \r
+\r
+ /**\r
+ * Log Modification statements to History\r
+ *\r
+ * @param modified which CRUD action was done\r
+ * @param data entity data that needs a log entry\r
+ * @param overrideMessage if this is specified, we use it rather than crafting a history message based on data\r
+ */\r
+ @Override\r
+ protected void wasModified(AuthzTrans trans, CRUD modified, Data data, String ... override) {\r
+ boolean memo = override.length>0 && override[0]!=null;\r
+ boolean subject = override.length>1 && override[1]!=null;\r
+\r
+ HistoryDAO.Data hd = HistoryDAO.newInitedData();\r
+ hd.user = trans.user();\r
+ hd.action = modified.name();\r
+ hd.target = TABLE;\r
+ hd.subject = subject?override[1]:data.user + "|" + data.approver;\r
+ hd.memo = memo\r
+ ? String.format("%s by %s", override[0], hd.user)\r
+ : (modified.name() + "d approval for " + data.user);\r
+ // Detail?\r
+ // Reconstruct?\r
+ if(historyDAO.create(trans, hd).status!=Status.OK) {\r
+ trans.error().log("Cannot log to History");\r
+ }\r
+ }\r
+\r
+}\r