package io.delphiplatform.api.v3.rdb.entity.apple.music;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Transient;

import io.delphiplatform.api.v3.constant.ChartmetricPartner;
import lombok.EqualsAndHashCode;
import lombok.Getter;
import lombok.Setter;

@Entity
@Table(name = "dim_apple_music_chart", schema = ChartmetricPartner.APPLE)
@Getter
@Setter
@EqualsAndHashCode(of = "appleMusicChartId")
public class AppleMusicChartEntity {

    @Id
    @Column(name = "apple_music_chart_id")
    private String appleMusicChartId;

    @Column(name = "apple_music_country_id")
    private String appleMusicCountryId;

    @Transient
    public String getName() {
        return String.format("Apple Top Daily %s", appleMusicCountryId.toUpperCase());
    }

    @Column(name = "total_positions")
    private Integer totalPositions;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "apple_music_country_id", insertable = false, updatable = false)
    private AppleMusicMarketRankEntity marketRank;
}