Sports: October 2001 Archives
OK, today was just one of those days to take care of a lot of little things. That's important, I suppose. Gotta keep up with the little things, or else they turn into several big things.
So what'd I do? Well, I wrote a perl script to mirror my CVS trees (see the SF CVS tarballs for a 4MB listing of all the available CVS trees on the whole system) and file uploads on SF. I am going to extend the script to also mirror my files from CPAN (and other selected files, like versions of perl, etc.).
I wrote some emails.
I found a bug in MySQL, whereby I can do REPLACE INTO table2 SELECT foo,bar,baz,buz FROM table1 WHERE buz=1 and buz will not always be 1 in table2, if bar or baz is NULL in table1, whereas table2 defines those columns as NOT NULL. Yes, the schemas should match, but MySQL should either punt on the whole record, or it should fill in the columns that it can match up properly. Instead, it just drops the rest of the columns for that record. So I try to make bar NULL, and it fails because bar is NOT NULL, so it ends up making bar "", which is fine, except ... it makes the rest of the columns "" (or 0, for numeric columns, etc.). ACK!
I closed some bugs.
I got some new bugs.
I synched up some various sources.
I updated use Perl and Slashcode to the last Slash source from CVS.
I told Jarkko I would test the latest bleadperl on Mac OS.
I watched the latest (repeat) episode of Oz.
I told some people why the Bruins were right to not meet Jason Allison's demands.
I am going to try to get in a few more little things before dinner: update some picks on Pudge's Picks and maybe actually test the latest bleadperl. Yeah, I can do that.
So what'd I do? Well, I wrote a perl script to mirror my CVS trees (see the SF CVS tarballs for a 4MB listing of all the available CVS trees on the whole system) and file uploads on SF. I am going to extend the script to also mirror my files from CPAN (and other selected files, like versions of perl, etc.).
I wrote some emails.
I found a bug in MySQL, whereby I can do REPLACE INTO table2 SELECT foo,bar,baz,buz FROM table1 WHERE buz=1 and buz will not always be 1 in table2, if bar or baz is NULL in table1, whereas table2 defines those columns as NOT NULL. Yes, the schemas should match, but MySQL should either punt on the whole record, or it should fill in the columns that it can match up properly. Instead, it just drops the rest of the columns for that record. So I try to make bar NULL, and it fails because bar is NOT NULL, so it ends up making bar "", which is fine, except ... it makes the rest of the columns "" (or 0, for numeric columns, etc.). ACK!
I closed some bugs.
I got some new bugs.
I synched up some various sources.
I updated use Perl and Slashcode to the last Slash source from CVS.
I told Jarkko I would test the latest bleadperl on Mac OS.
I watched the latest (repeat) episode of Oz.
I told some people why the Bruins were right to not meet Jason Allison's demands.
I am going to try to get in a few more little things before dinner: update some picks on Pudge's Picks and maybe actually test the latest bleadperl. Yeah, I can do that.
I hooked up two satellite cables to my TiVo box, so now I can record two things at once. So right now I am recording the Bruins pregame (and then the Bruins game, following) and Farscape on the TiVo and Enterprise on the VCR (it is not on the dish anyway) and watching 60 Minutes II. Yay.
So I have the wiring mostly done for it. I have another DirecTV receiver upstairs, though. Soon I will do some testing with diplexers and my cable, to make sure it works well with my cable modem and the upstairs TV. Then I will get the multi-switch so I can have all three receivers getting dish singals at once.
I also recently wrote a script (with some modifications to MacPerl) to ask my MP3 player (either locally if running, or over the network otherwise) what is currently playing. I just hit a keyboard shortcut from within any app, it runs a MacPerl script in the background, fetches the data, and sticks it on the clipboard.
NP: I've Been Delivered - Wallflowers (Breach)
So I have the wiring mostly done for it. I have another DirecTV receiver upstairs, though. Soon I will do some testing with diplexers and my cable, to make sure it works well with my cable modem and the upstairs TV. Then I will get the multi-switch so I can have all three receivers getting dish singals at once.
I also recently wrote a script (with some modifications to MacPerl) to ask my MP3 player (either locally if running, or over the network otherwise) what is currently playing. I just hit a keyboard shortcut from within any app, it runs a MacPerl script in the background, fetches the data, and sticks it on the clipboard.
NP: I've Been Delivered - Wallflowers (Breach)
"It is the common fate of the indolent to see their rights become a prey to the active. The condition upon which God hath given liberty to man is eternal vigilance; which condition if he break, servitude is at once the consequence of his crime and the punishment of his guilt."
