我有 3 個模型,我需要它們的一些列:class candidates(db.Model): id = db.Column(db.Integer, primary_key = True, autoincrement=True, nullable=False) name = db.Column(db.String(50), nullable= False) surname = db.Column(db.String(50), nullable= False) father_name = db.Column(db.String(50), nullable= False) class students(db.Model): id = db.Column(db.Integer, primary_key = True, autoincrement=True, nullable=False) candidate_id = db.Column(db.Integer, db.ForeignKey('candidates.id'), nullable= False) # Foreign key to Candidates type = db.Column(db.Integer, nullable= False) family_status = db.Column(db.Boolean(), nullable= False) education_status = db.Column(db.Boolean(), nullable= False)class graduate_students(db.Model): id = db.Column(db.Integer, primary_key = True, autoincrement=True, nullable=False) student_id = db.Column(db.Integer, db.ForeignKey('students.id'), nullable= False) work_place = db.Column(db.String(255), nullable= False) salary = db.Column(db.Integer, nullable= False)result = graduate_students.query.with_entities( graduate_students.id, students.id, candidates.id, candidates.name, candidates.surname).join(students).join(candidates).all()print(result)但解釋器給了我這個錯誤:“無法確定要加入哪個 FROM 子句” sqlalchemy.exc.InvalidRequestError:無法確定要從哪個 FROM 子句加入,有多個 FROM 可以加入到該實體。請使用 .select_from() 方法建立顯式左側,并提供顯式 ON 子句(如果尚不存在)以幫助解決歧義。
1 回答

汪汪一只貓
TA貢獻1898條經驗 獲得超8個贊
if request.method == "POST":
form = QuestionForm(request.POST or None)
if form.is_valid():
new_question = form.save()
student = Student.objects.get(user = request.user)
new_question.student = student
new_question.save()
if((len(request.FILES) =
添加回答
舉報
0/150
提交
取消