tortoise
pgsql delete left join error
await Objectives.filter(student__user_id=request.user.id).filter(reward_id__isnull=True).delete()
the query is:
DELETE FROM "objectives" LEFT OUTER JOIN "student" "objectives__student" ON "objectives__student"."id"="objectives"."student_id" WHERE "objectives__student"."user_id"=1 AND "objectives"."reward_id" IS NULL
It doesn't work
I copy the sql into navicat,return this:
LINE 1: EXPLAIN DELETE FROM "objectives" a LEFT OUTER JOIN "student"... The syntax error is "LEFT" or nearby
`class Objectives(BaseModelMixin): table = "objectives" student=fields.ForeignKeyField('models.Student',null=True,on_delete=fields.SET_NULL)
class Student(BaseModelMixin): table = "user_student" user=fields.OneToOneField('models.User',null=True,on_delete=fields.SET_NULL)
`
It was ok to try this code: await Objectives.filter(student_id=request.user.id,reward_id__isnull=True).delete() So how to make query a foreign key from a foreign key?
`
max_times=await Objectives.filter(student__user=request.user).count()----OK obj_exist=await Objectives.filter(student__user=request.user).delete()----ERROR `