#pyramid

Any pyramid_sacrud user?

How do you handle columns of the SQLAlchemy type DateTime?

Everytime I try to insert new data into the model I get: "KeyError: 'date_submit'"

i don't know of anyone who uses sacrud

:-(

Thank you

Thank you very much :-)

[pyramid_tutorials] stevepiercy pushed 2 new commits to master: http://git.io/vEHZG

pyramid_tutorials/master 310bf95 Steve Piercy: - index.rst fix table entries...

pyramid_tutorials/master b748f0a Steve Piercy: Merge pull request #124 from stevepiercy/master...

hi, I'm trying to use colanderalchemy + deform in my Pyramid app and all the models that have no relationships (no joke, they really are single!) work well. What doesn't work how I want are relationships: if a user is in a group, when editing the user I'd like to have all groups in a select box, instead of them all laid as "forms in a form"

I thought that I can simply do "info={'colanderalchemy': {'title': _('Groups'), 'widget': SelectWidget(values=Groups)}}" but Groups doesn't exist yet, and even if it existed, it also has a relationship on User

all examples I that found are for really trivial schemas, like Page(title, body)

s/I that/that I/

am I even on the right path, or relationships are not something that colanderalchemy can handle?

sbivol: yo

moo-_-: yoyo

sbivol: I created a checkbox widget allowing me to tag groups where the user is

let me dig the code for you

sbivol: https://gist.github.com/miohtama/d7147c8b70cfb6...

moo-_-: you made a custom widget that can handle objects retrieved from a relationship. does that imply that colanderalchemy can't natively understand relationships?

or is it deform that can't handle them?

sbivol: you need to take this question to a colanderalchemy author, not me

sbivol: you have to remember how dumb HTML forms are.

how does colander help overcome that dumbness?

Colander is fine because it's very flexible.

But you may have to manage the mapping from the DB to the colander schema yourself. Depends a lot on the schema.

And this is when you may need a custom widget.

I think I misunderstood what the purpose of Colander is...

sbivol: the colanderalchemy needs some more features and widgets to get to the point of just works

sbivol: meanwhile we'll need to hack it ourselves

Colander provides a high-level API for typed form fields. Conversion to and from URL-encoding and validation.

Deform is a form library that provides widgets for these fields and some additional features.

I think uralbash has made some SQLAlchemy love widgets

typed-form <- is it typed as in „the form knows that this <select> is filled with Group objects, and upon deserialization I'll end up with the selected Group object”, or as in „the string here represents an int, the one over there is a boolean”?

sbivol: best reading the docs.

Typing as in int, string, mapping, etc.

despite reading the docs, I still hoped that I read them wrong and it actually (de)serializes Python objects

sbivol: colander?