Sunday, October 14, 2007

Statistics DB

[It's been a month since my last post. My apologies.]
Me Tube
 While waiting for some videos to upload, (and some video editing shareware to download), I'll do a little coding.

Canonical Items
 In my last session, I got rid of a few references to Canonical Items. I'm pretty sure that this object is no longer necessary, so I'm going to scour all remaining references from the code. First, I'll rename the object and run some tests. Excellent, nothing failed. Ok, time to just delete it. Done. Tests? Still pass.

DB Statistic
 Ok, next object to databasify is Statistic. Pretty simple, actually:

STATISTIC
statistic_id int
name  varchar(255) <-- unique
abbreviation varchar(8)
 
 Ok, there will be a brief pause while I go through the 12 steps to set this table and procs and code up. Well, you won't notice the pause, which is good - all the uploading/downloading is taxing my system, so it's a bit slower than normal.
 Done. Now to run a test. Passed. That was surprisingly easy. Now to scour the code and get rid of CCanonicalStatistics.
 On second thought, it may be useful to keep this object around as a collection of available statistics. While I don't often have any reason to walk through all existing items or effects, statistics are a different story. However, doing much more work in this area at this point would be speculative future-proofing, which I'm trying to avoid.
 Instead, I'll go do some laundry. See you next time.