SysDataviewSql.java

/*
 * Copyright 2026 Global Crop Diversity Trust
 * Licensed under the Apache License, Version 2.0
 * See LICENSE file in project root folder or http://www.apache.org/licenses/LICENSE-2.0
 */

package org.gringlobal.model;

import javax.persistence.*;
import javax.validation.constraints.Pattern;

import org.genesys.blocks.model.Copyable;

import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

import com.fasterxml.jackson.annotation.JsonIdentityInfo;
import com.fasterxml.jackson.annotation.JsonProperty;
import com.fasterxml.jackson.annotation.ObjectIdGenerators;

/**
 * Auto-generated by:
 * org.apache.openjpa.jdbc.meta.ReverseMappingTool$AnnotatedCodeGenerator
 */
@Entity
@Cacheable
@Table(name = "sys_dataview_sql")
@JsonIdentityInfo(scope = SysDataviewSql.class, generator = ObjectIdGenerators.PropertyGenerator.class, property = "id")
@Getter
@Setter
@NoArgsConstructor
public class SysDataviewSql extends CooperatorOwnedModel implements Copyable<SysDataviewSql> {

	private static final long serialVersionUID = -4564139545436429373L;

	@Id
	@JsonProperty
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Column(name = "sys_dataview_sql_id", columnDefinition = "int")
	private Long id;

	@Basic
	@Column(name = "database_engine_tag", nullable = false, length = 10)
	@Pattern(regexp = "sqlserver|mysql|postgresql|oracle") private String databaseEngineTag;

	@Basic
	@Column(name = "sql_statement", nullable = false)
	@Lob
	private String sqlStatement;

	@ManyToOne(fetch = FetchType.LAZY, cascade = {})
	@JoinColumn(name = "sys_dataview_id", nullable = false)
	private SysDataview dataview;

	public SysDataviewSql(final Long id) {
		this.id = id;
	}

	@Override
	public boolean canEqual(Object other) {
		return other instanceof SysDataviewSql;
	}
}