diff options
Diffstat (limited to 'mso-api-handlers/mso-requests-db/src/main/resources')
4 files changed, 277 insertions, 0 deletions
diff --git a/mso-api-handlers/mso-requests-db/src/main/resources/InfraActiveRequests.hbm.xml b/mso-api-handlers/mso-requests-db/src/main/resources/InfraActiveRequests.hbm.xml new file mode 100644 index 0000000000..b98177ae83 --- /dev/null +++ b/mso-api-handlers/mso-requests-db/src/main/resources/InfraActiveRequests.hbm.xml @@ -0,0 +1,146 @@ +<?xml version="1.0"?> +<!-- + ============LICENSE_START======================================================= + ECOMP MSO + ================================================================================ + Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. + ================================================================================ + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file 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. + ============LICENSE_END========================================================= + --> + +<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" + "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> +<!-- Generated Jul 27, 2015 3:05:00 PM by Hibernate Tools 3.4.0.CR1 --> +<hibernate-mapping> + <class name="org.openecomp.mso.requestsdb.InfraActiveRequests" table="INFRA_ACTIVE_REQUESTS"> + <id name="requestId" type="string"> + <column name="REQUEST_ID" length="45"/> + <generator class="assigned"/> + </id> + <property name="clientRequestId" type="string" unique="true"> + <column name="CLIENT_REQUEST_ID" length="45" unique="true"/> + </property> + <property name="action" type="string"> + <column name="ACTION" length="45" not-null="true"/> + </property> + <property name="requestStatus" type="string"> + <column name="REQUEST_STATUS" length="20"/> + </property> + <property name="statusMessage" type="string"> + <column name="STATUS_MESSAGE" length="2000"/> + </property> + <property name="progress" type="java.lang.Long"> + <column name="PROGRESS" precision="11" scale="0"/> + </property> + <property name="startTime" type="timestamp"> + <column name="START_TIME"/> + </property> + <property name="endTime" type="timestamp"> + <column name="END_TIME"/> + </property> + <property name="source" type="string"> + <column name="SOURCE" length="45"/> + </property> + <property name="vnfId" type="string"> + <column name="VNF_ID" length="45"/> + </property> + <property name="vnfName" type="string"> + <column name="VNF_NAME" length="80"/> + </property> + <property name="vnfType" type="string"> + <column name="VNF_TYPE" length="200"/> + </property> + <property name="serviceType" type="string"> + <column name="SERVICE_TYPE" length="45"/> + </property> + <property name="aicNodeClli" type="string"> + <column name="AIC_NODE_CLLI" length="11"/> + </property> + <property name="tenantId" type="string"> + <column name="TENANT_ID" length="45"/> + </property> + <property name="provStatus" type="string"> + <column name="PROV_STATUS" length="20"/> + </property> + <property name="vnfParams" type="text"> + <column name="VNF_PARAMS"/> + </property> + <property name="vnfOutputs" type="text"> + <column name="VNF_OUTPUTS"/> + </property> + <property name="requestBody" type="text"> + <column name="REQUEST_BODY"/> + </property> + <property name="responseBody" type="text"> + <column name="RESPONSE_BODY"/> + </property> + <property name="lastModifiedBy" type="string"> + <column name="LAST_MODIFIED_BY" length="50"/> + </property> + <property name="modifyTime" type="timestamp"> + <column name="MODIFY_TIME"/> + </property> + <property name="requestType" type="string"> + <column name="REQUEST_TYPE" length="20"/> + </property> + <property name="volumeGroupId" type="string"> + <column name="VOLUME_GROUP_ID" length="45"/> + </property> + <property name="volumeGroupName" type="string"> + <column name="VOLUME_GROUP_NAME" length="45"/> + </property> + <property name="vfModuleId" type="string"> + <column name="VF_MODULE_ID" length="45"/> + </property> + <property name="vfModuleName" type="string"> + <column name="VF_MODULE_NAME" length="200"/> + </property> + <property name="vfModuleModelName" type="string"> + <column name="VF_MODULE_MODEL_NAME" length="200"/> + </property> + <property name="aaiServiceId" type="string"> + <column name="AAI_SERVICE_ID" length="50"/> + </property> + <property name="aicCloudRegion" type="string"> + <column name="AIC_CLOUD_REGION" length="11"/> + </property> + <property name="callBackUrl" type="string"> + <column name="CALLBACK_URL" length="200"/> + </property> + <property name="correlator" type="string"> + <column name="CORRELATOR" length="80"/> + </property> + <property name="serviceInstanceId" type="string"> + <column name="SERVICE_INSTANCE_ID" length="45"/> + </property> + <property name="serviceInstanceName" type="string"> + <column name="SERVICE_INSTANCE_NAME" length="80"/> + </property> + <property name="requestScope" type="string"> + <column name="REQUEST_SCOPE" length="20"/> + </property> + <property name="requestAction" type="string"> + <column name="REQUEST_ACTION" length="45" not-null="true"/> + </property> + <property name="networkId" type="string"> + <column name="NETWORK_ID" length="45"/> + </property> + <property name="networkName" type="string"> + <column name="NETWORK_NAME" length="80"/> + </property> + <property name="networkType" type="string"> + <column name="NETWORK_TYPE" length="80"/> + </property> + </class> +</hibernate-mapping> diff --git a/mso-api-handlers/mso-requests-db/src/main/resources/SiteStatus.hbm.xml b/mso-api-handlers/mso-requests-db/src/main/resources/SiteStatus.hbm.xml new file mode 100644 index 0000000000..95ccfda5fe --- /dev/null +++ b/mso-api-handlers/mso-requests-db/src/main/resources/SiteStatus.hbm.xml @@ -0,0 +1,35 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + ============LICENSE_START======================================================= + ECOMP MSO + ================================================================================ + Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. + ================================================================================ + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file 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. + ============LICENSE_END========================================================= + --> + +<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> + +<hibernate-mapping package="org.openecomp.mso.requestsdb"> + <class name="SiteStatus" table="SITE_STATUS"> + <meta attribute="class-description"> + This class describes a Site Status + </meta> + + <id name="siteName" type="string" column="SITE_NAME"/> + + <property name="status" column="STATUS" type="boolean" length="256"/> + <property name="created" column="CREATION_TIMESTAMP" type="timestamp" generated="insert" insert="false" update="false"/> + </class> +</hibernate-mapping> diff --git a/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-mysql.cfg.xml b/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-mysql.cfg.xml new file mode 100644 index 0000000000..531b77196c --- /dev/null +++ b/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-mysql.cfg.xml @@ -0,0 +1,37 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + ============LICENSE_START======================================================= + ECOMP MSO + ================================================================================ + Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. + ================================================================================ + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file 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. + ============LICENSE_END========================================================= + --> + +<!DOCTYPE hibernate-configuration PUBLIC + "-//Hibernate/Hibernate Configuration DTD 3.0//EN" + "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> +<hibernate-configuration> + <session-factory> + <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> + <property name="hibernate.show_sql">false</property> + <property name="hibernate.format_sql">true</property> + <property name="connection.datasource">java:jboss/datasources/mso-requests</property> + +<!-- <property name="hibernate.hbm2ddl.auto">create</property> --> + + <mapping resource="InfraActiveRequests.hbm.xml"></mapping> + <mapping resource="SiteStatus.hbm.xml"></mapping> + </session-factory> +</hibernate-configuration> diff --git a/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-requests-ajsc.cfg.xml b/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-requests-ajsc.cfg.xml new file mode 100644 index 0000000000..14bd7b5e69 --- /dev/null +++ b/mso-api-handlers/mso-requests-db/src/main/resources/hibernate-requests-ajsc.cfg.xml @@ -0,0 +1,59 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + ============LICENSE_START======================================================= + ECOMP MSO + ================================================================================ + Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. + ================================================================================ + Licensed under the Apache License, Version 2.0 (the "License"); + you may not use this file 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. + ============LICENSE_END========================================================= + --> + +<!DOCTYPE hibernate-configuration PUBLIC + "-//Hibernate/Hibernate Configuration DTD 3.0//EN" + "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> +<hibernate-configuration> + <session-factory> + <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> + <property name="hibernate.show_sql">false</property> + <property name="hibernate.format_sql">true</property> + + <mapping resource="InfraActiveRequests.hbm.xml"></mapping> + <mapping resource="SiteStatus.hbm.xml"></mapping> + </session-factory> + <!-- <session-factory name="MSORequestsFactory"> + <property name="connection.url">${REQUESTS_CONNECTION_URL}</property> + <property name="connection.username">${REQUESTS_USERNAME}</property> + <property name="connection.password">${REQUESTS_PASSWORD}</property> + <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> + <property name="hibernate.default_schema">mso_requests</property> + <property name="connection.driver_class">org.mariadb.jdbc.Driver</property> + <property name="hibernate.current_session_context_class">thread</property> + <property name="hibernate.show_sql">false</property> + <property name="hibernate.format_sql">true</property> + + + <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> + <property name="hibernate.c3p0.min_size">${REQUESTS_MIN_POOL_SIZE}</property> + <property name="hibernate.c3p0.max_size">${REQUESTS_MAX_POOL_SIZE}</property> + <property name="hibernate.c3p0.timeout">${REQUESTS_TIMEOUT}</property> + <property name="hibernate.c3p0.max_statements">50</property> + <property name="hibernate.c3p0.idle_test_period">1000</property> + <property name="hibernate.connection.provider_class">org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider</property> + + + + <mapping resource="InfraActiveRequests.hbm.xml"></mapping> + + </session-factory> --> +</hibernate-configuration> |