package io.delphiplatform.api.v3.rdb.entity.video;

import org.hibernate.annotations.Formula;

import java.time.LocalDate;

import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import io.delphiplatform.api.v3.rdb.entity.ChartEntity;
import io.delphiplatform.api.v3.rdb.entity.RegionEntity;
import lombok.Getter;
import lombok.Setter;

@Getter
@Setter
@Entity
@Table(name = "fact_youtube_video_trending_chart", schema = "chartmetric")
public class FactYoutubeVideoTrendingChartEntity {

    @EmbeddedId
    private FactYoutubeVideoTrendingChartId id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "video_id", insertable = false, updatable = false)
    private ChartmetricVideoEntity video;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "chart_id", insertable = false, updatable = false)
    private ChartEntity chart;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "country_code", insertable = false, updatable = false)
    private RegionEntity region;

    @Column(name = "current_position", nullable = false)
    private Integer currentPosition;
    @Column(name = "date", nullable = false, insertable = false, updatable = false)
    private LocalDate date;
    @Column(name = "date_gap")
    private Integer dateGap;
    @Column(name = "is_entry", nullable = false)
    private Boolean isEntry;
    @Column(name = "is_reentry", nullable = false)
    private Boolean isReentry;
    @Column(name = "is_exit", nullable = false)
    private Boolean isExit;
    @Column(name = "position_delta", nullable = false)
    private Integer positionDelta;
    @Column(name = "previous_date")
    private LocalDate previousDate;
    @Column(name = "previous_position")
    private Integer previousPosition;
    @Column(name = "total_positions", nullable = false)
    private Long totalPositions;
    @Formula("(previous_position - current_position)")
    private Integer trend;

}