[Maypole] Converting an existing app to Maypole

Karen Cravens karen.cravens@gmail.com
Sun, 6 Jun 2004 13:48:58 -0500


In between other projects, I've been trying to get my head wrapped
around Maypole.  There's something I haven't seen addressed in the
examples, and I haven't played at all with Class::DBI, so I'm not sure
if it's even doable.

The church has got an app that runs under PHP and MySQL - InfoCentral.
 It's the only thing that runs PHP, and we'd really like to eliminate
it so that we can retire that server. The website server runs mod_perl
Apache, and (after trashing a test server) we've come to the
conclusion that everyone who says you shouldn't have mod_perl and PHP
on the same install is quite correct. So the alternatives become
compiling a second instance of Apache or, and this is of course my
preference, turning it into a Perl app. The more so because it's
fairly bare-bones as is and we'd like to extend it.  That's a long way
of saying "I didn't name the fields and I'd rather not rename them if
I can help it."

So.  The table "person_per" holds all the persons, as you might guess,
primary key of per_ID, and (among other fields), per_fam_ID, which
correspondes to the primary key in "family_fam" which is named fam_ID.

Far as I can tell, all of the examples show corresponding field names.
 Is that required?  I'm guessing I can do something with
inflate/deflate to link person.per_fam_ID and family.fam_ID, but I
haven't  pursued it thoroughly yet, and I'd like to know if there's an
easier way, or if I'm missing something braindead obvious.