[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.