From c2dfca4b1ca4cecd7595b4a5618d89fd44093a13 Mon Sep 17 00:00:00 2001 From: Dominik Mizyn Date: Fri, 16 Aug 2019 13:13:31 +0200 Subject: [PATCH] Portal Spring Boot version Hibernate implementation Create classes that represent tables in the original database. Issue-ID: PORTAL-705 Change-Id: I10a8d8ff265dc91c07783f2d2d4edb3aab971805 Signed-off-by: Dominik Mizyn --- .../java/org/onap/portal/domain/db/fn/FnRoleV.java | 80 ++++++++++++++++++++ .../domain/db/fn/compositePK/FnQzTriggersId.java | 85 ++++++++++++++++++++++ 2 files changed, 165 insertions(+) create mode 100644 portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRoleV.java create mode 100644 portal-BE/src/main/java/org/onap/portal/domain/db/fn/compositePK/FnQzTriggersId.java diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRoleV.java b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRoleV.java new file mode 100644 index 00000000..7eb96d6f --- /dev/null +++ b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/FnRoleV.java @@ -0,0 +1,80 @@ +/* + * ============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.math.BigInteger; +import javax.persistence.Column; +import javax.persistence.Entity; +import javax.persistence.Id; +import javax.persistence.Table; +import lombok.Getter; +import lombok.NoArgsConstructor; +import org.hibernate.annotations.Immutable; +import org.hibernate.annotations.Subselect; + +@Entity +@Table(name = "fn_role_v") +@Immutable +@Subselect("select fn_role.role_id as role_id," + + " fn_role.role_name as role_name," + + " fn_role.active_yn as active_yn," + + " fn_role.priority as priority," + + " fn_role.app_id as app_id," + + " fn_role.app_role_id as app_role_id" + + " from fn_role where isnull(fn_role.app_id)") +@Getter +@NoArgsConstructor +public class FnRoleV { + @Id + @Column(name = "role_id") + private Integer roleId; + @Column(name = "role_name") + private String roleName; + @Column(name = "active_yn") + private String activeYn; + @Column(name = "priority") + private BigInteger priority; + @Column(name = "app_Id") + private Integer appId; + @Column(name = "app_role_id") + private Integer appRoleId; +} + diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/fn/compositePK/FnQzTriggersId.java b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/compositePK/FnQzTriggersId.java new file mode 100644 index 00000000..174a63b3 --- /dev/null +++ b/portal-BE/src/main/java/org/onap/portal/domain/db/fn/compositePK/FnQzTriggersId.java @@ -0,0 +1,85 @@ +/* + * ============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.compositePK; + +import java.io.Serializable; +import java.util.Objects; +import javax.validation.constraints.Size; +import lombok.AllArgsConstructor; +import lombok.Getter; +import lombok.NoArgsConstructor; +import lombok.Setter; +import org.hibernate.validator.constraints.SafeHtml; + +@Getter +@Setter +@NoArgsConstructor +@AllArgsConstructor +public final class FnQzTriggersId implements Serializable { + @Size(max = 120) + @SafeHtml + private String schedName; + @Size(max = 200) + @SafeHtml + private String triggerName; + @Size(max = 200) + @SafeHtml + private String triggerGroup; + + @Override + public boolean equals(Object o) { + if (this == o) { + return true; + } + if (!(o instanceof FnQzTriggersId)) { + return false; + } + FnQzTriggersId that = (FnQzTriggersId) o; + return schedName.equals(that.schedName) && + triggerName.equals(that.triggerName) && + triggerGroup.equals(that.triggerGroup); + } + + @Override + public int hashCode() { + return Objects.hash(schedName, triggerName, triggerGroup); + } +} \ No newline at end of file -- 2.16.6