HOME
ABOUT

File Comparison With Some DB Bells and Whistles

Posted by: barbara | Date: Nov 04, 2009 | Category: November Post-A-Day python | Comments: 0

Right. So yesterday's post was mind-numbingly simple. But that's the just the file comparison. The script that I actually use also hits the db and generates a slew of additional updates for me, based on the results of that diff.


 #!/usr/bin/python # usage: ./compare.py pwdata102409.txt pwdata103109.txt used_codes_wk6 ...


                Read More

Simple File Comparison

Posted by: barbara | Date: Nov 03, 2009 | Category: November Post-A-Day python | Comments: 3

Without going into too many specifics, one of the things I do on a weekly basis is intake records from one of our vending partners, massage the data a little, and update one of our own tables based on the results. Basically, what I get from this vendor each week ...

Read More

The November Blog-A-Thon

Posted by: barbara | Date: Nov 02, 2009 | Category: November Post-A-Day | Comments: 0

Clearly, I'm already a day behind on the whole "blog every day in November" thing. But since I haven't actually posted in ... almost a year (not since the last PyCon, in fact), I still consider this a step in the right direction.

The thing is, to blog about ...

Read More

Five Songs

Posted by: barbara | Date: May 02, 2009 | Category: | Comments: 0


Read More

Working with the Django admin and legacy databases, pt.3

Posted by: barbara | Date: May 01, 2009 | Category: django | Comments: 6

Part 1 | Part 2

After you've run inspectdb and done all your syncing and basic admin setup, take a peek at the models you generated - depending on the state of your legacy db, you've probably wound up with something that looks like this (column names have ...

Read More