X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=lib%2FApache%2FMVC%2FModel%2FCDBI.pm;h=8d75c30aec1883cb98d23e1af7345ee83780fc31;hb=4c4e58eb02155a43397f30b900c5b30f755cb874;hp=c06703a1fb433d0d6262df880670f28bfa62fc89;hpb=58398cbb7b75bf3106e8503b81ee782178c248c3;p=maypole.git diff --git a/lib/Apache/MVC/Model/CDBI.pm b/lib/Apache/MVC/Model/CDBI.pm index c06703a..8d75c30 100644 --- a/lib/Apache/MVC/Model/CDBI.pm +++ b/lib/Apache/MVC/Model/CDBI.pm @@ -1,10 +1,82 @@ package Apache::MVC::Model::CDBI; -use base 'Apache::MVC::Model::Base'; +use base qw(Apache::MVC::Model::Base Class::DBI); +use Lingua::EN::Inflect::Number qw(to_PL); use Class::DBI::AsForm; use Class::DBI::FromCGI; +use Class::DBI::AbstractSearch; +use CGI::Untaint; +use strict; -sub description { "A poorly defined class" } +sub related { + my ($self, $r) = @_; + # Has-many methods; XXX this is a hack + map {to_PL($_)} + grep { exists $r->{config}{ok_tables}{$_} } + map {$_->table} + keys %{shift->__hasa_list || {}} +} -sub column_names { my $class = shift; map { $_ => ucfirst $_ } $class->columns } +sub do_edit :Exported { + my ($self, $r) = @_; + my $h = CGI::Untaint->new(%{$r->{params}}); + my ($obj) = @{$r->objects}; + if ($obj) { + # We have something to edit + $obj->update_from_cgi($h); + warn "Updating an object ($obj) with ".Dumper($h); use Data::Dumper; + } else { + $obj = $self->create_from_cgi($h); + } + if (my %errors = $obj->cgi_update_errors) { + # Set it up as it was: + warn "There were errors: ".Dumper(\%errors)."\n"; + $r->{template_args}{cgi_params} = $r->{params}; + $r->{template_args}{errors} = \%errors; + $r->{template} = "edit"; + } else { + $r->{template} = "view"; + } + $r->objects([ $obj ]); +} + +sub delete :Exported { + my ($self, $r) = @_; + $_->SUPER::delete for @{ $r->objects }; + $r->objects([ $self->retrieve_all ]); + $r->{template} = "list"; +} + +sub adopt { + my ($self, $child) = @_; + $child->autoupdate(1); + $child->columns( Stringify => qw/ name / ); +} + +sub search :Exported { + return shift->SUPER::search(@_) if caller eq "Class::DBI"; # oops + my ($self, $r) = @_; + my %fields = map {$_ => 1 } $self->columns; + my $oper = "like"; # For now + use Carp; Carp::confess("Urgh") unless ref $r; + my %params = %{$r->{params}}; + my %values = map { $_ => {$oper, $oper eq "like" ? "%".$params{$_}."%" + :$params{$_} } } + grep { $params{$_} and $fields{$_} } keys %params; + + $r->objects([ %values ? $self->search_where(%values) : $self->retrieve_all ]); + $r->template("list"); + $r->{template_args}{search} = 1; +} 1; + +=head1 NAME + +Apache::MVC::Model::CDBI - Model class based on Class::DBI + +=head1 DESCRIPTION + +This is a master model class which uses C to do all the hard +work of fetching rows and representing them as objects; instead, it +concentrates on the actions that can be performed in the URL: +C, C and C.