import {
  Entity,
  PrimaryGeneratedColumn,
  ManyToOne,
  JoinColumn,
  Column,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
  Unique,
} from 'typeorm';
import { v4 as uuidv4 } from 'uuid';
import { Exclude } from 'class-transformer';
import { Countries } from './countries.entity';
import { CampaignCategory } from './campaign-caregories.entity';

@Entity({ name: 'campaign_category_country_order' })
@Unique(['country', 'campaignCategory'])
export class CampaignCategoryCountryOrder {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @ManyToOne(() => Countries, { nullable: false, onDelete: 'CASCADE' })
  @JoinColumn({ name: 'country_id' })
  country: Countries;

  @ManyToOne(
    () => CampaignCategory,
    (campaignCategory) => campaignCategory.countryOrders,
    { nullable: false, onDelete: 'CASCADE' },
  )
  @JoinColumn({ name: 'campaign_category_id' })
  campaignCategory: CampaignCategory;

  @Column({ type: 'int', default: 1 })
  order_by: number;

  @Column({ type: 'boolean', default: false })
  is_hidden: boolean;

  @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();
  }
}
