[Grok-dev] Re: STORM howto

[Martijn Faassen]

Wichert Akkerman wrote:
> Previously Martijn Faassen wrote:
>> The other point that bothers me about Storm is that they do not have a 
>> database schema abstraction in Python. It's not possible to generate a 
>> RDB schema from Python. They do not generate "create table" statements 
>> at all.
> 
> SQLAlchemy has that option and it is extremely useful for testing: your
> test fixture can setup a sqlite in-memory database and tell SQLAlchemy
> to create the tables and indexes in something like two lines of code and
> you're off.

That's indeed useful. Of course you can do this by directly sending 
create table statements too, but it'll be harder to port your code to 
another database.

 > collective.mercury has code to do that. See
 > 
http://svn.plone.org/svn/collective.mercury/trunk/collective/mercury/sa2zs.py

Interesting, thanks!

Regards,

Martijn