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

import java.time.LocalDate;

import javax.persistence.Column;
import javax.persistence.Convert;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToOne;
import javax.persistence.Table;

import io.delphiplatform.api.v3.model.video.VideoDspSlug;
import io.delphiplatform.api.v3.rdb.entity.converter.VideoDspSlugAttributeConverter;
import lombok.Getter;
import lombok.Setter;

@Entity(name = "chartmetric_video")
@Table(schema = "chartmetric", name = "dim_youtube_video")
@Getter
@Setter
public class ChartmetricVideoEntity {

    @Id
    private String videoId;
    @OneToOne
    @JoinColumn(name = "video_id", insertable = false, updatable = false)
    private VideoEntity sonyVideo;
    private String dspVideoId;
    @Convert(converter = VideoDspSlugAttributeConverter.class)
    private VideoDspSlug dsp;
    private String title;
    private String isrc;
    private LocalDate dateUploaded;
    private Long views;
    @Column(name = "is_sony", nullable = false)
    private Boolean isSony;

}