Delete an item from Database using Typeorm in NestJs

Question

I have the Users entity:
id|name |age|images
1 | John | 4 | {123.jpg,258.png}
I want to delete an image from images column. According to typeorm documentation i can use:

import {getConnection} from "typeorm";

await getConnection()
    .createQueryBuilder()
    .delete()
    .from(Users)
    .where("id = :id", { id: 1 })
    .execute();

If use this i will delete the whole entity, but i need just to delete 123.jpg from images column.

Question: How to delete 123.jpg image from images column?
Note: I use NestJs and ProgresQl

Users entity:

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

    @Column("text",{nullable: true, array: true})
    images: string[];
}

Are images just a colmun in User entity? please share The user entity — Ayoub Touba
– Ayoub Touba, Commented Jan 29, 2021 at 14:57
@Youba, i updated. Indeed the images is just a column. Is there a solution? — Asking
– Asking, Commented Jan 29, 2021 at 15:00
you should just update the colmun, you don't need anything to do with delete in your case — Ayoub Touba
– Ayoub Touba, Commented Jan 29, 2021 at 15:15

hp10 · Accepted Answer · 2021-02-01 14:39:25Z

0

await getConnection()
    .createQueryBuilder()
    .update()
    .set({ images: [...valuesWithoutThatImage] })
    .where("id = :id", { id: 1 })
    .execute();

You need to update that object and set images to new desired value, in this case it should have all previous images without 123.jpg

answered Feb 1, 2021 at 14:39

hp10

6326 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Delete an item from Database using Typeorm in NestJs

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related