import {
  Entity,
  Column,
  PrimaryGeneratedColumn,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
  ManyToOne,
  JoinColumn,
  Index,
} from 'typeorm';
import { v4 as uuidv4 } from 'uuid';
import { Exclude } from 'class-transformer';
import { Users } from './users.entity';
import { SocialMedias } from './social-medias.entity';


@Entity({ name: 'instagram_insights' })
export class InstagramInsights {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @ManyToOne(() => Users, (user) => user.id, { nullable: true })
  @JoinColumn({ name: 'user_id' })
  users: Users;

  @Index('IDX_instagram_insights_social_media_id')
  @ManyToOne(() => SocialMedias, { nullable: true })
  @JoinColumn({ name: 'social_media_id' })
  socialMedia: SocialMedias;

  @Index()
  @Column({ type: 'varchar', nullable: true })
  metric: string;

  @Index()
  @Column({ type: 'varchar', nullable: true })
  period: string;

  @Index()
  @Column({ type: 'varchar', nullable: true })
  timeframe: string;

  @Index()
  @Column({ type: 'varchar', nullable: true })
  breakdown: string;

  @Index()
  @Column({ type: 'varchar', nullable: true })
  query_params: string;

  @Column({ type: 'jsonb', nullable: true })
  response_json: Record<string, any>;

  @Exclude()
  @CreateDateColumn({
    type: 'timestamp',
    precision: 0,
    default: () => 'CURRENT_TIMESTAMP',
  })
  created_at: Date;

  @Exclude()
  @UpdateDateColumn({
    type: 'timestamp',
    precision: 0,
    default: () => 'CURRENT_TIMESTAMP',
    onUpdate: 'CURRENT_TIMESTAMP',
  })
  updated_at: Date;

  @Exclude()
  @DeleteDateColumn({ type: 'timestamp', nullable: true, precision: 0 })
  deleted_at: Date;

  setDefaults() {
    this.id = this.id || uuidv4();
  }
}