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:cwi...@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.
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor