1 files changed, 18 insertions, 0 deletions

diff --git a/openecomp-be/tools/zusammen-tools/src/main/java/org/openecomp/core/tools/store/PermissionHandler.java b/openecomp-be/tools/zusammen-tools/src/main/java/org/openecomp/core/tools/store/PermissionHandler.java
index 9b7b0f62e6..ecde9e900a 100644
--- a/openecomp-be/tools/zusammen-tools/src/main/java/org/openecomp/core/tools/store/PermissionHandler.java
+++ b/openecomp-be/tools/zusammen-tools/src/main/java/org/openecomp/core/tools/store/PermissionHandler.java
@@ -2,13 +2,17 @@ package org.openecomp.core.tools.store;
 
 import com.datastax.driver.core.ResultSet;
 import com.datastax.driver.core.Row;
+import com.datastax.driver.mapping.Result;
 import com.datastax.driver.mapping.annotations.Accessor;
 import com.datastax.driver.mapping.annotations.Query;
 import org.openecomp.core.nosqldb.api.NoSqlDb;
 import org.openecomp.core.nosqldb.factory.NoSqlDbFactory;
+import org.openecomp.sdc.itempermissions.type.ItemPermissionsEntity;
 
+import java.util.List;
 import java.util.Objects;
 import java.util.Optional;
+import java.util.Set;
 
 public class PermissionHandler {
 
@@ -32,6 +36,14 @@ public class PermissionHandler {
     accessor.setItemUserPermission(itemId, user, permission);
   }
 
+  public void addItem(Set<String> items, String userId, String permission){
+    accessor.addItem(items,userId,permission);
+  }
+
+  public List<ItemPermissionsEntity> getAll(){
+    return accessor.getAll().all();
+  }
+
 
   @Accessor
   interface PermissionAccessor {
@@ -43,6 +55,12 @@ public class PermissionHandler {
 
     @Query("SELECT permission FROM dox.item_permissions WHERE item_id=? AND user_id=?")
     ResultSet getItemUserPermission(String itemId, String userId);
+
+    @Query("SELECT * from dox.item_permissions")
+    Result<ItemPermissionsEntity> getAll();
+
+    @Query("update dox.user_permission_items set item_list=item_list+? WHERE user_id = ? AND permission = ?")
+    void addItem(Set<String> items, String userId, String permission);
   }
 
 }
\ No newline at end of file