Portal Spring Boot version Hibernate implementation

Create classes that represent tables in the original database.

Issue-ID: PORTAL-705
Change-Id: I0e1efaf4c8a9e3539a07e11008cd877058866b37
Signed-off-by: Dominik Mizyn <d.mizyn@samsung.com>

2 files changed, 366 insertions, 0 deletions

diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnApp.java b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnApp.java
new file mode 100644
index 00000000..ffc6667a
--- /dev/null
+++ b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnApp.java
@@ -0,0 +1,295 @@
+/*
+ * ============LICENSE_START==========================================
+ * ONAP Portal
+ * ===================================================================
+ * Copyright (C) 2019 AT&T Intellectual Property. All rights reserved.
+ * ===================================================================
+ * Modifications Copyright (c) 2019 Samsung
+ * ===================================================================
+ *
+ * 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============================================
+ *
+ *
+ */
+
+package org.onap.portal.domain.db.fn;
+
+import java.io.Serializable;
+import java.util.ArrayList;
+import java.util.List;
+import javax.persistence.CascadeType;
+import javax.persistence.Column;
+import javax.persistence.Embeddable;
+import javax.persistence.Entity;
+import javax.persistence.FetchType;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
+import javax.persistence.Id;
+import javax.persistence.NamedQueries;
+import javax.persistence.NamedQuery;
+import javax.persistence.OneToMany;
+import javax.persistence.Table;
+import javax.validation.constraints.Digits;
+import javax.validation.constraints.NotNull;
+import javax.validation.constraints.Pattern;
+import javax.validation.constraints.Size;
+import lombok.AllArgsConstructor;
+import lombok.EqualsAndHashCode;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+import org.hibernate.validator.constraints.SafeHtml;
+import org.hibernate.validator.constraints.URL;
+import org.onap.portal.domain.dto.DomainVo;
+
+/*
+CREATE TABLE `fn_app` (
+        `app_id` int(11) NOT NULL AUTO_INCREMENT,
+        `app_name` varchar(100) NOT NULL DEFAULT '?',
+        `app_image_url` varchar(256) DEFAULT NULL,
+        `app_description` varchar(512) DEFAULT NULL,
+        `app_notes` varchar(4096) DEFAULT NULL,
+        `app_url` varchar(256) DEFAULT NULL,
+        `app_alternate_url` varchar(256) DEFAULT NULL,
+        `app_rest_endpoint` varchar(2000) DEFAULT NULL,
+        `ml_app_name` varchar(50) NOT NULL DEFAULT '?',
+        `ml_app_admin_id` varchar(7) NOT NULL DEFAULT '?',
+        `mots_id` int(11) DEFAULT NULL,
+        `app_password` varchar(256) NOT NULL DEFAULT '?',
+        `open` char(1) DEFAULT 'N',
+        `enabled` char(1) DEFAULT 'Y',
+        `thumbnail` mediumblob DEFAULT NULL,
+        `app_username` varchar(50) DEFAULT NULL,
+        `ueb_key` varchar(256) DEFAULT NULL,
+        `ueb_secret` varchar(256) DEFAULT NULL,
+        `ueb_topic_name` varchar(256) DEFAULT NULL,
+        `app_type` int(11) NOT NULL DEFAULT 1,
+        `auth_central` char(1) NOT NULL DEFAULT 'N',
+        `auth_namespace` varchar(100) DEFAULT NULL,
+        PRIMARY KEY (`app_id`)
+        )
+*/
+
+@NamedQueries({
+        @NamedQuery(
+                name = "FnApp.retrieveWhereAuthCentralIsYAndOpenIsNAndAuthNamespaceIsNotNull",
+                query = "from FnApp where auth_central = 'Y' and open = 'N' and auth_namespace is not null")
+})
+
+@Table(name = "fn_app")
+@NoArgsConstructor
+@AllArgsConstructor
+@EqualsAndHashCode(callSuper = true)
+@Embeddable
+@Getter
+@Setter
+@Entity
+public class FnApp extends DomainVo implements Serializable {
+
+       @Id
+       @GeneratedValue(strategy = GenerationType.AUTO)
+       @Column(name = "app_Id", length = 11, nullable = false, columnDefinition = "int(11) AUTO_INCREMENT")
+       @Digits(integer = 11, fraction = 0)
+       private Long appId;
+       @Column(name = "app_name", length = 100, nullable = false, columnDefinition = "varchar(100) not null default '?'")
+       @Size(max = 100)
+       @SafeHtml
+       @NotNull
+       private String appName;
+       @Column(name = "app_image_url", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       private String appImageUrl;
+       @Column(name = "app_description", length = 512)
+       @Size(max = 256)
+       @SafeHtml
+       private String appDescription;
+       @Column(name = "app_notes", length = 4096)
+       @Size(max = 4096)
+       @SafeHtml
+       private String appNotes;
+       @Column(name = "app_url", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       //TODO URL
+       @URL
+       private String appUrl;
+       @Column(name = "app_alternate_url", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       private String appAlternateUrl;
+       @Column(name = "app_rest_endpoint", length = 2000)
+       @Size(max = 2000)
+       @SafeHtml
+       private String appRestEndpoint;
+       @Column(name = "ml_app_name", length = 50, nullable = false, columnDefinition = "varchar(50) not null default '?'")
+       @Size(max = 50)
+       @SafeHtml
+       @NotNull
+       private String ml_app_name;
+       @Column(name = "ml_app_admin_id", length = 7, nullable = false, columnDefinition = "varchar(7) not null default '?'")
+       @Size(max = 7)
+       @SafeHtml
+       @NotNull
+       private String mlAppAdminId;
+       @Column(name = "mots_id", length = 11)
+       @Digits(integer = 11, fraction = 0)
+       private Long motsId;
+       @Column(name = "app_password", length = 256, nullable = false, columnDefinition = "varchar(256) not null default '?'")
+       @Size(max = 256)
+       @SafeHtml
+       @NotNull
+       private String appPassword;
+       @Column(name = "open", length = 1, columnDefinition = "char(1) default 'N'")
+       @Pattern(regexp = "[YNyn]")
+       @Size(max = 1)
+       @NotNull
+       @SafeHtml
+       private String open;
+       @Column(name = "ENABLED", length = 1, columnDefinition = "char(1) default 'N'")
+       @Pattern(regexp = "[YNyn]")
+       @Size(max = 1)
+       @NotNull
+       @SafeHtml
+       private String enabled;
+       @Column(name = "active_yn", length = 1, columnDefinition = "char(1) default 'Y'")
+       @Pattern(regexp = "[YNyn]")
+       @Size(max = 1)
+       @NotNull
+       @SafeHtml
+       private String activeYn;
+       @Column(name = "thumbnail", columnDefinition = "mediumblob null default null")
+       private byte[] thumbnail;
+       @Column(name = "app_username", length = 50)
+       @Size(max = 50)
+       @SafeHtml
+       private String appUsername;
+       @Column(name = "ueb_key", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       private String uebKey;
+       @Column(name = "ueb_secret", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       private String uebSecret;
+       @Column(name = "ueb_topic_name", length = 256)
+       @Size(max = 256)
+       @SafeHtml
+       private String uebTopicName;
+       @Column(name = "app_type", length = 11, columnDefinition = "int(11) not null default 1")
+       @Digits(integer = 11, fraction = 0)
+       private Long appType;
+       @Column(name = "auth_central", length = 1, columnDefinition = "char(1) not null default 'N'", nullable = false)
+       @Pattern(regexp = "[YNyn]")
+       @Size(max = 1)
+       @NotNull
+       @SafeHtml
+       private String authCentral;
+       @Column(name = "auth_namespace", length = 100)
+       @Size(max = 100)
+       @SafeHtml
+       private String authNamespace;
+       @OneToMany(
+               targetEntity = FnMenuFunctionalRoles.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<FnMenuFunctionalRoles> fnMenuFunctionalRoles = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpUserRolesRequest.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpUserRolesRequest> epUserRolesRequests = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpAppFunction.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpAppFunction> epAppFunctions = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpAppRoleFunction.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpAppRoleFunction> epAppRoleFunctions = new ArrayList<>();
+       @OneToMany(
+               targetEntity = FnUserRole.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<FnUserRole> fnUserRoles = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpWebAnalyticsSource.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpWebAnalyticsSource> epWebAnalyticsSources = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpWidgetCatalogRole.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpWidgetCatalogRole> epWidgetCatalogRoles = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpMicroservice.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpMicroservice> epMicroservices = new ArrayList<>();
+       @OneToMany(
+               targetEntity = EpPersUserAppManSort.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<EpPersUserAppManSort> epPersUserAppManSorts = new ArrayList<>();
+       @OneToMany(
+               targetEntity = FnPersUserAppSel.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<FnPersUserAppSel> fnPersUserAppSels = new ArrayList<>();
+       @OneToMany(
+               targetEntity = FnWidget.class,
+               mappedBy = "appId",
+               cascade = CascadeType.ALL,
+               fetch = FetchType.LAZY
+       )
+       private List<FnWidget> fnWidgets = new ArrayList<>();
+}
diff --git a/portal-BE/src/main/java/org/onap/portal/domain/dto/DomainVo.java b/portal-BE/src/main/java/org/onap/portal/domain/dto/DomainVo.java
new file mode 100644
index 00000000..f6419940
--- /dev/null
+++ b/portal-BE/src/main/java/org/onap/portal/domain/dto/DomainVo.java
@@ -0,0 +1,71 @@
+package org.onap.portal.domain.dto;
+
+import java.io.ByteArrayInputStream;
+import java.io.ByteArrayOutputStream;
+import java.io.ObjectInputStream;
+import java.io.ObjectOutputStream;
+import java.io.Serializable;
+import java.util.Date;
+import java.util.Set;
+import javax.persistence.Inheritance;
+import javax.persistence.InheritanceType;
+import lombok.AllArgsConstructor;
+import lombok.EqualsAndHashCode;
+import lombok.Getter;
+import lombok.NoArgsConstructor;
+import lombok.Setter;
+import org.onap.portalapp.portal.domain.db.fn.FnUser;
+import org.onap.portalsdk.core.domain.FusionVo;
+
+@Getter
+@Setter
+@EqualsAndHashCode(callSuper = true)
+@NoArgsConstructor
+@AllArgsConstructor
+@Inheritance(strategy = InheritanceType.JOINED)
+public class DomainVo extends FusionVo implements Serializable, Cloneable, Comparable {
+       private static final long serialVersionUID = 1L;
+       protected Long id;
+       protected Date created;
+       protected Date modified;
+       protected FnUser createdId;
+       protected FnUser modifiedId;
+       protected Long rowNum;
+       protected Serializable auditUserId;
+       protected Set auditTrail = null;
+
+       @Override
+       public int compareTo(Object obj) {
+              Long c1 = this.getId();
+              Long c2 = ((org.onap.portalsdk.core.domain.support.DomainVo)obj).getId();
+              return c1 != null && c2 != null ? c1.compareTo(c2) : 1;
+       }
+
+       public Object copy(boolean isIdNull) {
+              ByteArrayOutputStream baos = null;
+              ByteArrayInputStream bais = null;
+              ObjectOutputStream oos = null;
+              ObjectInputStream ois = null;
+              DomainVo newVo = null;
+
+              try {
+                     baos = new ByteArrayOutputStream();
+                     oos = new ObjectOutputStream(baos);
+                     oos.writeObject(this);
+                     bais = new ByteArrayInputStream(baos.toByteArray());
+                     ois = new ObjectInputStream(bais);
+                     newVo = (DomainVo)ois.readObject();
+                     if (isIdNull) {
+                            newVo.setId(null);
+                     }
+              } catch (Exception var8) {
+                     var8.printStackTrace();
+              }
+
+              return newVo;
+       }
+
+       public Object clone() throws CloneNotSupportedException {
+              return super.clone();
+       }
+}