使用flask-wtf和sqlalchemy生成一个动态表单 [英] Generate a dynamic form using flask-wtf and sqlalchemy
问题描述
我有一个模型Formfield是这样的:
我有一个web应用程序,允许用户创建自己的字段,以便在以后的形式呈现。 >
class Formfield(db.Model):
id = db.Column(db.Integer,primary_key = True)$ b $ (db.teger,db.ForeignKey('formbooking.id'))
label = db.Column(db.String(80))
placeholder_text = db.Column(db .String(80))
help_text = db.Column(db.String(500))
box_checked = db.Column(db.Boolean,nullable = True,default = False)
options = db.Column(db.String)#JSON在这里?
answer = db.Column(db.String)
required = db.Column(db.Boolean,nullable = False,default = False)
order = db.Column(db.Integer)
fieldtype = db.Column(db.Integer)
我用来表示一个字段,不管怎么样(复选框,输入,将来会更多)。
正如你所看到的,每个字段都有一个FK到form_id。
我试图为给定的form_id生成一个动态表单。
问题是,我需要确定每个Formfield的字段类型。
所以我也需要在某些时候处理字段类型。
我想解决方法是以某种方式将form_id传递给Form类中的函数。
我不知道该怎么做,或者在哪里寻找解决方案。
任何帮助都将非常感谢!
设法从这里 https://groups.google.com / forum /#!topic / wtforms / cJl3aqzZieA
你必须在view函数中创建一个动态表单,获取你想要的表单域,迭代每个字段来构造这个表单对象。我用字段类型简单的文本,而不是整数值。由于在代码级别上阅读起来似乎很容易。
$ p $ $ $ $ $ $ $ $ $
class DynamicForm(wtforms.Form):pass
dform = main.models.Form.objects.get(name =name2)
name = dform.name
for dform.fields:
print f.label
setattr(DynamicForm,f.label,self.getField(f))
$ b $ = DynamicForm()#Dont忘记实例化你的新表单,然后再渲染
作为d:
中的字段print field#你可以看到html输出的字段
return render_template(customform.html,form = d)
$ b $ def getField(self,field):
如果field.fieldtype ==text:
返回TextField(field.label)
if field。字段类型==密码:
返回PasswordField(field.label)
#可以扩展if子句在每个新字段类型
为一个简单的表单渲染jinja模板'forms.html'
{%macro render(form) - %}
< fieldset>
{%field for form%}
{%if field.type in ['CSRFTokenField','HiddenField']%}
{{field()}}
{ %else%}
< div class =form-group {%if field.errors%} error {%endif%}>
{{field.label}}
< div class =input>
{%if field.name ==body%}
{{field(rows = 10,cols = 40)}}
{%else%}
{字段()}}
{%endif%}
{%if field.errors or field.help_text%}
< span class =help-inline>
{%if field.errors%}
{{field.errors | join('')}}
{%else%}
{{field.help_text}}
{%endif%}
< / span>
{%endif%}
< / div>
< / div>
{%endif%}
{%endfor%}
< / fieldset>
{%endmacro%}
和customform.html是这样的
{%extendsbase.html%}
{%importforms.htmlas forms%}
{%block content%}
{{forms.render(form)}}
{%endblock%}
I have a webapp that allows users to create their own fields to be rendered in a form later on.
I have a model Formfield like so:
class Formfield(db.Model):
id = db.Column(db.Integer, primary_key = True)
form_id = db.Column(db.Integer, db.ForeignKey('formbooking.id'))
label = db.Column(db.String(80))
placeholder_text = db.Column(db.String(80))
help_text = db.Column(db.String(500))
box_checked = db.Column(db.Boolean, nullable = True, default = False)
options = db.Column(db.String) # JSON goes here?
answer = db.Column(db.String)
required = db.Column(db.Boolean, nullable = False, default = False)
order = db.Column(db.Integer)
fieldtype = db.Column(db.Integer)
that I use to represent a field, whatever the kind (checkbox, input, more in the future).
As you can see, every field has a FK to a form_id.
I’m trying to generate a dynamic form for a given form_id. The catch is that I need to determine the type of field to render for every Formfield. So I also need to process the fieldtype at some point.
I guess a solution would be to somehow pass the form_id to a function in my Form class.
I have no clue how to do it or where to look for a solution.
Any help would be very appreciated!
I think I managed to create dynamic forms with the idea from here https://groups.google.com/forum/#!topic/wtforms/cJl3aqzZieA
you have to create a dynamic form at view function, fetch the form field you want to get, and iterate every field to construct this form object. I used for fieldtypes simple text instead of integer values. Since it seems easy to read at code level.
class FormView(MethodView):
def get(self):
class DynamicForm(wtforms.Form): pass
dform = main.models.Form.objects.get(name="name2")
name = dform.name
for f in dform.fields:
print f.label
setattr(DynamicForm , f.label, self.getField(f))
d = DynamicForm() # Dont forget to instantiate your new form before rendering
for field in d:
print field # you can see html output of fields
return render_template("customform.html", form=d)
def getField(self, field):
if field.fieldtype == "text":
return TextField(field.label)
if field.fieldtype == "password":
return PasswordField(field.label)
# can extend if clauses at every new fieldtype
for a simple form render jinja template 'forms.html'
{% macro render(form) -%}
<fieldset>
{% for field in form %}
{% if field.type in ['CSRFTokenField', 'HiddenField'] %}
{{ field() }}
{% else %}
<div class="form-group {% if field.errors %}error{% endif %}">
{{ field.label }}
<div class="input">
{% if field.name == "body" %}
{{ field(rows=10, cols=40) }}
{% else %}
{{ field() }}
{% endif %}
{% if field.errors or field.help_text %}
<span class="help-inline">
{% if field.errors %}
{{ field.errors|join(' ') }}
{% else %}
{{ field.help_text }}
{% endif %}
</span>
{% endif %}
</div>
</div>
{% endif %}
{% endfor %}
</fieldset>
{% endmacro %}
and customform.html is like this
{% extends "base.html" %}
{% import "forms.html" as forms %}
{% block content %}
{{ forms.render(form) }}
{% endblock %}
这篇关于使用flask-wtf和sqlalchemy生成一个动态表单的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!