How do I query an array and delete multiple in TypeORM

Question

I want to remove multiple options if its question_id is 1 or 2.

The following code gives me this error: QueryFailedError: missing FROM-clause entry for table "option"

How do I solve this problem?

Service.ts:

this.QuizQuestionOptionRepository.createQueryBuilder('option')
  .delete()
  .from(QuizQuestionOption)
  .where('option.question_id IN (:...id)', { id: [1, 2] })
  .execute();

QuizQuestionOption entity:

import { QuizQuestion } from './quizQuestion.entity';
import {
  BeforeUpdate,
  Column,
  Entity,
  JoinColumn,
  ManyToOne,
  PrimaryGeneratedColumn,
} from 'typeorm';

@Entity()
export class QuizQuestionOption {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  title: string;

  @Column({ nullable: true })
  explanation: string;

  @Column()
  is_correct: boolean;

  @JoinColumn({ name: 'question_id' })
  @ManyToOne(() => QuizQuestion)
  question: QuizQuestion;

  @Column({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
  created_at: Date;

  @Column({ type: 'timestamp', default: () => 'CURRENT_TIMESTAMP' })
  updated_at: Date;

  @BeforeUpdate()
  updateTimestamp() {
    this.updated_at = new Date();
  }
}

Chukwuemeka Ihedoro · Accepted Answer · 2022-05-09 08:38:58Z

1

I dont think you need to add a name in createQueryBuilder. Maybe you should try it this way

await this.QuizQuestionOptionRepository.createQueryBuilder()
  .delete()
  .from(QuizQuestionOption)
  .where('question_id IN (:...id)', { id: [1, 2] })
  .execute();

answered May 9, 2022 at 8:38

Chukwuemeka Ihedoro

6051 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hasibul Hasan Over a year ago

Thanks. The problem was with the name & from. I removed both & it worked fine

Chukwuemeka Ihedoro Over a year ago

nice @HasibulHasan

Collectives™ on Stack Overflow

How do I query an array and delete multiple in TypeORM

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related