import {
  Entity,
  PrimaryGeneratedColumn,
  Column,
  ManyToOne,
  JoinColumn,
  OneToMany,
  CreateDateColumn,
  UpdateDateColumn,
  DeleteDateColumn,
} from "typeorm"
import { InspectionQuestion } from "./inspection-questions.entity"
import { Exclude } from "class-transformer"
import { InspectionFleetAnswer } from "./inspection-report-answers.entity"

@Entity("inspection_answer_options")
export class InspectionAnswerOption {
  @PrimaryGeneratedColumn()
  id: number

  @Column({ type: "varchar" })
  option_text: string

  @Column({ type: "int" })
  question_id: number

  @ManyToOne(() => InspectionQuestion, (question) => question.answer_options, {
    onDelete: "CASCADE",
  })
  @JoinColumn({ name: "question_id" })
  @Exclude()
  question: InspectionQuestion

  @OneToMany(() => InspectionFleetAnswer, (answer) => answer.selected_answer)
  selected_in_answers: InspectionFleetAnswer[]

  @CreateDateColumn({ type: "timestamp", default: () => "NOW()" })
  created_at: Date

  @UpdateDateColumn({ type: "timestamp", default: () => "NOW()" })
  updated_at: Date

  @DeleteDateColumn()
  deleted_at: Date
}