Python ORM that automatically creates classes from DB schema

Question

Hi,

is there a python ORM (object relational mapper) that has a tool for automatically creating python classes (as code so I can expand them) from a given database schema?

I'm frequently faced with small tasks involving different databases (like importing/exporting from various sources etc.) and I thought python together with the abovementioned tool would be perfect for that.

It should work like Visual Studios ADO.NET/Linq for SQL designer, where I can just drop DB tables and VS creates classes for me ...

Thanks in advance.

Answer 1

Django does this.

http://docs.djangoproject.com/en/1.2/howto/legacy-databases/#howto-legacy-databases

Answer 2

You do not need to produce a source code representation of your classes to be able to expand them.

The only trick is that you need the ORM to generate the classes BEFORE importing the module that defines the derived classes.

Even better, don't use derivation, but use __getattr__ and __setattr__ to implement transparent delegation to the ORM classes.