Hey this is very nice, a few comments: 1. MutableType is probably going away in 0.8, and even the presence of it causes the ORM to perform very poorly when objects use a MutableType. We have sqlalchemy.ext.mutable now as the alternative. 2. was going to say something about HStoreColumn(HStoreElement, Column) -> HStoreElement(ColumnElement)/Column(ColumnElement), but then I tried out a quick diamond example in Python and I learned something I wasn't clear on earlier about multiple inheritance (Column stays on top of ColumnElement) so thanks for that ! 3. Would HStoreColumn already imply the HStore type ? If you give it a custom __init__, you'd probably also need a _constructor() method which is used by Column to help when it needs to make copies of itself.
On Mar 29, 2012, at 4:01 AM, Uwe Seher wrote: > Hi! > > I am exploring your hstore.py for some days now. At first, i fixed an error > which occured when the hstore-field in the database was empty (see > attachment). At next i found out, that keys in the dictictionary, that shall > be written into the database must be strings and not unicode. Is this the > correct handling of this? > > Thank you for the work! > > Uwe Seher > > > Am Mittwoch, 7. April 2010 06:38:32 UTC+2 schrieb Kyle Schaffrick: > 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? > > Thanks, > -Kyle > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/sqlalchemy/-/U6JuhiAOJQMJ. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > <hstore.py> -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.