content: /*
   * Licensed to the Apache Software Foundation (ASF) under one
   * or more contributor license agreements.  See the NOTICE file
   * distributed with this work for additional information
   * regarding copyright ownership.  The ASF licenses this file
   * to you 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.
   *
   */
  
  package org.apache.causeway.extensions.audittrail.jpa.dom;
  
  import java.util.UUID;
  
  import jakarta.inject.Named;
  import jakarta.persistence.Column;
  import jakarta.persistence.Convert;
  import jakarta.persistence.Entity;
  import jakarta.persistence.EntityListeners;
  import jakarta.persistence.GeneratedValue;
  import jakarta.persistence.Id;
  import jakarta.persistence.Index;
  import jakarta.persistence.NamedQueries;
  import jakarta.persistence.NamedQuery;
  import jakarta.persistence.Table;
  import jakarta.persistence.Version;
  import jakarta.xml.bind.annotation.adapters.XmlJavaTypeAdapter;
  
  import org.apache.causeway.applib.annotation.DomainObject;
  import org.apache.causeway.applib.annotation.Editing;
  import org.apache.causeway.applib.annotation.Programmatic;
  import org.apache.causeway.applib.annotation.Publishing;
  import org.apache.causeway.applib.jaxb.PersistentEntityAdapter;
  import org.apache.causeway.applib.services.bookmark.Bookmark;
  import org.apache.causeway.extensions.audittrail.applib.dom.AuditTrailEntry.Nq;
  import org.apache.causeway.persistence.jpa.applib.integration.CausewayEntityListener;
  import org.apache.causeway.persistence.jpa.integration.typeconverters.applib.CausewayBookmarkConverter;
  import org.apache.causeway.persistence.jpa.integration.typeconverters.java.util.JavaUtilUuidConverter;
  @Entity
  @Table(
          schema = AuditTrailEntry.SCHEMA,
          name = AuditTrailEntry.TABLE,
          indexes = {
                  @Index(name = "AuditTrailEntry__target_propertyId_timestamp__IDX", columnList = "target, propertyId, timestamp", unique = false),
                  @Index(name = "AuditTrailEntry__target_timestamp__IDX", columnList = "target, timestamp", unique = false),
                  @Index(name = "AuditTrailEntry__timestamp__IDX", columnList = "timestamp", unique = false),
                  @Index(name = "AuditTrailEntry__interactionId__IDX", columnList = "interactionId", unique = false)
          }
  )
  @NamedQueries( {
      @NamedQuery(
              name = Nq.FIND_BY_INTERACTION_ID,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.interactionId = :interactionId"),
      @NamedQuery(
              name = Nq.FIND_FIRST_BY_TARGET,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + " ORDER BY e.timestamp ASC "),  // programmatic range 0,2
      @NamedQuery(
              name = Nq.FIND_RECENT_BY_TARGET,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + " ORDER BY e.timestamp DESC "),   // programmatic range 0,100
      @NamedQuery(
              name = Nq.FIND_BY_TARGET_AND_TIMESTAMP_BETWEEN,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + "   AND e.timestamp >= :from "
                    + "   AND e.timestamp <= :to "
                    + "ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_TARGET_AND_TIMESTAMP_AFTER,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + "   AND e.timestamp >= :from "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND_BY_TARGET_AND_TIMESTAMP_BEFORE,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + "   AND e.timestamp <= :to "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND_BY_TARGET,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND_BY_TIMESTAMP_BETWEEN,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.timestamp >= :from "
                    + "   AND e.timestamp <= :to "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND_BY_TIMESTAMP_AFTER,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.timestamp >= :from "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND_BY_TIMESTAMP_BEFORE,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.timestamp <= :to "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name  = Nq.FIND,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_MOST_RECENT,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " ORDER BY e.timestamp DESC, e.interactionId DESC, e.sequence DESC"),  // programmatic limit 100
      @NamedQuery(
              name = Nq.FIND_RECENT_BY_TARGET_AND_PROPERTY_ID,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.target = :target "
                    + "   AND e.propertyId = :propertyId "
                    + " ORDER BY e.timestamp DESC "), // programmatic limit 0,30
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TIMESTAMP_BETWEEN,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.timestamp >= :from "
                      + "   AND e.timestamp <= :to "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TIMESTAMP_AFTER,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.timestamp >= :from "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TIMESTAMP_BEFORE,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.timestamp <= :to "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TARGET_AND_TIMESTAMP_BETWEEN,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.target = :target "
                      + "   AND e.timestamp >= :from "
                      + "   AND e.timestamp <= :to "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TARGET_AND_TIMESTAMP_AFTER,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.target = :target "
                      + "   AND e.timestamp >= :from "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TARGET_AND_TIMESTAMP_BEFORE,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.target = :target "
                      + "   AND e.timestamp <= :to "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_BY_USERNAME_AND_TARGET,
              query = "SELECT e "
                      + "  FROM AuditTrailEntry e "
                      + " WHERE e.username = :username "
                      + "   AND e.target = :target "
                      + " ORDER BY e.timestamp DESC"),
      @NamedQuery(
              name = Nq.FIND_RECENT_BY_USERNAME,
              query = "SELECT e "
                    + "  FROM AuditTrailEntry e "
                    + " WHERE e.username = :username "
                    + " ORDER BY e.timestamp DESC ") // programmatic limit 0,100
  })
  @EntityListeners(CausewayEntityListener.class)
  @XmlJavaTypeAdapter(PersistentEntityAdapter.class)
  @Named(AuditTrailEntry.LOGICAL_TYPE_NAME)
  @DomainObject(
          editing = Editing.DISABLED,
          entityChangePublishing = Publishing.DISABLED
  )
  public class AuditTrailEntry
  extends org.apache.causeway.extensions.audittrail.applib.dom.AuditTrailEntry {
  
      private Long id;
  
      @Id
      @Programmatic
      @GeneratedValue
      public Long getId() {
          return id;
      }
  
      public void setId(Long id) {
          this.id = id;
      }
  
      private Long version;
  
      @Version
      public Long getVersion() {
          return version;
      }
  
      public void setVersion(Long version) {
          this.version = version;
      }
  
      private String username;
  
      @Column(nullable = Username.NULLABLE, length = Username.MAX_LENGTH)
      @Username
      public String getUsername() {
          return username;
      }
  
      public void setUsername(String username) {
          this.username = username;
      }
  
      private java.sql.Timestamp timestamp;
  
      @Column(nullable = Timestamp.NULLABLE)
      @Timestamp
      public java.sql.Timestamp getTimestamp() {
          return timestamp;
      }
  
      public void setTimestamp(java.sql.Timestamp timestamp) {
          this.timestamp = timestamp;
      }
  
      private UUID interactionId;
  
      @Convert(converter = JavaUtilUuidConverter.class)
      @Column(nullable = InteractionId.NULLABLE, length = InteractionId.MAX_LENGTH)
      @InteractionId
      public UUID getInteractionId() {
          return interactionId;
      }
  
      public void setInteractionId(UUID interactionId) {
          this.interactionId = interactionId;
      }
  
      private int sequence;
  
      @Column(nullable = Sequence.NULLABLE)
      @Sequence
      public int getSequence() {
          return sequence;
      }
  
      public void setSequence(int sequence) {
          this.sequence = sequence;
      }
  
      private Bookmark target;
  
      @Convert(converter = CausewayBookmarkConverter.class)
      @Column(nullable = Target.NULLABLE, length = Target.MAX_LENGTH)
      @Target
      public Bookmark getTarget() {
          return target;
      }
  
      public void setTarget(Bookmark target) {
          this.target = target;
      }
  
      private String logicalMemberIdentifier;
  
      @Column(nullable = LogicalMemberIdentifier.NULLABLE, length = LogicalMemberIdentifier.MAX_LENGTH)
      @LogicalMemberIdentifier
      public String getLogicalMemberIdentifier() {
          return logicalMemberIdentifier;
      }
  
      public void setLogicalMemberIdentifier(String logicalMemberIdentifier) {
          this.logicalMemberIdentifier = logicalMemberIdentifier;
      }
  
      private String propertyId;
  
      @Column(nullable = PropertyId.NULLABLE, length = PropertyId.MAX_LENGTH)
      @PropertyId
      public String getPropertyId() {
          return propertyId;
      }
  
      public void setPropertyId(String propertyId) {
          this.propertyId = propertyId;
      }
  
      private String preValue;
  
      @Column(nullable = PreValue.NULLABLE, length = PreValue.MAX_LENGTH)
      @PreValue
      public String getPreValue() {
          return preValue;
      }
  
      public void setPreValue(String preValue) {
          this.preValue = preValue;
      }
  
      private String postValue;
  
      @Column(nullable = PostValue.NULLABLE, length = PostValue.MAX_LENGTH)
      @PostValue
      public String getPostValue() {
          return postValue;
      }
  
      public void setPostValue(String postValue) {
          this.postValue = postValue;
      }
  }
  