diff options
| author |   Christopher Lott (cl778h) <clott@research.att.com> | 2017-06-19 09:53:49 -0400 |
|---|---|---|
| committer | Christopher Lott (cl778h) <clott@research.att.com> | 2017-06-27 16:04:19 -0400 |
| commit | d727214365c22854d337c010b216e42f1b718290 (patch) | |
| tree | e7114493f39760daa6f955cc90b649cbc01ef9c6 /ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF | |
| parent | 1e66cf42be4fa5288fbae0aa589a37ad5e072d24 (diff) | |
[PORTAL-15] Repair RAPTOR and role defects.
Change-Id: I1fd4049f1253801021f97ef7bcb3ffb11d8b8c76
Signed-off-by: Christopher Lott (cl778h) <clott@research.att.com>
Diffstat (limited to 'ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF')
| -rw-r--r-- | ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml index 28060a7c..39939ca0 100644 --- a/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml +++ b/ecomp-sdk/epsdk-app-overlay/src/main/webapp/WEB-INF/fusion/orm/Fusion.hbm.xml @@ -266,6 +266,17 @@ <property name="siteCd" column="broadcast_site_cd" /> </class> + <class name="org.openecomp.portalsdk.analytics.model.base.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> + <!-- State Lookup class mapping details --> <class name="LuState" table="FN_LU_STATE"> <id name="abbr" column="state_cd" /> @@ -349,4 +360,26 @@ <query name="getAllRoles"> select id, name from Role order by name </query> + + <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="insertReportSecurityUsers"> + insert into ReportUserRole (repId, roleId, userId, readOnlyYn) values (:report_id, :role_id, :user_id, :read_only_yn) + </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> |