Forgot to include the list. Sorry. ---------- Forwarded message ---------- From: Mark Lybrand <mlybr...@gmail.com> Date: Sun, Dec 4, 2011 at 12:59 AM Subject: Re: [Tutor] Python Saved the Day To: wesley chun <wes...@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 <wes...@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 <mlybr...@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 :)
_______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
