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.dao;
24 import java.io.ByteArrayInputStream;
25 import java.io.DataInputStream;
26 import java.lang.reflect.Field;
27 import java.nio.ByteBuffer;
28 import java.util.List;
30 import org.onap.aaf.auth.dao.cass.Status;
31 import org.onap.aaf.auth.env.AuthzTrans;
32 import org.onap.aaf.auth.layer.Result;
33 import org.onap.aaf.misc.env.TransStore;
35 import com.datastax.driver.core.Cluster;
36 import com.datastax.driver.core.ConsistencyLevel;
37 import com.datastax.driver.core.ResultSet;
38 import com.datastax.driver.core.ResultSetFuture;
43 * Deal with the essentials of Interaction with Cassandra DataStore for all Cassandra DAOs
49 public class CassDAOImpl<TRANS extends TransStore,DATA> extends AbsCassDAO<TRANS, DATA> implements DAO<TRANS,DATA> {
50 public static final String USER_NAME = "__USER_NAME__";
51 protected static final String CREATE_SP = "CREATE ";
52 protected static final String UPDATE_SP = "UPDATE ";
53 protected static final String DELETE_SP = "DELETE ";
54 protected static final String SELECT_SP = "SELECT ";
56 protected final String C_TEXT = getClass().getSimpleName() + " CREATE";
57 protected final String R_TEXT = getClass().getSimpleName() + " READ";
58 protected final String U_TEXT = getClass().getSimpleName() + " UPDATE";
59 protected final String D_TEXT = getClass().getSimpleName() + " DELETE";
62 protected final ConsistencyLevel readConsistency,writeConsistency;
64 // Setteable only by CachedDAO
65 protected Cached<?, ?> cache;
68 * A Constructor from the originating Cluster. This DAO will open the Session at need,
69 * and shutdown the session when "close()" is called.
75 public CassDAOImpl(TRANS trans, String name, Cluster cluster, String keyspace, Class<DATA> dataClass, String table, ConsistencyLevel read, ConsistencyLevel write) {
76 super(trans, name, cluster,keyspace,dataClass);
78 readConsistency = read;
79 writeConsistency = write;
83 * A Constructor to share Session with other DAOs.
85 * This method get the Session and Cluster information from the calling DAO, and won't
86 * touch the Session on closure.
91 public CassDAOImpl(TRANS trans, String name, AbsCassDAO<TRANS,?> aDao, Class<DATA> dataClass, String table, ConsistencyLevel read, ConsistencyLevel write) {
92 super(trans, name, aDao,dataClass);
94 readConsistency = read;
95 writeConsistency = write;
98 protected PSInfo createPS;
99 protected PSInfo readPS;
100 protected PSInfo updatePS;
101 protected PSInfo deletePS;
102 protected boolean async=false;
104 public void async(boolean bool) {
108 public final String[] setCRUD(TRANS trans, String table, Class<?> dc,Loader<DATA> loader) {
109 return setCRUD(trans, table, dc, loader, -1);
112 public final String[] setCRUD(TRANS trans, String table, Class<?> dc,Loader<DATA> loader, int max) {
113 Field[] fields = dc.getDeclaredFields();
114 int end = max>=0 & max<fields.length?max:fields.length;
115 // get keylimit from a non-null Loader
116 int keylimit = loader.keylimit();
118 StringBuilder sbfc = new StringBuilder();
119 StringBuilder sbq = new StringBuilder();
120 StringBuilder sbwc = new StringBuilder();
121 StringBuilder sbup = new StringBuilder();
124 for(int i=0;i<end;++i) {
129 sbwc.append(" AND ");
132 sbfc.append(fields[i].getName());
138 sbup.append(fields[i].getName());
142 sbwc.append(fields[i].getName());
147 createPS = new PSInfo(trans, "INSERT INTO " + table + " ("+ sbfc +") VALUES ("+ sbq +");",loader,writeConsistency);
149 readPS = new PSInfo(trans, "SELECT " + sbfc + " FROM " + table + " WHERE " + sbwc + ';',loader,readConsistency);
151 // Note: UPDATES can't compile if there are no fields besides keys... Use "Insert"
152 if(sbup.length()==0) {
153 updatePS = createPS; // the same as an insert
155 updatePS = new PSInfo(trans, "UPDATE " + table + " SET " + sbup + " WHERE " + sbwc + ';',loader,writeConsistency);
158 deletePS = new PSInfo(trans, "DELETE FROM " + table + " WHERE " + sbwc + ';',loader,writeConsistency);
160 return new String[] {sbfc.toString(), sbq.toString(), sbup.toString(), sbwc.toString()};
163 public void replace(CRUD crud, PSInfo psInfo) {
165 case create: createPS = psInfo; break;
166 case read: readPS = psInfo; break;
167 case update: updatePS = psInfo; break;
168 case delete: deletePS = psInfo; break;
172 public void disable(CRUD crud) {
174 case create: createPS = null; break;
175 case read: readPS = null; break;
176 case update: updatePS = null; break;
177 case delete: deletePS = null; break;
183 * Given a DATA object, extract the individual elements from the Data into an Object Array for the
186 public Result<DATA> create(TRANS trans, DATA data) {
188 return Result.err(Result.ERR_NotImplemented,"Create is disabled for %s",getClass().getSimpleName());
190 if(async) /*ResultSetFuture */ {
191 Result<ResultSetFuture> rs = createPS.execAsync(trans, C_TEXT, data);
193 return Result.err(rs);
196 Result<ResultSet> rs = createPS.exec(trans, C_TEXT, data);
198 return Result.err(rs);
201 wasModified(trans, CRUD.create, data);
202 return Result.ok(data);
206 * Read the Unique Row associated with Full Keys
208 public Result<List<DATA>> read(TRANS trans, DATA data) {
210 return Result.err(Result.ERR_NotImplemented,"Read is disabled for %s",getClass().getSimpleName());
212 return readPS.read(trans, R_TEXT, data);
215 public Result<List<DATA>> read(TRANS trans, Object ... key) {
217 return Result.err(Result.ERR_NotImplemented,"Read is disabled for %s",getClass().getSimpleName());
219 return readPS.read(trans, R_TEXT, key);
222 public Result<DATA> readPrimKey(TRANS trans, Object ... key) {
224 return Result.err(Result.ERR_NotImplemented,"Read is disabled for %s",getClass().getSimpleName());
226 Result<List<DATA>> rld = readPS.read(trans, R_TEXT, key);
229 return Result.err(Result.ERR_NotFound,rld.details);
231 return Result.ok(rld.value.get(0));
234 return Result.err(rld);
238 public Result<Void> update(TRANS trans, DATA data) {
239 return update(trans, data, async);
242 public Result<Void> update(TRANS trans, DATA data, boolean async) {
244 return Result.err(Result.ERR_NotImplemented,"Update is disabled for %s",getClass().getSimpleName());
246 if(async)/* ResultSet rs =*/ {
247 Result<ResultSetFuture> rs = updatePS.execAsync(trans, U_TEXT, data);
249 return Result.err(rs);
252 Result<ResultSet> rs = updatePS.exec(trans, U_TEXT, data);
254 return Result.err(rs);
258 wasModified(trans, CRUD.update, data);
262 // This method Sig for Cached...
263 public Result<Void> delete(TRANS trans, DATA data, boolean reread) {
265 return Result.err(Result.ERR_NotImplemented,"Delete is disabled for %s",getClass().getSimpleName());
267 // Since Deleting will be stored off, for possible re-constitution, need the whole thing
269 Result<List<DATA>> rd = read(trans,data);
271 return Result.err(rd);
274 return Result.err(Status.ERR_NotFound,"Not Found");
276 for(DATA d : rd.value) {
278 Result<ResultSetFuture> rs = deletePS.execAsync(trans, D_TEXT, d);
280 return Result.err(rs);
283 Result<ResultSet> rs = deletePS.exec(trans, D_TEXT, d);
285 return Result.err(rs);
288 wasModified(trans, CRUD.delete, d);
291 if(async)/* ResultSet rs =*/ {
292 Result<ResultSetFuture> rs = deletePS.execAsync(trans, D_TEXT, data);
294 return Result.err(rs);
297 Result<ResultSet> rs = deletePS.exec(trans, D_TEXT, data);
299 return Result.err(rs);
302 wasModified(trans, CRUD.delete, data);
307 public final Object[] keyFrom(DATA data) {
308 return createPS.keyFrom(data);
312 public String table() {
316 public static final String CASS_READ_CONSISTENCY="cassandra.readConsistency";
317 public static final String CASS_WRITE_CONSISTENCY="cassandra.writeConsistency";
318 protected static ConsistencyLevel readConsistency(AuthzTrans trans, String table) {
319 String prop = trans.getProperty(CASS_READ_CONSISTENCY+'.'+table);
321 prop = trans.getProperty(CASS_READ_CONSISTENCY);
323 return ConsistencyLevel.ONE; // this is Cassandra Default
326 return ConsistencyLevel.valueOf(prop);
329 protected static ConsistencyLevel writeConsistency(AuthzTrans trans, String table) {
330 String prop = trans.getProperty(CASS_WRITE_CONSISTENCY+'.'+table);
332 prop = trans.getProperty(CASS_WRITE_CONSISTENCY);
334 return ConsistencyLevel.ONE; // this is Cassandra Default\
337 return ConsistencyLevel.valueOf(prop);
340 public static DataInputStream toDIS(ByteBuffer bb) {
341 byte[] b = bb.array();
342 return new DataInputStream(
343 new ByteArrayInputStream(b,bb.position(),bb.limit())