Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

lachoy (1663)

lachoy
  chris.winters@gmail.com
http://www.cwinters.com/

I am actually Chris Winters; I am actually living in Pittsburgh, Pennsylvania, USA; I am actually married and have three cats. (Guess what one of them is named?) I am the "OpenInteract" guy, which could be good or bad.

Journal of lachoy (1663)

Wednesday February 20, 2002
06:11 PM

Foreign keys, make me feel fine...

[ #2998 ]

The subject is supposed to go along with the song line "Summer Breeze, makes me feel fine...". I didn't know who sung it so off to google we go. Type in summer breeze lyrics and the first hit is for a band called "Type O Negative". Hm, well, that name seems a little... newer than I expected, but people were doing what they felt back then. Follow the link.... well, the lyrics look ok ("Blowin' through the jasmine in my mind") but what's the previous song: "Kill All the White People"?! That doesn't sound too hippie-chic to me! (Of course, they didn't sing the original song, these folks did.)

Anyway, my original point is that I was farting around with foreign key discovery using JDBC today. In my day job I've written a series of Perl classes that takes metadata pulled from a database (currently MS SQL Server) by a fairly small Java program, along with metadata (logical relationship info) created by a fairly small human, and generates lots of Java classes and J2EE deployment descriptors from it. It works pretty well -- flexible development, etc. -- but I hate having to manually enter relationship info.

This sets off a "wouldn't it be cool..." train: if I could just get this stuff from the database. Hey, maybe DBI has this stuff now and I can use it for SPOPS? (Fire up the CPAN shell, install, perldoc) Hey, it's in there! So at some point in the future, you'll be able to point a SPOPS config at one or more tables and have all the relationships just be there. Hm, before I promise anything maybe I should finish the other 238 items on my todo list...

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.