X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=lib%2FBeerDB.pm;h=1f673f27ddc6363e6530ae9e5ce880a0d78ee887;hb=5cccc5a89004f9c514e9d611b5e2a02e9aa28ece;hp=e9f1eb471fc5d775cca4dc9379c2ac4010f88b20;hpb=ce6a4c9c85fd9ea388abc677089564bc46e687be;p=maypole.git diff --git a/lib/BeerDB.pm b/lib/BeerDB.pm index e9f1eb4..1f673f2 100644 --- a/lib/BeerDB.pm +++ b/lib/BeerDB.pm @@ -1,16 +1,29 @@ package BeerDB; 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"); +# 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->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/], + integer => [qw/style brewery score/], date =>[ qw/date/], ); -use Class::DBI::Loader::Relationship; BeerDB->config->{loader}->relationship($_) for ( "a brewery produces beers", "a style defines beers",