[Grok-dev] Re: STORM howto

[Wichert Akkerman]

Previously Martijn Faassen wrote:
> 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.

And it would mean maintaining the database schema in two places: python
code and SQL command file. And we don't like duplication :)

Wichert.

-- 
Wichert Akkerman <wichert at wiggy.net>    It is simple to make things.
http://www.wiggy.net/                   It is hard to make things simple.