根据其他表的id添加新行

Question

我有两个表，命名为projects和actions，每个项目都包含几个action

class Projet(db.Model):
    __tablename__ = 'projets'
    id = db.Column(db.Integer, primary_key=True)
    nom_projet = db.Column(db.String(100))    
    description_projet = db.Column(db.String(800))                         
    date_affectation = db.Column(db.DateTime, nullable = False)                              
    statut_projet = db.Column(db.String(100))

    admin_id = db.Column(db.Integer, db.ForeignKey('admins.id'))

    actions = db.relationship('Action', backref='projet',
                                lazy='dynamic')

    def __repr__(self):
        return '<Projet: {}>'.format(self.id)

class Action(db.Model):
    __tablename__ = 'actions'  
    id = db.Column(db.Integer, primary_key=True)
    projet_id = db.Column(db.Integer, db.ForeignKey('projets.id'))   
    description =  db.Column(db.String(1000))                        
    statut_action = db.Column(db.String(100))                               
    date_action =  db.Column(db.DateTime, nullable = False) 
    date_execution = db.Column(db.DateTime, nullable = True) 
    def __repr__(self):
        return '<Action: {}>'.format(self.id)

我的问题是，我需要在现有项目的基础上创建一个新操作，如图所示， 我需要点击添加按钮，他必须重定向到与项目名称自动选择我的行动形式，我输入的行动细节。你知道吗

这是我第一个添加操作的代码：

@auth.route('/action/add', methods=['GET', 'POST'])
@login_required
def add_action():
    form = ActionForm()
    if form.validate_on_submit():
        action = Action(
            projet = form.projet.data,
            description = form.description.data,
            statut_action = form.statut_action.data,
            date_action = form.date_action.data,
            date_execution = form.date_execution.data
        )
        try:
            db.session.add(action)
            db.session.commit()
            flash('You have successfully added a new action.')
        except:
            flash('Error: action name already exists.')
        return redirect(url_for('auth.list_projets'))
    return render_template('admin/actions/action.html', action="Add", form=form,
                           title="ADD ACTION")

Answer 1

步骤：

1. 更新URL以包含项目id作为路径参数：ex:/project/1/actions/add意味着为id为1的项目加载带有新操作表单的页面
2. 按照步骤1更新链接以在上一页中添加新操作（如屏幕截图所示）
3. 从ActionForm中删除project字段，因为它是使用path param处理的
4. 更新“newactionform”页面以显示产品名称进入product_name变量

试试看

@auth.route('/project/<project_id>/action/add', methods=['GET', 'POST'])
@login_required
def add_action(project_id):
    form = ActionForm()
    project = Project.query.get(project_id)
    if not project:
        flash('Error: invalid project')
        abort(404)
    if form.validate_on_submit():
        action = Action(
            project = project,
            description = form.description.data,
            statut_action = form.statut_action.data,
            date_action = form.date_action.data,
            date_execution = form.date_execution.data
        )
        try:
            db.session.add(action)
            db.session.commit()
            flash('You have successfully added a new action.')
        except:
            flash('Error: action name already exists.')
        return redirect(url_for('auth.list_projets'))
    return render_template('admin/actions/action.html', action="Add", form=form,
                           title="ADD ACTION", project_name=project.name)