X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=lib%2FBeerDB.pm;h=23bd39f335c7c7f15d48f5f7f95fe4acff35ef1f;hb=cca6bd0ec8ad4f0325eda70b8db2574bf8c77496;hp=e2c82720c0e0a69690b8ad8765936e4d971d7886;hpb=487f817a072a9c5e88efee32cc99818894074537;p=maypole.git diff --git a/lib/BeerDB.pm b/lib/BeerDB.pm index e2c8272..23bd39f 100644 --- a/lib/BeerDB.pm +++ b/lib/BeerDB.pm @@ -1,26 +1,26 @@ -# vim:ft=perl package BeerDB; -use Apache::MVC; use base 'Apache::MVC'; -sub handler { Apache::MVC::handler("BeerDB", @_) } -BeerDB->set_database("dbi:mysql:beerdb"); -BeerDB->config->{template_root} = "/opt/beer"; -BeerDB->config->{uri_base} = "http://neo.trinity-house.org.uk/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"); +# Change this to the root of the web space. +BeerDB->config->{uri_base} = "http://localhost/beerdb/"; + +# Handpumps should not show up. BeerDB->config->{display_tables} = [qw[beer brewery pub style]]; -BeerDB::Brewery->untaint_columns( - printable => [qw/name notes url/], - #url => [qw/url/] -); +BeerDB::Brewery->untaint_columns( printable => [qw/name notes url/] ); BeerDB::Beer->untaint_columns( printable => [qw/abv name price notes/], integer => [qw/style brewery/], date =>[ qw/date/], ); - -use Class::DBI::Loader::Relationship; BeerDB->config->{loader}->relationship($_) for ( "a brewery produces beers", "a style defines beers", "a pub has beers on handpumps"); - 1;