Re: Convert DDL to ORM

2011-10-29 Thread Lie Ryan 

On 10/25/2011 03:30 AM, Alec Taylor wrote:

Good morning,

I'm often generating DDLs from EER-Logical diagrams using tools such
as PowerDesigner and Oracle Data Modeller.

I've recently come across an ORM library (SQLalchemy), and it seems
like a quite useful abstraction.

Is there a way to convert my DDL to ORM code?


It's called reverse engineering. Some ORMs, e.g. Django's ORM can 
reverse engineer the database into Django Models by using `./manage.py 
inspectdb`. I believe the equivalent in SQLalchemy would be SQL 
Autocode, see 
http://turbogears.org/2.1/docs/main/Utilities/sqlautocode.html and 
http://code.google.com/p/sqlautocode/


--
http://mail.python.org/mailman/listinfo/python-list

Convert DDL to ORM

2011-10-24 Thread Alec Taylor 
Good morning,

I'm often generating DDLs from EER-Logical diagrams using tools such
as PowerDesigner and Oracle Data Modeller.

I've recently come across an ORM library (SQLalchemy), and it seems
like a quite useful abstraction.

Is there a way to convert my DDL to ORM code?

Thanks for all suggestions,

Alec Taylor
-- 
http://mail.python.org/mailman/listinfo/python-list

Re: Convert DDL to ORM

2011-10-24 Thread Martin KomoĊˆ 
Hi,

for the project I'm working on right now I've written a simple SQL
create script to ORM generator. I use SQLalchemy as well and this
generator takes all tables and prepares classes, maps them to tables,
introspects them and creates explicit attribute definitions in the
classes. Contact me off-list for more details.

Martin

On 10/24/2011 6:30 PM, Alec Taylor wrote:
 Good morning,
 
 I'm often generating DDLs from EER-Logical diagrams using tools such
 as PowerDesigner and Oracle Data Modeller.
 
 I've recently come across an ORM library (SQLalchemy), and it seems
 like a quite useful abstraction.
 
 Is there a way to convert my DDL to ORM code?
 
 Thanks for all suggestions,
 
 Alec Taylor
-- 
http://mail.python.org/mailman/listinfo/python-list