X-Git-Url: https://gerrit.akraino.org/r/gitweb?p=validation.git;a=blobdiff_plain;f=ui%2Fsrc%2Fmain%2Fwebapp%2FWEB-INF%2Ffusion%2Form%2FAnalytics.hbm.xml;fp=ui%2Fsrc%2Fmain%2Fwebapp%2FWEB-INF%2Ffusion%2Form%2FAnalytics.hbm.xml;h=95d1468a451583ec37e54d755710b098b41d1369;hp=0000000000000000000000000000000000000000;hb=2879b2ee5e1e2815e5f43cb802352bf2878397af;hpb=ce4ad29dc48317cc7cb60fe433072ac46dea2ebb

diff --git a/ui/src/main/webapp/WEB-INF/fusion/orm/Analytics.hbm.xml b/ui/src/main/webapp/WEB-INF/fusion/orm/Analytics.hbm.xml
new file mode 100644
index 0000000..95d1468
--- /dev/null
+++ b/ui/src/main/webapp/WEB-INF/fusion/orm/Analytics.hbm.xml
@@ -0,0 +1,57 @@
+<?xml version="1.0"?>
+<!-- ============LICENSE_START==========================================
+    ONAP Portal SDK ===================================================================
+    Copyright © 2017 AT&T Intellectual Property. All rights reserved. ===================================================================
+    Unless otherwise specified, all software contained herein is licensed under
+    the Apache License, Version 2.0 (the “License”); you may not use this software
+    except in compliance with the License. You may obtain a copy of the License
+    at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable
+    law or agreed to in writing, software distributed under the License is distributed
+    on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either
+    express or implied. See the License for the specific language governing permissions
+    and limitations under the License. Unless otherwise specified, all documentation
+    contained herein is licensed under the Creative Commons License, Attribution
+    4.0 Intl. (the “License”); you may not use this documentation except in compliance
+    with the License. You may obtain a copy of the License at https://creativecommons.org/licenses/by/4.0/
+    Unless required by applicable law or agreed to in writing, documentation
+    distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+    WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+    License for the specific language governing permissions and limitations under
+    the License. ============LICENSE_END============================================ -->
+
+<!DOCTYPE hibernate-mapping PUBLIC
+        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+
+<hibernate-mapping
+    package="org.onap.portalsdk.analytics.model.base">
+
+    <class name="ReportUserRole" table="cr_report_access">
+        <composite-id>
+            <key-property name="repId" column="rep_id" />
+            <key-property name="orderNo" column="order_no" />
+        </composite-id>
+
+        <property name="roleId" column="role_id" />
+        <property name="userId" column="user_id" />
+        <property name="readOnlyYn" column="read_only_yn" />
+    </class>
+
+    <query name="getReportSecurityUsers">
+        select repId, orderNo, roleId, userId, readOnlyYn from ReportUserRole where
+        repId = :report_id and userId is not null
+    </query>
+
+    <query name="getReportSecurityRoles">
+        select repId, orderNo, roleId, userId, readOnlyYn from ReportUserRole where
+        repId = :report_id and roleId is not null
+    </query>
+
+    <query name="deleteReportSecurityUsers">
+        delete from ReportUserRole where repId = :report_id and userId =:user_id
+    </query>
+
+    <query name="deleteReportSecurityRoles">
+        delete from ReportUserRole where repId = :report_id and roleId =:role_id
+    </query>
+</hibernate-mapping>