Renamed Visitor to Validator::Visitor to conform with Data::DPath::Validator and...
[catagits/Catalyst-Controller-DBIC-API.git] / lib / Catalyst / Controller / DBIC / API.pm
CommitLineData
d2739840 1package Catalyst::Controller::DBIC::API;
2
3#ABSTRACT: Provides a DBIx::Class web service automagically
4use Moose;
a784948c 5BEGIN { extends 'Catalyst::Controller::ActionRole'; }
d2739840 6
7use CGI::Expand ();
8use DBIx::Class::ResultClass::HashRefInflator;
9use JSON::Any;
10use Test::Deep::NoTest('eq_deeply');
11use MooseX::Types::Moose(':all');
12use Moose::Util;
13use Scalar::Util('blessed', 'reftype');
14use Try::Tiny;
15use Catalyst::Controller::DBIC::API::Request;
16use namespace::autoclean;
17
d6993542 18with 'Catalyst::Controller::DBIC::API::StoredResultSource',
19 'Catalyst::Controller::DBIC::API::StaticArguments',
20 'Catalyst::Controller::DBIC::API::RequestArguments' => { static => 1 };
d2739840 21
22__PACKAGE__->config();
23
24=head1 SYNOPSIS
25
26 package MyApp::Controller::API::RPC::Artist;
27 use Moose;
28 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC' }
29
30 __PACKAGE__->config
31 ( action => { setup => { PathPart => 'artist', Chained => '/api/rpc/rpc_base' } }, # define parent chain action and partpath
d6993542 32 class => 'MyAppDB::Artist',
33 create_requires => ['name', 'age'],
34 create_allows => ['nickname'],
35 update_allows => ['name', 'age', 'nickname'],
36 update_allows => ['name', 'age', 'nickname'],
37 select => [qw/name age/],
38 prefetch => ['cds'],
39 prefetch_allows => [
d2739840 40 'cds',
41 qw/ cds /,
42 { cds => 'tracks' },
d6993542 43 { cds => [qw/ tracks /] },
d2739840 44 ],
d6993542 45 ordered_by => [qw/age/],
46 search_exposes => [qw/age nickname/, { cds => [qw/title year/] }],
47 data_root => 'data',
48 use_json_boolean => 1,
49 return_object => 1,
d2739840 50 );
51
52 # Provides the following functional endpoints:
53 # /api/rpc/artist/create
54 # /api/rpc/artist/list
55 # /api/rpc/artist/id/[id]/delete
56 # /api/rpc/artist/id/[id]/update
57=cut
58
533075c7 59=method_private begin
60
61 :Private
62
63begin is provided in the base class to setup the Catalyst Request object, by applying the DBIC::API::Request role.
64
65=cut
66
67sub begin :Private
68{
69 my ($self, $c) = @_;
70
71 Catalyst::Controller::DBIC::API::Request->meta->apply($c->req)
72 unless Moose::Util::does_role($c->req, 'Catalyst::Controller::DBIC::API::Request');
73}
74
d2739840 75=method_protected setup
76
77 :Chained('specify.in.subclass.config') :CaptureArgs(0) :PathPart('specify.in.subclass.config')
78
79This action is the chain root of the controller. It must either be overridden or configured to provide a base pathpart to the action and also a parent action. For example, for class MyAppDB::Track you might have
80
81 package MyApp::Controller::API::RPC::Track;
406086f3 82 use Moose;
533075c7 83 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC'; }
d2739840 84
85 __PACKAGE__->config
406086f3 86 ( action => { setup => { PathPart => 'track', Chained => '/api/rpc/rpc_base' } },
d2739840 87 ...
88 );
89
90 # or
91
92 sub setup :Chained('/api/rpc_base') :CaptureArgs(0) :PathPart('track') {
93 my ($self, $c) = @_;
94
95 $self->next::method($c);
96 }
97
533075c7 98This action does nothing by default.
d2739840 99
100=cut
101
533075c7 102sub setup :Chained('specify.in.subclass.config') :CaptureArgs(0) :PathPart('specify.in.subclass.config') {}
d2739840 103
104=method_protected deserialize
105
533075c7 106 :Chained('setup') :CaptureArgs(0) :PathPart('') :ActionClass('Deserialize')
107
d2739840 108deserialize absorbs the request data and transforms it into useful bits by using CGI::Expand->expand_hash and a smattering of JSON::Any->from_json for a handful of arguments. Current only the following arguments are capable of being expressed as JSON:
109
110 search_arg
111 count_arg
112 page_arg
113 ordered_by_arg
114 grouped_by_arg
115 prefetch_arg
116
533075c7 117It should be noted that arguments can used mixed modes in with some caveats. Each top level arg can be expressed as CGI::Expand with their immediate child keys expressed as JSON when sending the data application/x-www-form-urlencoded. Otherwise, you can send content as raw json and it will be deserialized as is with no CGI::Expand expasion.
d2739840 118
119=cut
120
8cf0b66a 121sub deserialize :Chained('setup') :CaptureArgs(0) :PathPart('') :ActionClass('Deserialize')
d2739840 122{
d2739840 123 my ($self, $c) = @_;
124 my $req_params;
125
126 if ($c->req->data && scalar(keys %{$c->req->data}))
127 {
128 $req_params = $c->req->data;
129 }
406086f3 130 else
d2739840 131 {
132 $req_params = CGI::Expand->expand_hash($c->req->params);
133
33003023 134 foreach my $param (@{[$self->search_arg, $self->count_arg, $self->page_arg, $self->offset_arg, $self->ordered_by_arg, $self->grouped_by_arg, $self->prefetch_arg]})
d2739840 135 {
136 # these params can also be composed of JSON
137 # but skip if the parameter is not provided
138 next if not exists $req_params->{$param};
139 # find out if CGI::Expand was involved
140 if (ref $req_params->{$param} eq 'HASH')
141 {
142 for my $key ( keys %{$req_params->{$param}} )
143 {
144 try
145 {
146 my $deserialized = JSON::Any->from_json($req_params->{$param}->{$key});
147 $req_params->{$param}->{$key} = $deserialized;
148 }
149 catch
406086f3 150 {
d2739840 151 $c->log->debug("Param '$param.$key' did not deserialize appropriately: $_")
152 if $c->debug;
153 }
154 }
155 }
156 else
157 {
158 try
159 {
160 my $deserialized = JSON::Any->from_json($req_params->{$param});
161 $req_params->{$param} = $deserialized;
162 }
163 catch
406086f3 164 {
d2739840 165 $c->log->debug("Param '$param' did not deserialize appropriately: $_")
166 if $c->debug;
167 }
168 }
169 }
170 }
406086f3 171
d2739840 172 $self->inflate_request($c, $req_params);
173}
174
9a29ee35 175=method_protected generate_rs
176
177generate_rs is used by inflate_request to generate the resultset stored in the current request. It receives $c as its only argument. And by default it merely returns the resultset from the stored_result_source on the controller. Override this method if you need to manipulate the default implementation of getting the resultset from the controller.
178
179=cut
180
181sub generate_rs
182{
def4bb3d 183 #my ($self, $c) = @_;
184 my ($self) = @_;
185
9a29ee35 186 return $self->stored_result_source->resultset;
187}
188
d2739840 189=method_protected inflate_request
406086f3 190
d2739840 191inflate_request is called at the end of deserialize to populate key portions of the request with the useful bits
192
193=cut
194
195sub inflate_request
196{
d2739840 197 my ($self, $c, $params) = @_;
198
199 try
200 {
201 # set static arguments
406086f3 202 $c->req->_set_controller($self);
d2739840 203
204 # set request arguments
205 $c->req->_set_request_data($params);
8cf0b66a 206
207 # set the current resultset
9a29ee35 208 $c->req->_set_current_result_set($self->generate_rs($c));
406086f3 209
d2739840 210 }
211 catch
212 {
213 $c->log->error($_);
214 $self->push_error($c, { message => $_ });
215 $c->detach();
216 }
8cf0b66a 217}
218
219=method_protected object_with_id
220
221 :Chained('deserialize') :CaptureArgs(1) :PathPart('')
222
223This action is the chain root for all object level actions (such as delete and update) that operate on a single identifer. The provided identifier will be used to find that particular object and add it to the request's store of objects. Please see L<Catalyst::Controller::DBIC::API::Context> for more details on the stored objects.
224
225=cut
226
227sub object_with_id :Chained('deserialize') :CaptureArgs(1) :PathPart('')
228{
229 my ($self, $c, $id) = @_;
230
231 my $vals = $c->req->request_data->{$self->data_root};
232 unless(defined($vals))
233 {
234 # no data root, assume the request_data itself is the payload
235 $vals = $c->req->request_data;
236 }
237
238 try
239 {
240 # there can be only one set of data
241 $c->req->add_object([$self->object_lookup($c, $id), $vals]);
242 }
243 catch
244 {
245 $c->log->error($_);
246 $self->push_error($c, { message => $_ });
247 $c->detach();
248 }
249}
250
251=method_protected objects_no_id
252
253 :Chained('deserialize') :CaptureArgs(0) :PathPart('')
254
255This action is the chain root for object level actions (such as create, update, or delete) that can involve more than one object. The data stored at the data_root of the request_data will be interpreted as an array of hashes on which to operate. If the hashes are missing an 'id' key, they will be considered a new object to be created. Otherwise, the values in the hash will be used to perform an update. As a special case, a single hash sent will be coerced into an array. Please see L<Catalyst::Controller::DBIC::API::Context> for more details on the stored objects.
256
257=cut
258
259sub objects_no_id :Chained('deserialize') :CaptureArgs(0) :PathPart('')
260{
261 my ($self, $c) = @_;
406086f3 262
533075c7 263 if($c->req->has_request_data)
8cf0b66a 264 {
533075c7 265 my $data = $c->req->request_data;
266 my $vals;
406086f3 267
533075c7 268 if(exists($data->{$self->data_root}) && defined($data->{$self->data_root}))
8cf0b66a 269 {
533075c7 270 my $root = $data->{$self->data_root};
271 if(reftype($root) eq 'ARRAY')
272 {
273 $vals = $root;
274 }
275 elsif(reftype($root) eq 'HASH')
276 {
277 $vals = [$root];
278 }
279 else
280 {
281 $c->log->error('Invalid request data');
282 $self->push_error($c, { message => 'Invalid request data' });
283 $c->detach();
284 }
8cf0b66a 285 }
533075c7 286 else
8cf0b66a 287 {
533075c7 288 # no data root, assume the request_data itself is the payload
289 $vals = [$c->req->request_data];
8cf0b66a 290 }
533075c7 291
292 foreach my $val (@$vals)
8cf0b66a 293 {
533075c7 294 unless(exists($val->{id}))
295 {
296 $c->req->add_object([$c->req->current_result_set->new_result({}), $val]);
297 next;
298 }
299
300 try
301 {
302 $c->req->add_object([$self->object_lookup($c, $val->{id}), $val]);
303 }
304 catch
305 {
306 $c->log->error($_);
307 $self->push_error($c, { message => $_ });
308 $c->detach();
309 }
8cf0b66a 310 }
311 }
312}
313
314=method_protected object_lookup
315
316This method provides the look up functionality for an object based on 'id'. It is passed the current $c and the $id to be used to perform the lookup. Dies if there is no provided $id or if no object was found.
317
318=cut
319
320sub object_lookup
321{
322 my ($self, $c, $id) = @_;
323
324 die 'No valid ID provided for look up' unless defined $id and length $id;
325 my $object = $c->req->current_result_set->find($id);
326 die "No object found for id '$id'" unless defined $object;
327 return $object;
d2739840 328}
329
330=method_protected list
331
3d85db11 332list's steps are broken up into three distinct methods: L</list_munge_parameters>, L</list_perform_search>, and L</list_format_output>.
d2739840 333
73517f50 334The goal of this method is to call ->search() on the current_result_set, HashRefInflator the result, and return it in $c->stash->{response}->{$self->data_root}. Please see the individual methods for more details on what actual processing takes place.
d2739840 335
336If the L</select> config param is defined then the hashes will contain only those columns, otherwise all columns in the object will be returned. L</select> of course supports the function/procedure calling semantics that L<DBIx::Class::ResultSet/select>. In order to have proper column names in the result, provide arguments in L</as> (which also follows L<DBIx::Class::ResultSet/as> semantics. Similarly L</count>, L</page>, L</grouped_by> and L</ordered_by> affect the maximum number of rows returned as well as the ordering and grouping. Note that if select, count, ordered_by or grouped_by request parameters are present then these will override the values set on the class with select becoming bound by the select_exposes attribute.
337
d666a194 338If not all objects in the resultset are required then it's possible to pass conditions to the method as request parameters. You can use a JSON string as the 'search' parameter for maximum flexibility or use L<CGI::Expand> syntax. In the second case the request parameters are expanded into a structure and then used as the search condition.
d2739840 339
340For example, these request parameters:
341
342 ?search.name=fred&search.cd.artist=luke
343 OR
344 ?search={"name":"fred","cd": {"artist":"luke"}}
345
346Would result in this search (where 'name' is a column of the schema class, 'cd' is a relation of the schema class and 'artist' is a column of the related class):
347
348 $rs->search({ name => 'fred', 'cd.artist' => 'luke' }, { join => ['cd'] })
349
350It is also possible to use a JSON string for expandeded parameters:
351
352 ?search.datetime={"-between":["2010-01-06 19:28:00","2010-01-07 19:28:00"]}
353
354Note that if pagination is needed, this can be achieved using a combination of the L</count> and L</page> parameters. For example:
355
356 ?page=2&count=20
357
358Would result in this search:
406086f3 359
d2739840 360 $rs->search({}, { page => 2, rows => 20 })
361
362=cut
363
3d85db11 364sub list
d2739840 365{
d2739840 366 my ($self, $c) = @_;
367
368 $self->list_munge_parameters($c);
369 $self->list_perform_search($c);
370 $self->list_format_output($c);
533075c7 371
372 # make sure there are no objects lingering
406086f3 373 $c->req->clear_objects();
d2739840 374}
375
376=method_protected list_munge_parameters
377
378list_munge_parameters is a noop by default. All arguments will be passed through without any manipulation. In order to successfully manipulate the parameters before the search is performed, simply access $c->req->search_parameters|search_attributes (ArrayRef and HashRef respectively), which correspond directly to ->search($parameters, $attributes). Parameter keys will be in already-aliased form.
2abdb831 379To store the munged parameters call $c->req->_set_search_parameters($newparams) and $c->req->_set_search_attributes($newattrs).
d2739840 380
381=cut
382
383sub list_munge_parameters { } # noop by default
384
385=method_protected list_perform_search
386
387list_perform_search executes the actual search. current_result_set is updated to contain the result returned from ->search. If paging was requested, search_total_entries will be set as well.
388
389=cut
390
391sub list_perform_search
392{
d2739840 393 my ($self, $c) = @_;
406086f3 394
395 try
d2739840 396 {
397 my $req = $c->req;
406086f3 398
d2739840 399 my $rs = $req->current_result_set->search
400 (
406086f3 401 $req->search_parameters,
d2739840 402 $req->search_attributes
403 );
404
405 $req->_set_current_result_set($rs);
406
407 $req->_set_search_total_entries($req->current_result_set->pager->total_entries)
df8f3121 408 if $req->has_search_attributes && (exists($req->search_attributes->{page}) && defined($req->search_attributes->{page}) && length($req->search_attributes->{page}));
d2739840 409 }
410 catch
411 {
412 $c->log->error($_);
413 $self->push_error($c, { message => 'a database error has occured.' });
414 $c->detach();
415 }
416}
417
418=method_protected list_format_output
419
420list_format_output prepares the response for transmission across the wire. A copy of the current_result_set is taken and its result_class is set to L<DBIx::Class::ResultClass::HashRefInflator>. Each row in the resultset is then iterated and passed to L</row_format_output> with the result of that call added to the output.
421
422=cut
423
424sub list_format_output
425{
d2739840 426 my ($self, $c) = @_;
427
428 my $rs = $c->req->current_result_set->search;
429 $rs->result_class('DBIx::Class::ResultClass::HashRefInflator');
406086f3 430
d2739840 431 try
432 {
433 my $output = {};
434 my $formatted = [];
406086f3 435
d2739840 436 foreach my $row ($rs->all)
437 {
4cb15235 438 push(@$formatted, $self->row_format_output($c, $row));
d2739840 439 }
406086f3 440
d2739840 441 $output->{$self->data_root} = $formatted;
442
443 if ($c->req->has_search_total_entries)
444 {
445 $output->{$self->total_entries_arg} = $c->req->search_total_entries + 0;
446 }
447
448 $c->stash->{response} = $output;
449 }
450 catch
451 {
452 $c->log->error($_);
453 $self->push_error($c, { message => 'a database error has occured.' });
454 $c->detach();
455 }
456}
457
458=method_protected row_format_output
459
4cb15235 460row_format_output is called each row of the inflated output generated from the search. It receives two arguments, the catalyst context and the hashref that represents the row. By default, this method is merely a passthrough.
d2739840 461
462=cut
463
4cb15235 464sub row_format_output
465{
def4bb3d 466 #my ($self, $c, $row) = @_;
467 my ($self, undef, $row) = @_;
4cb15235 468 return $row; # passthrough by default
469}
d2739840 470
609916e5 471=method_protected item
609916e5 472
473item will return a single object called by identifier in the uri. It will be inflated via each_object_inflate.
474
475=cut
476
3d85db11 477sub item
609916e5 478{
479 my ($self, $c) = @_;
480
481 if($c->req->count_objects != 1)
482 {
483 $c->log->error($_);
484 $self->push_error($c, { message => 'No objects on which to operate' });
485 $c->detach();
486 }
487 else
488 {
533075c7 489 $c->stash->{response}->{$self->item_root} = $self->each_object_inflate($c, $c->req->get_object(0)->[0]);
609916e5 490 }
491}
492
d2739840 493=method_protected update_or_create
494
b421ef50 495update_or_create is responsible for iterating any stored objects and performing updates or creates. Each object is first validated to ensure it meets the criteria specified in the L</create_requires> and L</create_allows> (or L</update_allows>) parameters of the controller config. The objects are then committed within a transaction via L</transact_objects> using a closure around L</save_objects>.
d2739840 496
497=cut
498
3d85db11 499sub update_or_create
d2739840 500{
d2739840 501 my ($self, $c) = @_;
406086f3 502
d2739840 503 if($c->req->has_objects)
504 {
505 $self->validate_objects($c);
2e978a8c 506 $self->transact_objects($c, sub { $self->save_objects($c, @_) } );
d2739840 507 }
508 else
509 {
510 $c->log->error($_);
511 $self->push_error($c, { message => 'No objects on which to operate' });
512 $c->detach();
513 }
514}
515
516=method_protected transact_objects
517
518transact_objects performs the actual commit to the database via $schema->txn_do. This method accepts two arguments, the context and a coderef to be used within the transaction. All of the stored objects are passed as an arrayref for the only argument to the coderef.
519
520=cut
521
522sub transact_objects
523{
d2739840 524 my ($self, $c, $coderef) = @_;
406086f3 525
d2739840 526 try
527 {
528 $self->stored_result_source->schema->txn_do
529 (
530 $coderef,
531 $c->req->objects
532 );
533 }
534 catch
535 {
536 $c->log->error($_);
537 $self->push_error($c, { message => 'a database error has occured.' });
538 $c->detach();
539 }
540}
541
542=method_protected validate_objects
543
544This is a shortcut method for performing validation on all of the stored objects in the request. Each object's provided values (for create or update) are updated to the allowed values permitted by the various config parameters.
545
546=cut
547
548sub validate_objects
549{
d2739840 550 my ($self, $c) = @_;
551
552 try
553 {
554 foreach my $obj ($c->req->all_objects)
555 {
556 $obj->[1] = $self->validate_object($c, $obj);
557 }
558 }
559 catch
560 {
561 my $err = $_;
562 $c->log->error($err);
bec622aa 563 $err =~ s/\s+at\s+.+\n$//g;
d2739840 564 $self->push_error($c, { message => $err });
565 $c->detach();
566 }
567}
568
569=method_protected validate_object
570
571validate_object takes the context and the object as an argument. It then filters the passed values in slot two of the tuple through the create|update_allows configured. It then returns those filtered values. Values that are not allowed are silently ignored. If there are no values for a particular key, no valid values at all, or multiple of the same key, this method will die.
572
573=cut
574
575sub validate_object
576{
d2739840 577 my ($self, $c, $obj) = @_;
578 my ($object, $params) = @$obj;
579
580 my %values;
581 my %requires_map = map
582 {
583 $_ => 1
406086f3 584 }
d2739840 585 @{
406086f3 586 ($object->in_storage)
587 ? []
d2739840 588 : $c->stash->{create_requires} || $self->create_requires
589 };
406086f3 590
d2739840 591 my %allows_map = map
592 {
593 (ref $_) ? %{$_} : ($_ => 1)
406086f3 594 }
d2739840 595 (
406086f3 596 keys %requires_map,
d2739840 597 @{
406086f3 598 ($object->in_storage)
599 ? ($c->stash->{update_allows} || $self->update_allows)
d2739840 600 : ($c->stash->{create_allows} || $self->create_allows)
601 }
602 );
603
604 foreach my $key (keys %allows_map)
605 {
606 # check value defined if key required
607 my $allowed_fields = $allows_map{$key};
406086f3 608
d2739840 609 if (ref $allowed_fields)
610 {
611 my $related_source = $object->result_source->related_source($key);
612 my $related_params = $params->{$key};
613 my %allowed_related_map = map { $_ => 1 } @$allowed_fields;
614 my $allowed_related_cols = ($allowed_related_map{'*'}) ? [$related_source->columns] : $allowed_fields;
406086f3 615
d2739840 616 foreach my $related_col (@{$allowed_related_cols})
617 {
39955b2a 618 if (defined(my $related_col_value = $related_params->{$related_col})) {
d2739840 619 $values{$key}{$related_col} = $related_col_value;
620 }
621 }
622 }
406086f3 623 else
d2739840 624 {
625 my $value = $params->{$key};
626
627 if ($requires_map{$key})
628 {
629 unless (defined($value))
630 {
631 # if not defined look for default
632 $value = $object->result_source->column_info($key)->{default_value};
633 unless (defined $value)
634 {
635 die "No value supplied for ${key} and no default";
636 }
637 }
638 }
406086f3 639
d2739840 640 # check for multiple values
f5113975 641 if (ref($value) && !(reftype($value) eq reftype(JSON::Any::true)))
d2739840 642 {
643 require Data::Dumper;
644 die "Multiple values for '${key}': ${\Data::Dumper::Dumper($value)}";
645 }
646
647 # check exists so we don't just end up with hash of undefs
648 # check defined to account for default values being used
649 $values{$key} = $value if exists $params->{$key} || defined $value;
650 }
651 }
652
406086f3 653 unless (keys %values || !$object->in_storage)
d2739840 654 {
655 die 'No valid keys passed';
656 }
657
406086f3 658 return \%values;
d2739840 659}
660
661=method_protected delete
662
b421ef50 663delete operates on the stored objects in the request. It first transacts the objects, deleting them in the database using L</transact_objects> and a closure around L</delete_objects>, and then clears the request store of objects.
d2739840 664
665=cut
666
3d85db11 667sub delete
d2739840 668{
d2739840 669 my ($self, $c) = @_;
406086f3 670
d2739840 671 if($c->req->has_objects)
672 {
2e978a8c 673 $self->transact_objects($c, sub { $self->delete_objects($c, @_) });
d2739840 674 $c->req->clear_objects;
675 }
676 else
677 {
678 $c->log->error($_);
679 $self->push_error($c, { message => 'No objects on which to operate' });
680 $c->detach();
681 }
682}
683
b421ef50 684=method_protected save_objects
d2739840 685
b421ef50 686This method is used by update_or_create to perform the actual database manipulations. It iterates each object calling L</save_object>.
d2739840 687
b421ef50 688=cut
689
690sub save_objects
691{
2e978a8c 692 my ($self, $c, $objects) = @_;
d2739840 693
b421ef50 694 foreach my $obj (@$objects)
695 {
2e978a8c 696 $self->save_object($c, $obj);
b421ef50 697 }
698}
d2739840 699
b421ef50 700=method_protected save_object
d2739840 701
b421ef50 702save_object first checks to see if the object is already in storage. If so, it calls L</update_object_from_params> otherwise it calls L</insert_object_from_params>
d2739840 703
704=cut
705
b421ef50 706sub save_object
d2739840 707{
2e978a8c 708 my ($self, $c, $obj) = @_;
d2739840 709
b421ef50 710 my ($object, $params) = @$obj;
711
712 if ($object->in_storage)
d2739840 713 {
2e978a8c 714 $self->update_object_from_params($c, $object, $params);
b421ef50 715 }
406086f3 716 else
b421ef50 717 {
2e978a8c 718 $self->insert_object_from_params($c, $object, $params);
b421ef50 719 }
720
721}
722
723=method_protected update_object_from_params
724
f5113975 725update_object_from_params iterates through the params to see if any of them are pertinent to relations. If so it calls L</update_object_relation> with the object, and the relation parameters. Then it calls ->update on the object.
b421ef50 726
727=cut
728
729sub update_object_from_params
730{
2e978a8c 731 my ($self, $c, $object, $params) = @_;
b421ef50 732
733 foreach my $key (keys %$params)
734 {
735 my $value = $params->{$key};
f5113975 736 if (ref($value) && !(reftype($value) eq reftype(JSON::Any::true)))
b421ef50 737 {
2e978a8c 738 $self->update_object_relation($c, $object, delete $params->{$key}, $key);
d2739840 739 }
16337d41 740 # accessor = colname
741 elsif ($object->can($key)) {
742 $object->$key($value);
743 }
744 # accessor != colname
745 else {
746 my $accessor = $object->result_source->column_info($key)->{accessor};
747 $object->$accessor($value);
748 }
d2739840 749 }
406086f3 750
3b12c2cd 751 $object->update();
b421ef50 752}
753
754=method_protected update_object_relation
755
756update_object_relation finds the relation to the object, then calls ->update with the specified parameters
757
758=cut
759
760sub update_object_relation
761{
2e978a8c 762 my ($self, $c, $object, $related_params, $relation) = @_;
b421ef50 763 my $row = $object->find_related($relation, {} , {});
8516bd76 764
765 if ($row) {
3b12c2cd 766 foreach my $key (keys %$related_params) {
767 my $value = $related_params->{$key};
16337d41 768 if (ref($value) && !(reftype($value) eq reftype(JSON::Any::true)))
769 {
770 $self->update_object_relation($c, $row, delete $related_params->{$key}, $key);
771 }
772 # accessor = colname
0f0f8776 773 elsif ($row->can($key)) {
774 $row->$key($value);
16337d41 775 }
776 # accessor != colname
777 else {
0f0f8776 778 my $accessor = $row->result_source->column_info($key)->{accessor};
779 $row->$accessor($value);
16337d41 780 }
3b12c2cd 781 }
782 $row->update();
8516bd76 783 }
784 else {
785 $object->create_related($relation, $related_params);
786 }
b421ef50 787}
788
789=method_protected insert_object_from_params
790
791insert_object_from_params sets the columns for the object, then calls ->insert
792
793=cut
794
795sub insert_object_from_params
796{
def4bb3d 797 #my ($self, $c, $object, $params) = @_;
798 my ($self, undef, $object, $params) = @_;
d8921389 799
800 my %rels;
801 while (my ($k, $v) = each %{ $params }) {
f5113975 802 if (ref($v) && !(reftype($v) eq reftype(JSON::Any::true))) {
d8921389 803 $rels{$k} = $v;
804 }
805 else {
806 $object->set_column($k => $v);
807 }
808 }
809
b421ef50 810 $object->insert;
d8921389 811
812 while (my ($k, $v) = each %rels) {
813 $object->create_related($k, $v);
814 }
d2739840 815}
816
b421ef50 817=method_protected delete_objects
818
819delete_objects iterates through each object calling L</delete_object>
820
821=cut
822
d2739840 823sub delete_objects
824{
2e978a8c 825 my ($self, $c, $objects) = @_;
b421ef50 826
2e978a8c 827 map { $self->delete_object($c, $_->[0]) } @$objects;
b421ef50 828}
829
830=method_protected delete_object
831
832Performs the actual ->delete on the object
833
834=cut
835
836sub delete_object
837{
def4bb3d 838 #my ($self, $c, $object) = @_;
839 my ($self, undef, $object) = @_;
d2739840 840
b421ef50 841 $object->delete;
d2739840 842}
843
844=method_protected end
845
d2739840 846end performs the final manipulation of the response before it is serialized. This includes setting the success of the request both at the HTTP layer and JSON layer. If configured with return_object true, and there are stored objects as the result of create or update, those will be inflated according to the schema and get_inflated_columns
847
848=cut
849
3d85db11 850sub end :Private
d2739840 851{
d2739840 852 my ($self, $c) = @_;
853
854 # check for errors
855 my $default_status;
856
857 # Check for errors caught elsewhere
858 if ( $c->res->status and $c->res->status != 200 ) {
859 $default_status = $c->res->status;
860 $c->stash->{response}->{success} = $self->use_json_boolean ? JSON::Any::false : 'false';
861 } elsif ($self->get_errors($c)) {
862 $c->stash->{response}->{messages} = $self->get_errors($c);
863 $c->stash->{response}->{success} = $self->use_json_boolean ? JSON::Any::false : 'false';
864 $default_status = 400;
865 } else {
866 $c->stash->{response}->{success} = $self->use_json_boolean ? JSON::Any::true : 'true';
867 $default_status = 200;
868 }
406086f3 869
d2739840 870 unless ($default_status == 200)
871 {
872 delete $c->stash->{response}->{$self->data_root};
873 }
874 elsif($self->return_object && $c->req->has_objects)
875 {
d2739840 876 my $returned_objects = [];
c9b8a798 877 push(@$returned_objects, $self->each_object_inflate($c, $_)) for map { $_->[0] } $c->req->all_objects;
d2739840 878 $c->stash->{response}->{$self->data_root} = scalar(@$returned_objects) > 1 ? $returned_objects : $returned_objects->[0];
879 }
880
881 $c->res->status( $default_status || 200 );
882 $c->forward('serialize');
883}
884
c9b8a798 885=method_protected each_object_inflate
886
887each_object_inflate executes during L</end> and allows hooking into the process of inflating the objects to return in the response. Receives, the context, and the object as arguments.
888
889This only executes if L</return_object> if set and if there are any objects to actually return.
890
891=cut
892
893sub each_object_inflate
894{
def4bb3d 895 #my ($self, $c, $object) = @_;
896 my ($self, undef, $object) = @_;
d2739840 897
8ee81496 898 return { $object->get_columns };
d2739840 899}
900
b66d4310 901=method_protected serialize
902
903multiple actions forward to serialize which uses Catalyst::Action::Serialize.
904
905=cut
906
c9b8a798 907# from Catalyst::Action::Serialize
908sub serialize :ActionClass('Serialize') { }
909
d2739840 910=method_protected push_error
911
912push_error stores an error message into the stash to be later retrieved by L</end>. Accepts a Dict[message => Str] parameter that defines the error message.
913
914=cut
915
916sub push_error
917{
918 my ( $self, $c, $params ) = @_;
7821bdec 919 my $error = 'unknown error';
920 if (exists $params->{message}) {
921 $error = $params->{message};
922 # remove newline from die "error message\n" which is required to not
923 # have the filename and line number in the error text
924 $error =~ s/\n$//;
925 }
926 push( @{$c->stash->{_dbic_crud_errors}}, $error);
d2739840 927}
928
929=method_protected get_errors
930
931get_errors returns all of the errors stored in the stash
932
933=cut
934
935sub get_errors
936{
937 my ( $self, $c ) = @_;
938 return $c->stash->{_dbic_crud_errors};
939}
940
941=head1 DESCRIPTION
942
943Easily provide common API endpoints based on your L<DBIx::Class> schema classes. Module provides both RPC and REST interfaces to base functionality. Uses L<Catalyst::Action::Serialize> and L<Catalyst::Action::Deserialize> to serialise response and/or deserialise request.
944
945=head1 OVERVIEW
946
947This document describes base functionlity such as list, create, delete, update and the setting of config attributes. L<Catalyst::Controller::DBIC::API::RPC> and L<Catalyst::Controller::DBIC::API::REST> describe details of provided endpoints to those base methods.
948
949You will need to create a controller for each schema class you require API endpoints for. For example if your schema has Artist and Track, and you want to provide a RESTful interface to these, you should create MyApp::Controller::API::REST::Artist and MyApp::Controller::API::REST::Track which both subclass L<Catalyst::Controller::DBIC::API::REST>. Similarly if you wanted to provide an RPC style interface then subclass L<Catalyst::Controller::DBIC::API::RPC>. You then configure these individually as specified in L</CONFIGURATION>.
950
951Also note that the test suite of this module has an example application used to run tests against. It maybe helpful to look at that until a better tutorial is written.
952
953=head2 CONFIGURATION
954
955Each of your controller classes needs to be configured to point at the relevant schema class, specify what can be updated and so on, as shown in the L</SYNOPSIS>.
956
957The class, create_requires, create_allows and update_requires parameters can also be set in the stash like so:
958
959 sub setup :Chained('/api/rpc/rpc_base') :CaptureArgs(1) :PathPart('any') {
960 my ($self, $c, $object_type) = @_;
961
962 if ($object_type eq 'artist') {
963 $c->stash->{class} = 'MyAppDB::Artist';
964 $c->stash->{create_requires} = [qw/name/];
965 $c->stash->{update_allows} = [qw/name/];
966 } else {
967 $self->push_error($c, { message => "invalid object_type" });
968 return;
969 }
970
971 $self->next::method($c);
972 }
973
974Generally it's better to have one controller for each DBIC source with the config hardcoded, but in some cases this isn't possible.
975
976Note that the Chained, CaptureArgs and PathPart are just standard Catalyst configuration parameters and that then endpoint specified in Chained - in this case '/api/rpc/rpc_base' - must actually exist elsewhere in your application. See L<Catalyst::DispatchType::Chained> for more details.
977
978Below are explanations for various configuration parameters. Please see L<Catalyst::Controller::DBIC::API::StaticArguments> for more details.
979
980=head3 class
981
982Whatever you would pass to $c->model to get a resultset for this class. MyAppDB::Track for example.
983
984=head3 data_root
985
986By default, the response data is serialized into $c->stash->{response}->{$self->data_root} and data_root defaults to 'list' to preserve backwards compatibility. This is now configuable to meet the needs of the consuming client.
987
988=head3 use_json_boolean
989
990By default, the response success status is set to a string value of "true" or "false". If this attribute is true, JSON::Any's true() and false() will be used instead. Note, this does not effect other internal processing of boolean values.
991
992=head3 count_arg, page_arg, select_arg, search_arg, grouped_by_arg, ordered_by_arg, prefetch_arg, as_arg, total_entries_arg
993
994These attributes allow customization of the component to understand requests made by clients where these argument names are not flexible and cannot conform to this components defaults.
995
996=head3 create_requires
997
998Arrayref listing columns required to be passed to create in order for the request to be valid.
999
1000=head3 create_allows
1001
1002Arrayref listing columns additional to those specified in create_requires that are not required to create but which create does allow. Columns passed to create that are not listed in create_allows or create_requires will be ignored.
1003
1004=head3 update_allows
1005
1006Arrayref listing columns that update will allow. Columns passed to update that are not listed here will be ignored.
1007
1008=head3 select
1009
1010Arguments to pass to L<DBIx::Class::ResultSet/select> when performing search for L</list>.
1011
1012=head3 as
1013
1014Complements arguments passed to L<DBIx::Class::ResultSet/select> when performing a search. This allows you to specify column names in the result for RDBMS functions, etc.
1015
1016=head3 select_exposes
1017
1018Columns and related columns that are okay to return in the resultset since clients can request more or less information specified than the above select argument.
1019
1020=head3 prefetch
1021
1022Arguments to pass to L<DBIx::Class::ResultSet/prefetch> when performing search for L</list>.
1023
1024=head3 prefetch_allows
1025
1026Arrayref listing relationships that are allowed to be prefetched.
1027This is necessary to avoid denial of service attacks in form of
1028queries which would return a large number of data
1029and unwanted disclosure of data.
1030
1031=head3 grouped_by
1032
1033Arguments to pass to L<DBIx::Class::ResultSet/group_by> when performing search for L</list>.
1034
1035=head3 ordered_by
1036
1037Arguments to pass to L<DBIx::Class::ResultSet/order_by> when performing search for L</list>.
1038
1039=head3 search_exposes
1040
1041Columns and related columns that are okay to search on. For example if only the position column and all cd columns were to be allowed
1042
1043 search_exposes => [qw/position/, { cd => ['*'] }]
1044
1045You can also use this to allow custom columns should you wish to allow them through in order to be caught by a custom resultset. For example:
1046
1047 package RestTest::Controller::API::RPC::TrackExposed;
406086f3 1048
d2739840 1049 ...
406086f3 1050
d2739840 1051 __PACKAGE__->config
1052 ( ...,
1053 search_exposes => [qw/position title custom_column/],
1054 );
1055
1056and then in your custom resultset:
1057
1058 package RestTest::Schema::ResultSet::Track;
406086f3 1059
d2739840 1060 use base 'RestTest::Schema::ResultSet';
406086f3 1061
d2739840 1062 sub search {
1063 my $self = shift;
1064 my ($clause, $params) = @_;
1065
1066 # test custom attrs
1067 if (my $pretend = delete $clause->{custom_column}) {
1068 $clause->{'cd.year'} = $pretend;
1069 }
1070 my $rs = $self->SUPER::search(@_);
1071 }
1072
1073=head3 count
1074
1075Arguments to pass to L<DBIx::Class::ResultSet/rows> when performing search for L</list>.
1076
1077=head3 page
1078
04f135e4 1079Arguments to pass to L<DBIx::Class::ResultSet/page> when performing search for L</list>.
d2739840 1080
1081=head1 EXTENDING
1082
1083By default the create, delete and update actions will not return anything apart from the success parameter set in L</end>, often this is not ideal but the required behaviour varies from application to application. So normally it's sensible to write an intermediate class which your main controller classes subclass from.
1084
1085For example if you wanted create to return the JSON for the newly created object you might have something like:
1086
1087 package MyApp::ControllerBase::DBIC::API::RPC;
1088 ...
1089 use Moose;
1090 BEGIN { extends 'Catalyst::Controller::DBIC::API::RPC' };
1091 ...
1092 sub create :Chained('setup') :Args(0) :PathPart('create') {
1093 my ($self, $c) = @_;
1094
1095 # $c->req->all_objects will contain all of the created
1096 $self->next::method($c);
1097
406086f3 1098 if ($c->req->has_objects) {
d2739840 1099 # $c->stash->{response} will be serialized in the end action
1100 $c->stash->{response}->{$self->data_root} = [ map { { $_->get_inflated_columns } } ($c->req->all_objects) ] ;
1101 }
1102 }
1103
d2739840 1104 package MyApp::Controller::API::RPC::Track;
1105 ...
1106 use Moose;
1107 BEGIN { extends 'MyApp::ControllerBase::DBIC::API::RPC' };
1108 ...
1109
d666a194 1110It should be noted that the return_object attribute will produce the above result for you, free of charge.
d2739840 1111
d2739840 1112Similarly you might want create, update and delete to all forward to the list action once they are done so you can refresh your view. This should also be simple enough.
1113
406086f3 1114If more extensive customization is required, it is recommened to peer into the roles that comprise the system and make use
d2739840 1115
1116=head1 NOTES
1117
1118It should be noted that version 1.004 and above makes a rapid depature from the status quo. The internals were revamped to use more modern tools such as Moose and its role system to refactor functionality out into self-contained roles.
1119
1120To this end, internally, this module now understands JSON boolean values (as represented by JSON::Any) and will Do The Right Thing in handling those values. This means you can have ColumnInflators installed that can covert between JSON::Any booleans and whatever your database wants for boolean values.
1121
1122Validation for various *_allows or *_exposes is now accomplished via Data::DPath::Validator with a lightly simplified, via subclass, Data::DPath::Validator::Visitor. The rough jist of the process goes as follows: Arguments provided to those attributes are fed into the Validator and Data::DPaths are generated. Then, incoming requests are validated against these paths generated. The validator is set in "loose" mode meaning only one path is required to match. For more information, please see L<Data::DPath::Validator> and more specifically L<Catalyst::Controller::DBIC::API::Validator>.
1123
1124Since 2.00100:
1125Transactions are used. The stash is put aside in favor of roles applied to the request object with additional accessors.
1126Error handling is now much more consistent with most errors immediately detaching.
1127The internals are much easier to read and understand with lots more documentation.
1128
1129=cut
1130
11311;