Kyle Schaffrick wrote: > Greetings, > > I'm looking into using PostgreSQL's hstore type in a SQLAlchemy > project, and before I possibly reinvent the wheel I was wondering if > anyone has/knows of an implementation of an hstore custom type for SQLA? > > I'm basically just interested in simply mapping a stand-alone attribute > containing a python dict onto an hstore column, I don't require > auto-magic storage of extra attributes directly added to the object > a la examples/vertical. > > Mainly I want the hstore segregated into it's own attribute because I'd > like to be able to expose expression language support for hstore's > operators (?, ->, ||, and so forth) to manipulate them server-side. > > Any pointers?
start with 0.6, as we've expanded the capability for types to directly affect how various operators are rendered, as well as to drive the return type of expressions, which in turn allows that expression to have a say in its own usage in another expression, as well as affects result row behavior. if hstore represents a python value that is "mutable" (which a dict would be), mixing in MutableType will cause the ORM to maintain a copy of the original version of the attribute in order to check for changes. > > Thanks, > -Kyle > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
