On Nov 14, 4:19 am, Bruno Desthuilliers <bruno. [EMAIL PROTECTED]> wrote: > len a écrit : > > > > > > > Hi all; > > > I am looking for a little direction in moving from novice python MySQL > > to real world processing. > > > I can connect to MySQL databases and have performed most of the > > various select, create, update, insert, etc given the examples in the > > various books and internet tutorials not to many problems. > > > Here is my problem. I need to start doing this in the really world at > > my company converting some older cobol system and data to python > > programs and MySQL. I have gotten past packed decimal fields and > > various other little tidbits. My problem is the data files aren't > > little three of four field files but Customer File with 98 fields > > etc. I understand building dictionaries and building with zip and I > > have even seen a reference to using __setattr__ in an empty class but > > I'm having a hard time moving past the little code snippts to real > > code. > > > As you can image the data coming from old cobol files fieldname are > > generally very large and tons of code that might start looking like; > > > order['ordhdr_sales_amount'] += order['ordlin_sales_qty'] * order > > ['ordlin_sales_price'] > > > could start becoming quite cumbersum. > > > I'm sure that there is someway to make all of this less verbose using > > classes and such but I need some direction. > > You may want to have a look at SQLAlchemy. It will require some > additional learning, but chances are you'll waste less time than trying > to roll your own half-backed ORM-like system. > > My 2 cents...
I haved looked at SQLAlchemy and will start using it. I do feel that I need to hand code a few things just to get and understanding of whats involved. I find that this usually making the package a little easier to use and generally makes me a better user of the package or at least it has in the past. Len -- http://mail.python.org/mailman/listinfo/python-list
