package com.sonymusic.dx.persistence.gras;

import jakarta.persistence.*;

import java.io.Serializable;
import java.sql.Timestamp;

@Entity
@Table(name = "vgras371")
@IdClass(SongCountryPk.class)
public class SongCountry extends RAASClientSpecificEntity implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @Column(name = "song_no", nullable = false, insertable = false, updatable = false)
    private Long songNumber;

    @Id
    @Column(name = "country_key", nullable = false, insertable = false, updatable = false)
    private String countryKey;

    @Column(name = "loc_track_name", length = 250)
    private String locTrackName;

    @Column(name = "loc_track_match", length = 250)
    private String locTrackMatch;

    @Column(name = "log_mod_stamp", nullable = false)
    private Timestamp logModStamp;

    @Column(name = "log_mod_user", nullable = false, length = 8)
    private String logModUser;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "country_key", referencedColumnName = "country_key", insertable = false, updatable = false)
    private Country country;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "song_no", insertable = false, updatable = false)
    private Song song;

    public Long getSongNumber() {
        return songNumber;
    }

    public void setSongNumber(Long songNumber) {
        this.songNumber = songNumber;
    }

    public String getCountryKey() {
        return countryKey;
    }

    public void setCountryKey(String countryKey) {
        this.countryKey = countryKey;
    }

    public String getLocTrackName() {
        return locTrackName;
    }

    public void setLocTrackName(String locTrackName) {
        this.locTrackName = locTrackName;
    }

    public String getLocTrackMatch() {
        return locTrackMatch;
    }

    public void setLocTrackMatch(String locTrackMatch) {
        this.locTrackMatch = locTrackMatch;
    }

    public Timestamp getLogModStamp() {
        return logModStamp;
    }

    public void setLogModStamp(Timestamp logModStamp) {
        this.logModStamp = logModStamp;
    }

    public String getLogModUser() {
        return logModUser;
    }

    public void setLogModUser(String logModUser) {
        this.logModUser = logModUser;
    }

    public Country getCountry() {
        return country;
    }

    public void setCountry(Country country) {
        this.country = country;
    }

    public Song getSong() {
        return song;
    }

    public void setSong(Song song) {
        this.song = song;
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((getSongNumber() == null) ? 0 : getSongNumber().hashCode());
        result = prime * result + ((getCountryKey() == null) ? 0 : getCountryKey().hashCode());
        return result;
    }

    @Override
    public boolean equals(Object obj) {
        if (this == obj)
            return true;
        if (obj == null)
            return false;
        if (!(obj instanceof SongCountry))
            return false;
        SongCountry other = (SongCountry) obj;
        if (getCountryKey() == null) {
            if (other.getCountryKey() != null)
                return false;
        } else if (!getCountryKey().equals(other.getCountryKey()))
            return false;
        if (getSongNumber() == null) {
            if (other.getSongNumber() != null)
                return false;
        } else if (!getSongNumber().equals(other.getSongNumber()))
            return false;
        return true;
    }

}