import { Entity, Column, PrimaryGeneratedColumn, OneToOne, JoinColumn, OneToMany, CreateDateColumn, UpdateDateColumn, DeleteDateColumn, ManyToMany, JoinTable, ManyToOne, Unique } from 'typeorm';
import { v4 as uuidv4 } from 'uuid';
import { Exclude, Expose } from 'class-transformer';

export enum Status {
  PENDING = 'pending',
  COMPLETED = 'completed',
  FAILED = 'failed'
}

@Entity({ name: 'file_managers' })
export class FileManagers {

  @PrimaryGeneratedColumn('uuid')
  id: string;

  @Column({ default: "" })
  file_name : string;

  @Column({ default: "" })
  extension : string;

  @Column({ default: "" })
  source_from : string;

  @Column({ type: 'text', nullable: true, default: "" })
  file_path : string;

  @Column({ default: 0 })
  total_row_count : number;

  @Column({ default: 0 })
  success_row_count : number;

  @Column({ default: 0 })
  failed_row_count : number;

  @Column({
    type: 'enum',
    enum: Status,
    default: Status.PENDING,
  })
  status : string;

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