UI adaptation for supporting ONAP portal SDK

[validation.git] / ui / src / main / webapp / WEB-INF / fusion / orm / Analytics.hbm.xml

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 (file)
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>