Adding SQLAlchemy records with Formalchemy

Question

I am trying to use Formalchemy to add a new record to my SQLAlchemy table DataTBL.

fs = FieldSet(DataTBL)
fs.bind(DataTBL, request=requestobject)

if fs.validate():
    fs.sync()
    session.commit()

This gives me a validation error because the DataTable object is still empty...

ValidationError: Cannot validate without binding data

How do I use Formalchemy to start with an empty form that has the DataTBL structure, fill the form and validate/submit it?

gawel · Accepted Answer · 2012-03-27T17:01:13.050

3

You need a request.POST to use .validate()

Try:

fs = FieldSet(DataTBL)
fs = fs.bind(DataTBL, request=requestobject)

if requestobject.POST and fs.validate():
    fs.sync()
    session.add(fs.model)
    session.commit()

edited Mar 27 '12 at 17:01

answered Mar 16 '12 at 12:08

gawel

2,038
14
16

This `fs = FieldSet(DataTBL, request=requestobject)` instead of `fs = FieldSet(DataTBL)` made it work. – boadescriptor Mar 17 '12 at 11:49
1

oh, yes. .bind() return a new instance so it should be `fs = fs.bind(DataTBL, request=requestobject)` – gawel Mar 17 '12 at 16:33

Adding SQLAlchemy records with Formalchemy

1 Answers1