View Single Post
Old February 28 2013, 03:41 PM   #52
Robert Maxwell
Respect the Beef
Robert Maxwell's Avatar
Location: Right behind you!
View Robert Maxwell's Twitter Profile Send a message via ICQ to Robert Maxwell Send a message via AIM to Robert Maxwell Send a message via Windows Live Messenger to Robert Maxwell Send a message via Yahoo to Robert Maxwell
Re: What Are You Working On (And How Are You Getting There)?

If no one minds me being a bit more detailed about something work-related (and if you do, skip this post):

We have a bunch of SQL databases with about 10,000 stored procedures. For those who are unfamiliar with such technology, they are programs stored inside the database itself, so they don't exist as external files you can open up and edit. There is currently no version control on them, so it's difficult to know which ones were modified, when, and to what extent. A daily process dumps all of the procedures from each database into text files--one file for each database, so all the procedures are lumped together. Not exactly conducive to figuring out when something is changed, right?

So, I wrote a little program that scans the archive each day, breaks up the files into their constituent procedures, and then commits all the changes to version control. There were some challenges involved since the archive files are not marked up in such a way that it's very easy to determine where each procedure begins and ends, and the name of the procedure is inserted numerous times into the text of the procedure itself (I have no idea why, frankly), so I have to do some massaging and parsing to make it all work correctly. But work, it does! I am pretty happy with it, and it doesn't interfere with anyone else, which is a good thing.

I love automation.
"Holy shit! It's Beef Supreme!"
The Journeyman - Buy it now! Maybe?
My world simulation project!
My blog
Robert Maxwell is offline   Reply With Quote