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-27 17:01:13Z

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, 2012 at 17:01

answered Mar 16, 2012 at 12:08

gawel

2,04814 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

boadescriptor Over a year ago

This fs = FieldSet(DataTBL, request=requestobject) instead of fs = FieldSet(DataTBL) made it work.

gawel Over a year ago

oh, yes. .bind() return a new instance so it should be fs = fs.bind(DataTBL, request=requestobject)

Collectives™ on Stack Overflow

Adding SQLAlchemy records with Formalchemy

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related