On 9/26/05, Warren Toomey <[EMAIL PROTECTED]> wrote:
> Hi all, I've just installed Maypole on Apache2/mod_perl/postgresql7, and got
> BeerDB working. I want to try Maypole out on my own database, so I have
> borrowed and altered BeerDB.pm:
>
> package TVGuide;
> TVGuide->setup("dbi:Pg:dbname=tvguide","wkt", "",
> { options => {AutoCommit => 1,PrintError => 1} } );
> TVGuide->config->display_tables([qw[series program]]); etc.
>
> I'm getting an error from Class/DBI/Loader/Generic.pm:
> (table) bogusdata has no primary key. This is correct: there is no PK.
>
> I know I have a steep learning curve, but is there a way for now to
> get Maypole to only load/parse certain tables in the database? I thought
> that display_tables([qw[series program]]) would do this.
>
Yes, in fact it's Class::DBI::Loader that handles loading tables from
the db. You can pass extra options through to the CDBI-L constructor
in the setup() call - they go in the href beside 'options'. Look at
the 'constraint' and 'exclude' options in
http://search.cpan.org/~sri/Class-DBI-Loader-0.22/lib/Class/DBI/Loader/Generic.pm
d.
-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users
