<?xml version="1.0"?>
<!--
- ================================================================================
- ECOMP Portal
- ================================================================================
- Copyright (C) 2017 AT&T Intellectual Property
- ================================================================================
- Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License.
+ ============LICENSE_START==========================================
+ ONAP Portal
+ ===================================================================
+ Copyright (C) 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
-
+
+ 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============================================
+
+ ECOMP is a trademark and service mark of AT&T Intellectual Property.
-->
<!DOCTYPE hibernate-mapping PUBLIC
Publishes mappings and queries for EP SDK library features ONLY.
Portal app mappings and features are in EP.hbm.xml.
-->
-<hibernate-mapping package="org.openecomp.portalsdk.core.domain">
+<hibernate-mapping package="org.onap.portalsdk.core.domain">
<!-- User class mapping details -->
<class name="User" table="FN_USER">
<set name="userApps" table="FN_USER_ROLE" lazy="false" sort="natural" inverse="true" cascade="all-delete-orphan">
<key column="user_id"/>
- <one-to-many class="org.openecomp.portalsdk.core.domain.UserApp" />
+ <one-to-many class="org.onap.portalsdk.core.domain.UserApp" />
</set>
<set name="pseudoRoles" table="FN_USER_PSEUDO_ROLE" lazy="false" sort="natural">
<key column="user_id"/>
- <many-to-many column="pseudo_role_id" class="org.openecomp.portalsdk.core.domain.Role" />
+ <many-to-many column="pseudo_role_id" class="org.onap.portalsdk.core.domain.Role" />
</set>
</class>
<key-property name="userId" type="long">
<column name="user_id" precision="11" scale="0" />
</key-property>
- <key-many-to-one name="app" class="org.openecomp.portalsdk.core.domain.App" column="app_id" />
- <key-many-to-one name="role" class="org.openecomp.portalsdk.core.domain.Role" column="role_id" />
+ <key-many-to-one name="app" class="org.onap.portalsdk.core.domain.App" column="app_id" />
+ <key-many-to-one name="role" class="org.onap.portalsdk.core.domain.Role" column="role_id" />
</composite-id>
<property name="priority" type="java.lang.Short">
<column name="priority" precision="4" scale="0" />
<set name="roleFunctions" table="FN_ROLE_FUNCTION" lazy="false" sort="natural">
<key column="role_id"/>
- <many-to-many column="function_cd" class="org.openecomp.portalsdk.core.domain.RoleFunction"/>
+ <many-to-many column="function_cd" class="org.onap.portalsdk.core.domain.RoleFunction"/>
</set>
<set name="childRoles" table="FN_ROLE_COMPOSITE" lazy="false" sort="natural">
<key column="parent_role_id"/>
- <many-to-many column="child_role_id" class="org.openecomp.portalsdk.core.domain.Role"/>
+ <many-to-many column="child_role_id" class="org.onap.portalsdk.core.domain.Role"/>
</set>
<set name="parentRoles" table="FN_ROLE_COMPOSITE" lazy="false" sort="natural">
<key column="child_role_id"/>
- <many-to-many column="parent_role_id" class="org.openecomp.portalsdk.core.domain.Role"/>
+ <many-to-many column="parent_role_id" class="org.onap.portalsdk.core.domain.Role"/>
</set>
</class>
<!-- Lookup (id/value bean) class mapping details -->
<class name="Lookup">
- <composite-id name="nameValueId" class="org.openecomp.portalsdk.core.domain.support.NameValueId">
+ <composite-id name="nameValueId" class="org.onap.portalsdk.core.domain.support.NameValueId">
<key-property name="val"/>
<key-property name="lab" />
</composite-id>
</class>
<class name="UrlsAccessible" table="V_URL_ACCESS">
- <composite-id name="urlsAccessibleKey" class="org.openecomp.portalsdk.core.domain.UrlsAccessibleKey">
+ <composite-id name="urlsAccessibleKey" class="org.onap.portalsdk.core.domain.UrlsAccessibleKey">
<key-property name="url" column="url"/>
<key-property name="functionCd" column="function_cd"/>
</composite-id>
select email from User where id = :user_id
</query>
+ <query name="getAppPassword">
+ select id,appPassword from App
+ </query>
+
<query name="getAllUsers">
select id, firstName, lastName from User where active = true order by lastName, firstName
</query>
select sum(total_lines) TOTAL_LINES from demo_kpi_sourcecode_stats group by category1
]]>
</sql-query>
-
+
</hibernate-mapping>