X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=lib%2FBeerDB.pm;h=1f673f27ddc6363e6530ae9e5ce880a0d78ee887;hb=5cccc5a89004f9c514e9d611b5e2a02e9aa28ece;hp=afa303ef3ec7e3c4baf92827af30c7adb84fafbf;hpb=87ae6ebbf4e57d27e14f3d1e4e58a8418f28df19;p=maypole.git diff --git a/lib/BeerDB.pm b/lib/BeerDB.pm index afa303e..1f673f2 100644 --- a/lib/BeerDB.pm +++ b/lib/BeerDB.pm @@ -1,16 +1,31 @@ -# vim:ft=perl package BeerDB; -use Apache::MVC; use base 'Apache::MVC'; -sub handler { Apache::MVC::handler("BeerDB", @_) } use Class::DBI::Loader::Relationship; +# This line is required if you don't have Apache calling Perl handlers +# as methods. +sub handler { Apache::MVC::handler(__PACKAGE__, @_) } + +# This is the sample application. Change this to the path to your +# database. (or use mysql or something) +#BeerDB->set_database("dbi:SQLite:t/beerdb.db"); BeerDB->set_database("dbi:mysql:beerdb"); -BeerDB->config->{template_root} = "/opt/beer"; +# Change this to the root of the web space. +#BeerDB->config->{uri_base} = "http://localhost/beerdb/"; BeerDB->config->{uri_base} = "http://neo.trinity-house.org.uk/beerdb/"; -BeerDB::Brewery->columns(Stringify => qw/name/); - -BeerDB->config->{loader}->relationship( "a brewery produces beers" ); -BeerDB->config->{loader}->relationship( "a pub has beers on handpumps"); +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/], + integer => [qw/style brewery score/], + date =>[ qw/date/], +); +BeerDB->config->{loader}->relationship($_) for ( + "a brewery produces beers", + "a style defines beers", + "a pub has beers on handpumps"); 1;