This morning I've been working out how to configure a SQLAlchemy mapper to enable me to store an XML blob to relational databases.  Storing the XML element is a bit of  hack right now; ultimately, I want to map all the relevant pieces of the XML to appropriate Python object attributes.  But until I figure that mapping out, I'm saving the XML so in theory I can avoid making yet another API call.
I think I may have found relevant examples to guide me. Â SQLAlchemy comes with a set of examples: Â see docs and code (v 0.6.1) — specifically, the examples for serializing XML. Â The first approach (using PickleType) is a simple and expedient approach, a good enough one to start with. Â I'll come back to study the other ones.
Post a Comment