X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=ex%2FBeerDB.pm;h=6df04914611ad19d1f176209c53c49917015cac4;hb=24259799350483f32219fd3755e0bed54f909c54;hp=59c7bb210f35a1c8fdf9f53792139872e02262db;hpb=f80621477b1dfe74dc1a18d5453e3f9225022a78;p=maypole.git diff --git a/ex/BeerDB.pm b/ex/BeerDB.pm index 59c7bb2..6df0491 100644 --- a/ex/BeerDB.pm +++ b/ex/BeerDB.pm @@ -1,24 +1,35 @@ package BeerDB; -use base 'Maypole::Application'; +use Maypole::Application; use Class::DBI::Loader::Relationship; +sub debug { $ENV{BEERDB_DEBUG} } + +BEGIN { # This is the sample application. Change this to the path to your # database. (or use mysql or something) -BeerDB->setup("dbi:SQLite:t/beerdb.db"); -#BeerDB->setup("dbi:mysql:beerdb"); +eval { require DBD::SQLite }; +if ($@) { + BeerDB->setup("dbi:SQLite2:t/beerdb.db"); +} else { + BeerDB->setup("dbi:SQLite:t/beerdb.db"); +} +} + +# Give it a name. +BeerDB->config->application_name('The Beer Database'); # Change this to the root of the web space. -BeerDB->config->{uri_base} = "http://localhost/beerdb/"; +BeerDB->config->uri_base("http://localhost/beerdb/"); #BeerDB->config->{uri_base} = "http://neo.trinity-house.org.uk/beerdb/"; -BeerDB->config->{rows_per_page} = 10; +BeerDB->config->rows_per_page(10); # Handpumps should not show up. BeerDB->config->{display_tables} = [qw[beer brewery pub style]]; BeerDB::Brewery->untaint_columns( printable => [qw/name notes url/] ); BeerDB::Style->untaint_columns( printable => [qw/name notes/] ); BeerDB::Beer->untaint_columns( - printable => [qw/abv name price notes/], + printable => [qw/abv name price notes url/], integer => [qw/style brewery score/], date =>[ qw/date/], ); @@ -26,4 +37,9 @@ BeerDB->config->{loader}->relationship($_) for ( "a brewery produces beers", "a style defines beers", "a pub has beers on handpumps"); + +# For testing classmetadata +sub BeerDB::Beer::classdata :Exported {}; +sub BeerDB::Beer::list_columns { return qw/score name price style brewery url/}; + 1;