[Tutor] Fwd: Python Saved the Day

[Mark Lybrand]

Forgot to include the list. Sorry.

---------- Forwarded message ----------
From: Mark Lybrand <mlybrand at gmail.com>
Date: Sun, Dec 4, 2011 at 12:59 AM
Subject: Re: [Tutor] Python Saved the Day
To: wesley chun <wescpy at gmail.com>


The quick process of trying out different ideas, first in IDLE and then in
script was a biggie. List comprehensions rocked.  RE of course (but I still
have some stuff to learn about the differences in Python as compared to
Perl 5).

I was using odbc module to connect to SQL first, but quickly moved to
pyodbc and was much happier.

The problem was an application that uses tables from two separate
databases.  The database server was moved, but the old one was not
disconnected.  Further, a hosts file forced one office to continue to
update the old server.  The tables (12 in total) were rife with foreign key
relationships that needed to be maintained.

Don't misunderstand. I am a total noob in Python.  And everything I wrote
are total hacks.  But it was fun, it was quick and it was accurate.

Oh. One thing that delighted me to no end.  I had a main script that I was
using for processing. But would have to make separate scripts for more
specific analysis of problems that would appear.  The ability to import my
main script and use the functions and constants I defined there was a
godsend.  Oh, and did I mention list comprehensions :)

Mark


On Sun, Dec 4, 2011 at 12:51 AM, wesley chun <wescpy at gmail.com> wrote:

> Congrats! I love hearing stuff like this... keep them coming! I'm curious
> as to how Python was able to help you get your job done this time (without
> going into anything confidential naturally). What was it about the
> language? Or was it specific Python modules/packages you used for the
> analysis?
>
> Does anyone else have similar stories? (I think I may be biased as I use
> Python for everything, trouble or otherwise, so I can't tell the difference
> anymore!)
>
> cheers,
> -wesley
>
>
> On Sun, Dec 4, 2011 at 12:45 AM, Mark Lybrand <mlybrand at gmail.com> wrote:
>
>> No question.   Last weekend I buckled down and learned as much Python as
>> I could (just because I have had an interest to do so for a while).  When I
>> got to work on Monday, there was a serious database issue that needed
>> addressing.  As I was trying to assess the situation, I employed Python to
>> help me do my data analysis.  I was able to sort through all the issues,
>> develop a corrective action plan and verify its accuracy, all in Python.
>> Plan was successfully implemented at 6PM today and all is well again. It
>> was a good week.
>>
>> --
>> Mark :)
>
>
>
> --
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> "Core Python", Prentice Hall, (c)2007,2001
> "Python Fundamentals", Prentice Hall, (c)2009
>     http://corepython.com
>
> wesley.chun : wescpy-gmail.com : @wescpy
> python training and technical consulting
> cyberweb.consulting : silicon valley, ca
> http://cyberwebconsulting.com
>



-- 
Mark :)



-- 
Mark :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20111204/0305f42e/attachment.html>