[Tutor] "Object designer" applications - are there any?

[Flynn, Stephen (L & P - IT)]

I'll certainly give it a look-see - thanks Christian

 

I'm going to end up writing converters anyway, as at some point I'm
going to be given (for example) a COBOL copybook for a file and have to
translate that into an Oracle table version (actually I already have
tools to do this, but if I'm going to be learning python via a project,
I might as well do it properly).

 

S.

 

 

________________________________

From: Christian Witts [mailto:cwitts at compuscan.co.za] 
Sent: Friday, August 05, 2011 1:10 PM
To: Flynn, Stephen (L & P - IT)
Cc: Tutor List
Subject: Re: [Tutor] "Object designer" applications - are there any?

 

On 2011/08/05 01:01 PM, Flynn, Stephen (L & P - IT) wrote: 

<snip>
 
It struck me that if I write a "read in Sybase DDL and spit out Oracle
DDL" routine and so forth, I'd get a lot of reuse out of it. However,
I've not done much OOP at all and consequently, my object design skills
are somewhat non-existent. Whilst I have a rough idea of what my
properties my "table" object will have I was looking for something to
help me design it - something which I can say "this is a table object,
it has a name and multiple columns. Columns have a type, a width (which
may be further comprised of scale and precision or just an integer
depending on the column type) and a "nullable" flag.). Oh, and there may
be multiple columns... so maybe a column should be an object too... etc.
 
Anyone know if there are any such kinds of programs out there already
(freeware please - I'll be doing this off my own back so funds are tight
for commercial software). Failing that, does anyone use something for
this kind of thing already, Visio maybe or a spreadsheet. Maybe just
notepad or a post-it?
 
<snip>
 


You could take a look at SQLAlchemy [1] and possibly the migrate [2]
portion of it for schema management. It supports connectivity for both
Sybase and Oracle as well as being able to generate the DDL [3]

[1] http://www.sqlalchemy.org/docs/
[2]
http://packages.python.org/sqlalchemy-migrate/versioning.html#experiment
al-commands
[3]
http://www.sqlalchemy.org/trac/wiki/FAQ#HowcanIgettheCREATETABLEDROPTABL
Eoutputasastring

-- 

Christian Witts
Python Developer

 

Click here
<https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==
HJ1tjFMsX3ETe+EpcmOPU7kNPtDbwPBBNdXC8dmstCo9uQ==>  to report this email
as spam.



This email and any attachment to it are confidential.  Unless you are the intended recipient, you may not use, copy or disclose either the message or any information contained in the message. If you are not the intended recipient, you should delete this email and notify the sender immediately.

Any views or opinions expressed in this email are those of the sender only, unless otherwise stated.  All copyright in any Capita material in this email is reserved.

All emails, incoming and outgoing, may be recorded by Capita and monitored for legitimate business purposes. 

Capita exclude all liability for any loss or damage arising or resulting from the receipt, use or transmission of this email to the fullest extent permitted by law.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20110805/61ea7a83/attachment-0001.html>